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 bbc23d18a5d4, 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.