supabase-postgres-best-practices
An agent skill from Supabase with rules for writing and reviewing Postgres, both on Supabase and elsewhere.
What the skill teaches
An agent skill from Supabase with rules for writing and reviewing Postgres, both on Supabase and elsewhere. The agent loads it before schema, migration, SQL, index, RLS policy, trigger or function work and when diagnosing slow queries, locking, connection exhaustion or bloat. The rules sit in reference files grouped into eight areas ordered by impact, from query performance, connections and security down to advanced features, and each rule pairs a wrong and a corrected SQL example. It is installed with the skills CLI or as a Claude Code plugin from the supabase/agent-skills repository.
Capabilities
- Guide schema design and column type choices
- Review queries and suggest missing or partial indexes
- Advise on connection pooling and locking
- Check row-level security policies
About
- Publisher
- Supabase
- Tool
- Supabase
Install
- Run this to add it to Any client:
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices
What's inside
- CHANGELOG.md
- references/_contributing.md
- references/_sections.md
- references/_template.md
- references/advanced-full-text-search.md
- references/advanced-jsonb-indexing.md
- references/conn-idle-timeout.md
- references/conn-limits.md
- references/conn-pooling.md
- references/conn-prepared-statements.md
- references/data-batch-inserts.md
- references/data-n-plus-one.md
- references/data-pagination.md
- references/data-upsert.md
- references/lock-advisory.md
- references/lock-deadlock-prevention.md
- references/lock-short-transactions.md
- references/lock-skip-locked.md
- references/monitor-explain-analyze.md
- references/monitor-pg-stat-statements.md
- references/monitor-vacuum-analyze.md
- references/query-composite-indexes.md
- references/query-covering-indexes.md
- references/query-index-types.md
- references/query-missing-indexes.md
MCP servers and skills can run code on your computer and act on your data. Review the source before installing.
Details
| Fact | Value | Source |
|---|---|---|
| Type | Skill | |
| Tools | PostgreSQL, Supabase | |
| Publisher | Supabase | source |
| Official status | OfficialSupabase's AI skills docs link to github.com/supabase/agent-skills and list this skill | source |
| Needs an API key or sign-in | Not stated in its documentation | |
| Includes scripts | No | source |
| Platforms | Not stated in its documentation | |
| AI clients | Not stated in its documentation | |
| Licence | MIT | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Nov 10, 20263,040 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository Website |
Copies of this skill in other repositories (6)
These differ from this skill's text. They may be adapted copies or older versions.
- postgres-best-practicessickn33/agentic-awesome-skills
- supabase-postgres-best-practicesopenai/plugins
- supabase-postgres-best-practicesjulianromli/ai-skills
- supabase-postgres-best-practiceslaguagu/claude-code-nextjs-skills
- supabase-postgres-best-practicesscaleto/antigravity-super-skill-architecture
- postgres-best-practiceslihongwei-cn/lihongwei-cn
More from Supabase
1 server · 5 skills
- Supabase (MCP server)
- supabase (Skill)
- supabase-server (Skill)
- clickhouse-logs-queries (Skill)
- ask-the-docs (Skill)
Badge for your README
Maintain this project? Add a badge that links to this page.
[](https://kitbay.app/skills/supabase-supabase-postgres-best-practices/)
Sources
- Folder in the repository (supabase-postgres-best-practices)github.com/supabase/agent-skills · Backs: Licence, Includes scriptsNov 10, 2026
- Web pagesupabase.com · Backs: Official statusNov 12, 2026
- GitHub repositorygithub.com/supabase/agent-skills · Backs: Publisher, Activity, LicenceNov 11, 2026
- Skill file (SKILL.md)github.com/supabase/agent-skillsNov 10, 2026