postgres-best-practices

Supabase Postgres Best Practices Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design. When to Apply Reference these guidelines when: Writing SQL queries or designing schemas Implementing indexes or query optimization Reviewing database performance issues Configuring connection pooling or scaling Optimizing for Postgres-specific features Working with Row-Level Security (RLS) Rule Categories by Priority Priority Category Impact Prefix 1 Query Performance CRITICAL query- 2 Connection Management CRITICAL conn- 3 Security & RLS CRITICAL security- 4 Schema Design HIGH schema- 5 Concurrency & Locking MEDIUM-HIGH lock- 6 Data Access Patterns MEDIUM data- 7 Monitoring & Diagnostics LOW-MEDIUM monitor- 8 Advanced Features LOW advanced- How to Use Read individual rule files for detailed explanations and SQL examples: rules/query-missing-indexes.md rules/schema-partial-indexes.md rules/_sections.md Each rule file contains: Brief explanation of why it matters Incorrect SQL example with explanation Correct SQL example with explanation Optional EXPLAIN output or metrics Additional context and references Supabase-specific notes (when applicable) Full Compiled Document For the complete guide with all rules expanded: AGENTS.md When to Use This skill is applicable to execute the workflow or actions described in the overview.