Skill
postgres-best-practices
Best practices and guidelines for working with Postgres. Covers schema design, indexing strategies, query optimization, migrations, and common pitfalls. Use when writing SQL, designing database schemas, optimizing queries, or setting up a Postgres database.
Install
git clone https://github.com/neondatabase/postgres-skills /tmp/postgres-skills && ln -s /tmp/postgres-skills/skills/postgres-best-practices ~/.claude/skills/postgres-best-practicesFrom README
Postgres Best Practices Guidelines and best practices for working with Postgres, covering schema design, indexing, query optimization, and common pitfalls. Supported Versions This skill covers PostgreSQL 14 through 18. Version-specific features are tagged (e.g., [PG15+], [PG18+]); environment-dependent examples identify required privileges, extensions, or multi-node . PostgreSQL provides 5 years of support per major version. Always run the latest minor release.