Setup & Installation
npx skills add https://github.com/supabase/agent-skills --skill postgres-best-practices
https://github.com/supabase/agent-skills/tree/main/skills/postgres-best-practices
View on GitHubWhat This Skill Does
A collection of Postgres optimization rules organized by impact, covering query performance, connection management, RLS, schema design, and concurrency. Each rule includes SQL examples showing the wrong and right approach, with EXPLAIN output and metrics where relevant. Maintained by Supabase, but applies to any Postgres setup.
Instead of piecing together Postgres tuning advice from scattered blog posts, you get prioritized rules with concrete SQL examples and measurable performance impact in one place.
When to use it
- Catching missing indexes before a slow query hits production
- Writing RLS policies that don't cause full table scans
- Configuring connection pooling for high-concurrency workloads
- Designing schemas with the right column types and partial indexes
- Reviewing query plans to understand why a join is slow