Name: postgres-best-practices
Author: neondatabase

postgres-best-practices

neondatabase/po…s-skills

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.

1914 次安装

53 星标

收录于 2026.03.12

安装命令

$ npx skills add https://github.com/neondatabase/postgres-skills --skill postgres-best-practices

SKILL.md

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 setup.

PostgreSQL provides 5 years of support per major version. Always run the latest minor release.

Version	Initial Release	End of Life
18	September 2025	November 2030
17	September 2024	November 2029
16	September 2023	November 2028
15	October 2022	November 2027
14	September 2021	November 2026

Source: postgresql.org/support/versioning