supabase-postgres-best-practices
Postgres performance optimization rules across 8 priority categories, from query tuning to advanced features.
- Organized into 8 rule categories prioritized by impact: query performance and connection management (critical), security and RLS, schema design, concurrency, data access patterns, monitoring, and advanced features
- Each rule includes detailed explanations, incorrect vs. correct SQL examples, EXPLAIN output analysis, and performance metrics to guide optimization decisions
- Covers query indexing, connection pooling, Row-Level Security configuration, schema design patterns, locking behavior, and Postgres-specific tuning
- Designed for use during SQL writing, schema design, performance reviews, and database scaling decisions
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
More in Databases
supabase
Supabase client: auth, storage, realtime, edge functions, and migrations
supabase/agent-skillsfirebase-basics
Firebase setup, Firestore queries, security rules, and project configuration
firebase/agent-skillsfirebase-auth-basics
Firebase Authentication flows, providers, custom claims, and session management
firebase/agent-skillsfirebase-firestore-enterprise-native-mode
Firestore at scale: sharding, composite indexes, and enterprise data modeling
firebase/agent-skillsmongodb-query-optimizer
MongoDB query and index tuning: explain plan analysis, compound indexes via the ESR rule, and Performance Advisor recommendations
mongodb/agent-skills