Home / Skills / supabase-postgres-best-practices

supabase-postgres-best-practices

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

ScannedSkillSource: GitHub

2,887 stars +78 this week Updated 1mo ago License MIT Context ≈158 tokens always loaded

76popular

Why this score

Stars

22/35

Usage (forks)

9/15

Upkeep

20/25

License

15/15

Owner history

10/10

This repo hosts 2 skills, so its 2,887 stars are split between them (about 1,444 each) for scoring.

Popularity score: 76/100 from public GitHub signals only. It shows how widely used and maintained this is, not how well it works. Not included yet: the fake-star check. The security scan is shown separately and doesn't change the score. How we rank

Security

Scanned Oct 21, 2026 at commit c9be0e931b79, with Cisco's open-source skill-scanner.

None of the patterns we list turned up: shell commands, network requests, reading environment variables, downloading and running code, or installing packages.

A scan lists patterns in the code. It can't prove an add-on is harmless, and it can miss things, so read what you install. How we scan

Prompts that use Supabase

"Explain It Like I Built It" Technical Documentation for Non-Technical Founders▲ 4 votes · Coding

Alternatives

Other makers' add-ons that do the same job, next to this one.

Name	Score	Stars	Context	Updated
This onesupabase-postgres-best-practices supabase/agent-skills · Skill	76	★ 2.9k	≈158 always	1mo ago
atlas-postgres ariga/atlas · Skill Same job: databases, also for Supabase	78	★ 8.8k	≈128 always	24d ago
postgres planetscale/database-skills · Skill Same job: databases, also for Postgres	71	★ 725	≈39 always	28d ago
Supabase supabase/mcp · MCP server Same job: databases, also for Supabase	93	★ 3.0k	not measured	today
distributed postgres awslabs/mcp · Skill Same job: databases, also for Postgres	82	★ 9.8k	≈59 always	16d ago
design-postgres-tables timescale/pg-aiguide · Skill Same job: databases, also for Postgres	71	★ 1.9k	≈19 always	21d ago

Install

mkdir -p .claude/skills/supabase-postgres-best-practices

curl -sL https://codeload.github.com/supabase/agent-skills/tar.gz/c9be0e931b7930f7d02126d04774d904c381e7d7 | tar -xz -C .claude/skills/supabase-postgres-best-practices --strip-components=3 "agent-skills-c9be0e931b7930f7d02126d04774d904c381e7d7/skills/supabase-postgres-best-practices"

To remove it later:

rm -rf .claude/skills/supabase-postgres-best-practices

npx skills add supabase/agent-skills --skill supabase-postgres-best-practices

Pinned to commit c9be0e931b79 as listed by GitHub.

Context cost: ≈158 tokens loaded every session (name and description), plus ≈807 tokens when the skill is used.

The Claude Code command downloads this skill folder at the pinned commit into .claude/skills/. The Skills CLI (npx skills) works with many agents but can't pin a version, so it installs whatever is current.

Used for

Engineering › Testing & QA Engineering › Databases

Tool pages

Supabase Postgres

Facts

Repo: supabase/agent-skills
Stars: 2,887
Forks: 271
Last push: 2026-10-02 (1mo ago)
License: MIT
Owner: supabase · since 2019
Language: TypeScript
Works with: Claude Code, Skills CLI