supabase-postgres-best-practices agent skill by supabase
Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pg_cron, pgmq), vector/semantic search (pgvector), and restoring dumps (pg_restore) or importing data. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection exhaustion, locking, bloat, or rows visible to the wrong user or tenant. This is not just a performance guide — schema, migration, security, and SQL authoring tasks need these rules too, even for a one-column change or a single query.
Source and license
| Publisher | supabase |
|---|---|
| Repository | supabase/agent-skills |
| License | MIT |
| Snapshot | 2026-10-22 |
| Last repository commit | 2026-10-02 |
| Instruction size | 242 words; 52 lines |
| Bundled files | 36 |
Suede Skill Check: 67/100 · D
Report snapshot · · graded-v2
The rubric totals 100 points; published scores are capped at 99. Security scan: not scanned.
Source revision: c9be0e931b79. Report version 6ee93075ce16. Badge URLs follow the latest listing; save the report to keep this version.
Download report · Request a fresh review
What to review next
- Structural checks: 48 of 56 points. 8 points for each of the seven graded checks.
- Instruction depth: 1 of 7 points. 7 for a SKILL.md body of 500–3,000 words; 4 for 250–4,500; 1 for 100 or more.
- Boundary clause: 0 of 4 points. 4 when the description says when not to use the skill (“Not for …”, “Do not use …”, “Use … instead”).
Add declarations and bundled files when they describe the skill’s actual needs. Update the source, then request a fresh review with the changed commit or PR.
| Component | Points earned | Available |
|---|---|---|
| Structural checks | 48 | 56 |
| Description length | 3 | 5 |
| Boundary clause | 0 | 4 |
| Example request | 0 | 3 |
| Instruction depth | 1 | 7 |
| Reference files | 3 | 3 |
| Bundled scripts | 0 | 2 |
| Recent maintenance | 9 | 9 |
| Curated-list citations | 3 | 7 |
| Tool permissions declared | 0 | 2 |
| Compatibility declared | 0 | 2 |
The published score is capped at 99. It measures the published files, documentation and maintenance signals. Security scan: not scanned. This assessment does not include a runtime test or a full installation-dependency review.
Install supabase-postgres-best-practices
The skills CLI works with Claude Code, Codex, Cursor and other agents; the other routes copy the folder by hand.
npx skills add https://github.com/supabase/agent-skills/tree/main/skills/supabase-postgres-best-practicestmp="$(mktemp -d)"
git clone --depth 1 https://github.com/supabase/agent-skills.git "$tmp/repo"
mkdir -p .claude/skills
cp -R "$tmp/repo/"skills/supabase-postgres-best-practices .claude/skills/
rm -rf "$tmp"tmp="$(mktemp -d)"
git clone --depth 1 https://github.com/supabase/agent-skills.git "$tmp/repo"
mkdir -p .agents/skills
cp -R "$tmp/repo/"skills/supabase-postgres-best-practices .agents/skills/
rm -rf "$tmp"For a user-level install, copy the folder to ~/.claude/skills/ (Claude Code) or ~/.agents/skills/ (Codex). Inside Codex, $skill-installer can also fetch a skill from GitHub. New to skills? Read How to install agent skills in Claude Code, Codex and Cursor.
supabase/agent-skills is third-party code. Read SKILL.md and any bundled scripts before you install it.
Show the listing and raise the score
supabase-postgres-best-practices is listed with 67/100 · D. This badge links to its Suede AI listing. Skills scoring 80–99 add a numeric and a letter quality shield; the largest open points for supabase-postgres-best-practices are structural checks (8), instruction depth (6) and boundary clause (4). Send your repository and the points you want to raise, then request a fresh review after updating the skill. Publishers: read How to get your agent skill found in search and cited by AI assistants.
[](https://suedeai.directory/supabase/agent-skills/supabase-postgres-best-practices/)<a href="https://suedeai.directory/supabase/agent-skills/supabase-postgres-best-practices/"><img src="https://suedeai.directory/badge.svg" alt="Suede AI Skills Directory: listed" height="20"></a>Compare skills for this task
Browse data-databases skills or compare scores side by side.