supabase-postgres-best-practices

by supabase (GitHub) in supabase/agent-skills

What it does

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

Quoted from the skill's SKILL.md under its MIT license.

Install

git clone --depth 1 https://github.com/supabase/agent-skills.git /tmp/agent-skills
mkdir -p ~/.claude/skills/
cp -r /tmp/agent-skills/skills/supabase-postgres-best-practices ~/.claude/skills/supabase-postgres-best-practices

The command copies the skill from the author's repo. SkillTrove does not host it.

Files

• CHANGELOG.md
• SKILL.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
• references/query-partial-indexes.md
• references/schema-constraints.md
• references/schema-data-types.md
• references/schema-foreign-key-indexes.md

Source: https://github.com/supabase/agent-skills/tree/main/skills/supabase-postgres-best-practices. Checked 2026-10-13.

Similar skills