postgres-best-practices
Postgres best practices for schema design, indexing, query performance, connection management, locking, and row-level security, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), migrations, constraints, indexes, RLS policies, privileges, and SQL queries. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection exhaustion, locking, bloat, or rows visible to the wrong user or tenant.
- Version
- 1.0.0
- License
- MIT
Pinned to revision 9519aeec9f3c, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/postgres-best-practices/SKILL.md
- skills/postgres-best-practices/LICENSE
- skills/postgres-best-practices/references/_sections.md
- skills/postgres-best-practices/references/advanced-full-text-search.md
- skills/postgres-best-practices/references/advanced-jsonb-indexing.md
- skills/postgres-best-practices/references/conn-idle-timeout.md
- skills/postgres-best-practices/references/conn-limits.md
- skills/postgres-best-practices/references/conn-pooling.md
- skills/postgres-best-practices/references/conn-prepared-statements.md
- skills/postgres-best-practices/references/data-batch-inserts.md
- skills/postgres-best-practices/references/data-n-plus-one.md
- skills/postgres-best-practices/references/data-pagination.md
- skills/postgres-best-practices/references/data-upsert.md
- skills/postgres-best-practices/references/lock-advisory.md
- skills/postgres-best-practices/references/lock-deadlock-prevention.md
- skills/postgres-best-practices/references/lock-short-transactions.md
- skills/postgres-best-practices/references/lock-skip-locked.md
- skills/postgres-best-practices/references/monitor-explain-analyze.md
- skills/postgres-best-practices/references/monitor-pg-stat-statements.md
- skills/postgres-best-practices/references/monitor-vacuum-analyze.md
- skills/postgres-best-practices/references/query-composite-indexes.md
- skills/postgres-best-practices/references/query-covering-indexes.md
- skills/postgres-best-practices/references/query-index-types.md
- skills/postgres-best-practices/references/query-missing-indexes.md
- skills/postgres-best-practices/references/query-partial-indexes.md
- skills/postgres-best-practices/references/schema-constraints.md
- skills/postgres-best-practices/references/schema-data-types.md
- skills/postgres-best-practices/references/schema-foreign-key-indexes.md
- skills/postgres-best-practices/references/schema-lowercase-identifiers.md
- skills/postgres-best-practices/references/schema-partitioning.md
- skills/postgres-best-practices/references/schema-primary-keys.md
- skills/postgres-best-practices/references/security-privileges.md
- skills/postgres-best-practices/references/security-rls-basics.md
- skills/postgres-best-practices/references/security-rls-performance.md
Every link opens the file at its source, pinned to the revision this page describes.