Guidelines for PostgreSQL schema design, indexing, query optimization, replication, backups, and security.
- What it does
- This skill supplies best-practice guidance for working with PostgreSQL versions 14 through 18. It routes the agent to reference documents covering schema design, indexing, query optimization, query patterns, performance diagnostics, logical replication, hot standby, transaction isolation, backup and restore, security and roles, bulk loading, connection pooling, and major version upgrades. It produces advice and recommendations rather than files or code artifacts.
- When to use it
- Use it when writing SQL, designing database schemas, optimizing queries, or setting up a PostgreSQL database. It is also relevant for replication, backup, security role, and version upgrade questions.
- Requirements
- No scripts or tools are required; it is instructions plus reference documents only. The agent needs no credentials or network access beyond reading the bundled reference files.
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.
Source: postgresql.org/support/versioning
References
