Individual skill
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 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.
skills/supabase-postgres-best-practices/SKILL.md
Source commit c9be0e931b7930f7d02126d04774d904c381e7d7
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- No
- Repository scan complete
- No
- Skill scan complete
- Yes
- Observed behavior
- Not checked yet
- Last checked
- Nov 2, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 3,034
- Repository last updated
- Nov 7, 2026
- License
- MIT
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
CHANGELOG.mddoc · 5,684 bytesSKILL.mdcore · 3,231 bytesreferences/_contributing.mddoc · 4,113 bytesreferences/_sections.mddoc · 1,682 bytesreferences/_template.mddoc · 1,040 bytesreferences/advanced-full-text-search.mddoc · 1,468 bytesreferences/advanced-jsonb-indexing.mddoc · 1,444 bytesreferences/conn-idle-timeout.mddoc · 1,282 bytesreferences/conn-limits.mddoc · 1,325 bytesreferences/conn-pooling.mddoc · 1,382 bytesreferences/conn-prepared-statements.mddoc · 1,529 bytesreferences/data-batch-inserts.mddoc · 1,287 bytesreferences/data-n-plus-one.mddoc · 1,361 bytesreferences/data-pagination.mddoc · 1,358 bytesreferences/data-upsert.mddoc · 1,390 bytesreferences/lock-advisory.mddoc · 1,531 bytesreferences/lock-deadlock-prevention.mddoc · 1,855 bytesreferences/lock-short-transactions.mddoc · 1,350 bytesreferences/lock-skip-locked.mddoc · 1,353 bytesreferences/monitor-explain-analyze.mddoc · 1,441 bytesreferences/monitor-pg-stat-statements.mddoc · 1,418 bytesreferences/monitor-vacuum-analyze.mddoc · 1,506 bytesreferences/query-composite-indexes.mddoc · 1,454 bytesreferences/query-covering-indexes.mddoc · 1,287 bytesreferences/query-index-types.mddoc · 1,521 bytesreferences/query-missing-indexes.mddoc · 1,218 bytesreferences/query-partial-indexes.mddoc · 1,347 bytesreferences/schema-constraints.mddoc · 1,880 bytesreferences/schema-data-types.mddoc · 1,453 bytesreferences/schema-foreign-key-indexes.mddoc · 1,679 bytesreferences/schema-lowercase-identifiers.mddoc · 1,728 bytesreferences/schema-partitioning.mddoc · 1,548 bytesreferences/schema-primary-keys.mddoc · 1,821 bytesreferences/security-privileges.mddoc · 1,566 bytesreferences/security-rls-basics.mddoc · 1,372 bytesreferences/security-rls-performance.mddoc · 2,103 bytes
Read excerpt
# Supabase Postgres Best Practices
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.
## When to Apply
Reference these guidelines when:
- Writing SQL queries or designing schemas
- Implementing indexes or query optimization
- Reviewing database performance issues
- Configuring connection pooling or scaling
- Optimizing for Postgres-specific features
- Working with Row-Level Security (RLS)