supabase-postgres-best-practices
by @supabase/agent-skills · 1.7K stars · 54.0K installs/wk · Rank #69
Comprehensive performance, security, and schema design guidelines for optimizing PostgreSQL and Supabase databases.
Install
npx skills add https://github.com/supabase/agent-skills --skill supabase-postgres-best-practicesSummary
- 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