postgres-best-practices
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
Pinned to revision 74fc33f49bdb, 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/AGENTS.md
- skills/postgres-best-practices/README.md
- skills/postgres-best-practices/metadata.json
- skills/postgres-best-practices/rules/_contributing.md
- skills/postgres-best-practices/rules/_sections.md
- skills/postgres-best-practices/rules/_template.md
- skills/postgres-best-practices/rules/advanced-full-text-search.md
- skills/postgres-best-practices/rules/advanced-jsonb-indexing.md
- skills/postgres-best-practices/rules/conn-idle-timeout.md
- skills/postgres-best-practices/rules/conn-limits.md
- skills/postgres-best-practices/rules/conn-pooling.md
- skills/postgres-best-practices/rules/conn-prepared-statements.md
- skills/postgres-best-practices/rules/data-batch-inserts.md
- skills/postgres-best-practices/rules/data-n-plus-one.md
- skills/postgres-best-practices/rules/data-pagination.md
- skills/postgres-best-practices/rules/data-upsert.md
- skills/postgres-best-practices/rules/lock-advisory.md
- skills/postgres-best-practices/rules/lock-deadlock-prevention.md
- skills/postgres-best-practices/rules/lock-short-transactions.md
- skills/postgres-best-practices/rules/lock-skip-locked.md
- skills/postgres-best-practices/rules/monitor-explain-analyze.md
- skills/postgres-best-practices/rules/monitor-pg-stat-statements.md
- skills/postgres-best-practices/rules/monitor-vacuum-analyze.md
- skills/postgres-best-practices/rules/query-composite-indexes.md
- skills/postgres-best-practices/rules/query-covering-indexes.md
- skills/postgres-best-practices/rules/query-index-types.md
- skills/postgres-best-practices/rules/query-missing-indexes.md
- skills/postgres-best-practices/rules/query-partial-indexes.md
- skills/postgres-best-practices/rules/schema-data-types.md
- skills/postgres-best-practices/rules/schema-foreign-key-indexes.md
- skills/postgres-best-practices/rules/schema-lowercase-identifiers.md
- skills/postgres-best-practices/rules/schema-partitioning.md
- skills/postgres-best-practices/rules/schema-primary-keys.md
- skills/postgres-best-practices/rules/security-privileges.md
- skills/postgres-best-practices/rules/security-rls-basics.md
- skills/postgres-best-practices/rules/security-rls-performance.md
Every link opens the file at its source, pinned to the revision this page describes.