supabase-postgres · diff
git:20260518.3fc52ce to git:20260610.36508ae
51 added, 4 removed. Audit A to A.
---
name: supabase-postgres
description: Postgres optimization — 70 rules (queries, indexes, RLS, concurrency). Use when writing SQL or reviewing schema.
group: brana
keywords: [postgres, sql, indexes, rls, schema, performance, query-optimization, supabase]
allowed-tools: [Read, Glob, Grep, WebFetch, AskUserQuestion]
status: experimental
source: "https://skills.sh/supabase/agent-skills/supabase-postgres-best-practices"
acquired: "2026-05-17"
promoted: "2026-05-17"
---
+ # Supabase Postgres Best Practices
- <!-- PROCEDURE_FILE: procedures/supabase-postgres.md -->
- This skill's full procedure is in a separate file for startup performance (ADR-034).
- Read and execute `system/procedures/supabase-postgres.md` from the plugin root directory.
- If the path doesn't resolve, use Glob to find `**/procedures/supabase-postgres.md`.
+ 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:
+
+ ```
+ references/query-missing-indexes.md
+ references/query-partial-indexes.md
+ references/_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)
+
+ ## References
+
+ - https://www.postgresql.org/docs/current/
+ - https://supabase.com/docs
+ - https://wiki.postgresql.org/wiki/Performance_Optimization
+ - https://supabase.com/docs/guides/database/overview
+ - https://supabase.com/docs/guides/auth/row-level-security