S
supabase-postgres-best-practices
bysupabase·#18 trending
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or…
2,200stars
First seenJan 21, 2026
Installation
Send this command to your AI agent:
npx skills add https://github.com/supabase/agent-skills --skill supabase-postgres-best-practicesDocumentation
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