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 03623634e9c9, 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.