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:
code
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