27fe45e, the version that was reviewed and scanned here. Newer commits reach this catalog only after a new review. License: Apache-2.0, by Neon.
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
References
| Area | Resource | When to Use |
|---|---|---|
| Schema Design | references/schema-design.md |
Designing tables, choosing data types, normalizing, partitioning |
| Indexing | references/indexing.md |
Choosing index types, composite indexes, partial/covering indexes |
| Query Optimization | references/query-optimization.md |
Reading EXPLAIN ANALYZE, fixing bottlenecks, planner tuning |
| Query Patterns | references/query-patterns.md |
CTEs, window functions, lateral joins, UPSERT, JSONB, anti-patterns |
| Performance Diagnostics | references/performance-diagnostics.md |
pg_stat views, lock analysis, VACUUM, connection management |
| Logical Replication | references/logical-replication.md |
Pub/sub replication, live migrations, CDC |
| Hot Standby | references/hot-standby.md |
Streaming replication, read replicas, failover |
| Transaction Isolation | references/transaction-isolation.md |
Isolation levels, lost updates, serialization failures, retry logic |
| Backup & Restore | references/backup-restore.md |
pg_dump/pg_restore, pg_basebackup, PITR, recovery |
| Security & Roles | references/security-roles.md |
Privileges, RLS, pg_hba.conf, authentication, SSL |
| Bulk Data Loading | references/bulk-loading.md |
COPY patterns, ETL staging, optimizing large loads, batch ops |
| Connection Pooling | references/connection-pooling.md |
PgBouncer config, pool modes, prepared statements, sizing |
| Major Version Upgrades | references/major-version-upgrades.md |
pg_upgrade, logical replication migration, pre/post checklists |
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
References
| Area | Resource | When to Use |
|---|---|---|
| Schema Design | references/schema-design.md |
Designing tables, choosing data types, normalizing, partitioning |
| Indexing | references/indexing.md |
Choosing index types, composite indexes, partial/covering indexes |
| Query Optimization | references/query-optimization.md |
Reading EXPLAIN ANALYZE, fixing bottlenecks, planner tuning |
| Query Patterns | references/query-patterns.md |
CTEs, window functions, lateral joins, UPSERT, JSONB, anti-patterns |
| Performance Diagnostics | references/performance-diagnostics.md |
pg_stat views, lock analysis, VACUUM, connection management |
| Logical Replication | references/logical-replication.md |
Pub/sub replication, live migrations, CDC |
| Hot Standby | references/hot-standby.md |
Streaming replication, read replicas, failover |
| Transaction Isolation | references/transaction-isolation.md |
Isolation levels, lost updates, serialization failures, retry logic |
| Backup & Restore | references/backup-restore.md |
pg_dump/pg_restore, pg_basebackup, PITR, recovery |
| Security & Roles | references/security-roles.md |
Privileges, RLS, pg_hba.conf, authentication, SSL |
| Bulk Data Loading | references/bulk-loading.md |
COPY patterns, ETL staging, optimizing large loads, batch ops |
| Connection Pooling | references/connection-pooling.md |
PgBouncer config, pool modes, prepared statements, sizing |
| Major Version Upgrades | references/major-version-upgrades.md |
pg_upgrade, logical replication migration, pre/post checklists |
Scanned by NVIDIA SkillSpector
Automated static analysis (no LLM) · v2.12.0 · 2026-11-15
Partial analysis: some checks could not run on this component.
SkillSpector looks for patterns such as shell commands, credential access, network calls or unpinned dependencies. An observation is something worth reading in the files before you install, not a confirmed vulnerability. Components that run code locally, like hooks, MCP servers and security tooling, naturally show more of them.
- Incomplete referenced artifact analysisanalysis-evasion · SKILL.md:42
- Tool Parameter Abuse ×2Tool Misuse · references/major-version-upgrades.md:312
- Autonomous Decision MakingExcessive Agency · references/query-optimization.md:196
- Unbounded Resource Access ×2Excessive Agency · references/connection-pooling.md:69
Learn more about NVIDIA SkillSpector or how components are reviewed.