- name
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 co
SKILL.md
The skill file stays in the publisher's repository.
Paste the copied command in a terminal. It installs this SKILL.md into that agent.
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices -a cursor -yPaste the copied command in a terminal. It installs this SKILL.md into that agent.
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices -a claude-code -yPaste the copied command in a terminal. It installs this SKILL.md into that agent.
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices -a codex -yPaste the copied command in a terminal. It installs this SKILL.md into that agent.
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices -a grok -ySend the copied message in a Grok Bot chat. The Bot fetches this SKILL.md from GitHub and adds it to the skills all your Bots share.
Install this skill: https://github.com/supabase/agent-skills/tree/HEAD/skills/supabase-postgres-best-practicesFrom the publisher
Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design.
Reference these guidelines when:
Read individual rule files for detailed explanations and SQL examples:
references/query-missing-indexes.md
references/query-partial-indexes.md
references/_sections.md
Each rule file contains:
© 2026 Skills Rack.
---name: supabase-postgres-best-practicesdescription: Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing…---# skills/supabase-postgres-best-practices/SKILL.mdOverview
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.
FAQ
Download skills/supabase-postgres-best-practices/SKILL.md from the publisher, or copy the path and open the repository. PlugMCP lists the skill and does not host the file.
The publisher keeps it at https://github.com/supabase/agent-skills.
Claude, Cursor, Codex, and Grok Build can read a SKILL.md you add from the publisher's repository. Grok Bot installs it when you send the skill's GitHub folder link in a chat.