supabase-postgres-best-practices
skills/supabase-postgres-best-practices · supabase/agent-skills · 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 · GitHub API and the SKILL.md frontmatter, read 2026-11-15 · stars are for the whole supabase/agent-skills repository
Install supabase-postgres-best-practices
Ready-to-paste · from the repository README and the skill folder
# Copy this skill folder into your personal Claude Code skills git clone --depth 1 --filter=blob:none --sparse --branch main https://github.com/supabase/agent-skills.git /tmp/supabase-postgres-best-practices-src git -C /tmp/supabase-postgres-best-practices-src sparse-checkout set skills/supabase-postgres-best-practices mkdir -p ~/.claude/skills cp -R /tmp/supabase-postgres-best-practices-src/skills/supabase-postgres-best-practices ~/.claude/skills/supabase-postgres-best-practices
Skill repositories from other publishers in the open Agent Skills format (agentskills.io) · a folder with a SKILL.md plus optional scripts and resources, read by any client that supports the format.
Alternatives
Same category · other repositories · latest commit first
More from Supabase
Same repository · supabase/agent-skills · latest commit first
Embeddable badge
Drop into your README · links to this skill page
[](https://benchgecko.ai/skills/supabase-postgres-best-practices)
FAQ
Built from the GitHub data above
What is supabase-postgres-best-practices?
supabase-postgres-best-practices is a Agent Skills agent skill by Supabase, in the skills/supabase-postgres-best-practices folder of the supabase/agent-skills repository (BenchGecko category: Data · SQL). Its SKILL.md describes it as: 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.
Where does this data come from?
From GitHub, read 2026-11-15: the name and description from the SKILL.md frontmatter, 36 files from the repository tree, the last commit to the folder on 2026-07-30, and 3,081 stars for the whole supabase/agent-skills repository. BenchGecko does not rate skills.
How do I install supabase-postgres-best-practices?
Copy the skills/supabase-postgres-best-practices folder into ~/.claude/skills/ for Claude Code, use the command from the supabase/agent-skills README, or point any client that supports the Agent Skills format at the folder. Ready-to-paste snippets are above.
Is supabase-postgres-best-practices official?
supabase-postgres-best-practices is published in supabase/agent-skills, a repository owned by the Supabase organization on GitHub.
See also
Keep exploring the BenchGecko graph