Agent skill · Supabase
Postgres Best Practices (Supabase) skill for Claude Code, Codex and Cursor
Officialname: supabase-postgres-best-practices★ 2.9k (repo)pushed 2026-10-02MITSKILL.md on GitHubchecked 2026-11-07
What it does, in the publisher's words
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,...
The description field of the SKILL.md. The agent reads only this at startup and decides from it when to load the full skill.
Install Postgres Best Practices (Supabase)
The skills CLI copies the skill into the folder of each agent you pick (Claude Code, Codex, Cursor, Copilot, Gemini CLI, OpenCode, Windsurf...). Add -g for all projects. Needs Node.js 22.20+. docs
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices
This repo is a plugin marketplace. Inside Claude Code, add it and install the plugin that holds the skill (supabase, postgres-best-practices), or copy only this skill into ~/.claude/skills. docs
/plugin marketplace add supabase/agent-skills /plugin install <plugin>@supabase-agent-skills # or only this skill: npx skills add supabase/agent-skills --skill supabase-postgres-best-practices -a claude-code
Download the skill folder, zip it, then Customize > Skills > + > Create skill > Upload a skill. Code execution must be on (Settings > Capabilities). docs
git clone --depth 1 https://github.com/supabase/agent-skills.git /tmp/supabase-postgres-best-practices-src cp -r /tmp/supabase-postgres-best-practices-src/skills/supabase-postgres-best-practices ./supabase-postgres-best-practices zip -r supabase-postgres-best-practices.zip supabase-postgres-best-practices
Codex reads skills from .agents/skills in the repo or ~/.agents/skills. Type $ in Codex to use one. docs
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices -a codex
gh skill (GitHub CLI 2.90+, preview) installs it for Copilot in VS Code, the CLI and the cloud agent. Copilot also reads .github/skills and ~/.copilot/skills. docs
gh skill install supabase/agent-skills supabase-postgres-best-practices
Cursor reads .cursor/skills, .agents/skills and ~/.cursor/skills (and .claude/skills). It does not install loose skills from a GitHub URL, so copy it in. docs
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices -a cursor
Installs from the GitHub repo; --path picks this skill out of the repo. Default scope is user (all projects). docs
gemini skills install https://github.com/supabase/agent-skills.git --path skills/supabase-postgres-best-practices
OpenCode reads .opencode/skills, ~/.config/opencode/skills and the Claude and .agents folders. docs
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices -a opencode
Windsurf (now Devin Desktop) reads .devin/skills, .windsurf/skills and ~/.codeium/windsurf/skills. docs
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices -a windsurf
Works with
Claude Code, Claude.ai and Claude Desktop, Codex, GitHub Copilot, Cursor, Gemini CLI, OpenCode, Windsurf and other agents that read the open Agent Skills format.
What's in the SKILL.md
- When to Apply
- Rule Categories by Priority
- How to Use
- References
Bundled files
- 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
- + 15 more
Loaded only when the instructions point to them.
Facts
- Skill name
- supabase-postgres-best-practices
- Publisher
- Supabase (official)
- Repo
- supabase/agent-skills
- License
- MIT
- Version
- 1.1.1
- SKILL.md size
- 237 words, 53 lines
- Bundled files
- 35, 35 docs
- Repo stars
- 2.9k (as of 2026-10-24)
- SKILL.md checked
- 2026-11-07
Pairs with the Supabase MCP server: the server gives the agent the tools, the skill teaches it how to use them.
More skills from supabase/agent-skills
- Supabase: Covers Supabase products and client libraries: database, auth, edge functions, storage, realtime.
Related backend & databases skills
- Optimize EF Core Queries · Microsoft (.NET)
- Durable Objects · Cloudflare
- Firebase Basics · Firebase (Google)
- Cloud Firestore · Firebase (Google)
- Sanity Best Practices · Sanity
- MongoDB Schema Design · MongoDB
- Neon Postgres · Neon
- Neon Branches · Neon
FAQ
What does the supabase-postgres-best-practices skill do?+
Postgres rules for schema design, indexes, RLS and migrations, usable on any Postgres host. In its own SKILL.md, Supabase 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,..."
How do I install the supabase-postgres-best-practices skill?+
Run npx skills add supabase/agent-skills --skill supabase-postgres-best-practices and pick your agents, or use the tab for your agent above. In Claude Code the skill ends up in ~/.claude/skills/supabase-postgres-best-practices/SKILL.md; in Codex and Cursor in .agents/skills/supabase-postgres-best-practices/.
Does Postgres Best Practices (Supabase) work in Codex, Cursor and Copilot, or only Claude?+
It's a standard SKILL.md, so any agent that reads the Agent Skills format can use it: Claude Code, the Claude apps, Codex, GitHub Copilot, Cursor, Gemini CLI, OpenCode, Windsurf and more.
Who maintains Postgres Best Practices (Supabase)?+
Supabase, the company or project behind it, in the supabase/agent-skills repo on GitHub, last pushed 2026-10-02. License: MIT.
Read a skill's SKILL.md and scripts before you install it: skills aren't verified by any agent vendor. Claude skills marketplace · How to install skills · MCP servers