supabase-postgres-best-practices
Data, Backend & APIPostgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
Documentation
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:
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.mdEach rule file contains:
Full Compiled Document
For the complete guide with all rules expanded: AGENTS.md
Compétences similaires
Explorez d'autres agents de la catégorie Data, Backend & API
database-migrations-sql-migrations
SQL database migrations with zero-downtime strategies for
ai-engineer
Build production-ready LLM applications, advanced RAG systems, and
clarity-gate
"Pre-ingestion verification for epistemic quality in RAG systems with 9-point verification and Two-Round HITL workflow"