supabase-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) ## Quick Decision Tree ``` Problem? ├─ Slow query → query-missing-indexes, query-composite-indexes, monitor-explain-analyze ├─ Connection errors / timeouts → conn-pooling, conn-limits, conn-idle-timeout ├─ Deadlocks / long transactions → lock-short-transactions, lock-deadlock-prevention ├─ Bulk load slow → data-batch-inserts, data-upsert ├─ Table bloat / VACUUM issues → monitor-vacuum-analyze ├─ JSONB queries slow → advanced-jsonb-indexing ├─ FTS / search quality → advanced-full-text-search (pair with /postgres-semantic-search for BM25 + vector) └─ Security / multi-tenant → security-* rules, RLS ``` ## Related Skills - `/postgres-semantic-search` — Vector search (pgvector), hybrid BM25 + semantic, ParadeDB - `/nextjs-chatbot` — Chatbot orchestration, session DB, feedback, HITL - `/ai-sdk` — AI SDK patterns for backend integration ## Rule Categories by Priority | Priority | Category | Impact | Prefix | |----------|----------|--------|-----...