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,…
- installs 8w
- 103,288
- 30-day movement
- starts with the next reading
- Related entries
- 9
- Connections
- 0
A SKILL.md agent skill packaging Supabase's Postgres best practices, organized into 8 rule categories prioritized by impact with links to individual rule files and SQL examples. It covers schema design, migrations, indexes, RLS policies, triggers, functions, pg_cron/pgmq, pgvector, dump restores, and performance diagnosis.
Load it before writing or changing anything in a Postgres database so schema, security, and performance rules are applied consistently, even for small changes.
Use it to
- Design or alter tables and pick column types
- Write migrations and declarative schema files
- Author RLS policies and verify them with tests
- Tune indexes and diagnose slow queries or EXPLAIN plans
- Troubleshoot locking, connection exhaustion, or tenant data leaks
For Developers and AI coding agents working with Postgres databases
- Host repository
- supabase/agent-skills
- Version
- 1.1.1
- Installs, lifetime
- 405k
- Installs, 8 weeks
- 103k
- Licence
- MIT
- Host stars
- 2,625
- Host language
- TypeScript