#59 by installsData & databases
supabase-postgres-best-practices
Postgres patterns for Supabase: schema design, RLS, indexing, and query performance
431K
10.5K
2.7K
Jan 21, 2026
Install
npx skills add https://github.com/supabase/agent-skills --skill supabase-postgres-best-practicesWhat it does
Postgres performance optimization rules across 8 priority categories, from query tuning to advanced features. Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres…
- 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
