Supabase Postgres Best Practices

1---
2name: supabase-postgres-best-practices
3description: Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
4license: MIT
5metadata:
6  author: supabase
7  version: "1.0.0"
8---
9 
10# Supabase Postgres Best Practices
11 
12Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design.
13 
14## When to Apply
15 
16Reference these guidelines when:
17- Writing SQL queries or designing schemas
18- Implementing indexes or query optimization
19- Reviewing database performance issues
20- Configuring connection pooling or scaling
21- Optimizing for Postgres-specific features
22- Working with Row-Level Security (RLS)
23 
24## Rule Categories by Priority
25 
26| Priority | Category | Impact | Prefix |
27|----------|----------|--------|--------|
28| 1 | Query Performance | CRITICAL | `query-` |
29| 2 | Connection Management | CRITICAL | `conn-` |
30| 3 | Security & RLS | CRITICAL | `security-` |
31| 4 | Schema Design | HIGH | `schema-` |
32| 5 | Concurrency & Locking | MEDIUM-HIGH | `lock-` |
33| 6 | Data Access Patterns | MEDIUM | `data-` |
34| 7 | Monitoring & Diagnostics | LOW-MEDIUM | `monitor-` |
35| 8 | Advanced Features | LOW | `advanced-` |
36 
37## How to Use
38 
39Read individual rule files for detailed explanations and SQL examples:
40 
41```
42rules/query-missing-indexes.md
43rules/schema-partial-indexes.md
44rules/_sections.md
45```
46 
47Each rule file contains:
48- Brief explanation of why it matters
49- Incorrect SQL example with explanation
50- Correct SQL example with explanation
51- Optional EXPLAIN output or metrics
52- Additional context and references
53- Supabase-specific notes (when applicable)
54 
55## Full Compiled Document
56 
57For the complete guide with all rules expanded: `AGENTS.md`
58