Category: Development
Postgres Best Practices
Supabase's Postgres optimization rules across eight areas, from query tuning to RLS and schema design.
Works with
What it does
- Prioritizes critical rules like query performance and connection management
- Reviews indexing, connection pooling, and Row-Level Security
- Compares incorrect and correct SQL with
EXPLAINoutput - Tunes locking, concurrency, and monitoring
When to use it
Keeps your agent on Postgres-appropriate fixes when writing SQL, designing schemas, or reviewing slow queries.
How to install
- Run the command below in your terminal. Pick the agents you use (Claude Code, Codex, Cursor, Gemini CLI, Copilot, and more) and it installs into the right folder.
npx skills add https://github.com/supabase/agent-skills --skill supabase-postgres-best-practices
- To install manually, download the
supabase-postgres-best-practicesskill folder from the GitHub repository and copy it into your agent's skills folder, such as~/.claude/skills/or.cursor/skills/. - Ask your agent for a related task and the skill is used automatically.