supabase-postgres-best-practices: a Claude Code skill by Supabase
Official
For developers writing SQL, schemas or row level security policies on any Postgres database. Skip it if you never touch the database layer yourself.
- Score
- 91of 100
- Rank
- #6of 239
- Installs
- 482Kon skills.sh
- Security
- Clear 5 scanners
- Updated
- 2026
- Context
- ~216tokens always
Install
npx skills add https://github.com/supabase/agent-skills --skill supabase-postgres-best-practices Run it in your terminal. View the source
Using the Claude app rather than Claude Code? You can add a skill there too. How to add it in the app
What does supabase-postgres-best-practices do?
supabase-postgres-best-practices is a Claude skill that gives Claude a rule book for Postgres work, kept by Supabase but meant for Postgres running anywhere. The rules sit in eight categories ranked by impact: query performance, connection management, and security with row level security come first, then schema design, locking, data access patterns, monitoring and advanced features. Each rule lives in its own reference file with a short reason, a wrong SQL example, a corrected one, and sometimes EXPLAIN output or Supabase notes. Claude reads the matching rule files before it writes a query, adds an index, changes a table, writes a migration or chases a slow query.
When should you use supabase-postgres-best-practices?
Use it when
- Adding a table, column or index to Postgres
- A query is slow and the EXPLAIN plan is unclear
- Writing or testing row level security policies
Skip it when
- Your database is not Postgres
- You never write SQL or migrations yourself
What it needs and what it can touch
You need
- A Postgres database, on Supabase or any other host
From reading its instructions, not from running it.
Why it scores 91
Strongest on upkeep (100 of 100), weakest on adoption (77).
Is supabase-postgres-best-practices safe to install?
Every scanner that checked it passed it. Scanners often miss what other scanners catch, and a skill can change after a scan. Read its source before you install it.
| Scanner | Result | Date |
|---|---|---|
| Gen Agent Trust Hub | Passed | Sep 15, 2026 |
| Socket | Passed | Sep 15, 2026 |
| Snyk | Low risk | Sep 15, 2026 |
| Runlayer | Low risk | Feb 26, 2026 |
| ZeroLeaks | Passed | Apr 16, 2026 |
Details
- Installs
- 482,400
- Repository stars
- 3,040
- Last repository change
- Tokens always loaded
- about 216
- Tokens when used
- about 441
- License
- MIT
- Data confidence
- High
Did it do the job for you?
Alternatives to supabase-postgres-best-practices
All skills for this job-
Get PrismaPrisma
For TypeScript developers on Prisma ORM who want correct queries, CLI commands and database setup.
-
Get neon-postgresneon-postgres
For developers whose Postgres runs on Neon and who want help with connection strings, branches and slow queries.
- Get supabase
supabase
For developers building on Supabase who want auth, RLS and migrations handled with care.
-
Get clickhouse-best-practicesclickhouse-best-practices
For teams designing or reviewing ClickHouse tables, queries and inserts against the vendor's own rules.
supabase-postgres-best-practices