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.
packages/autoskills/skills-registry/supabase-postgres-best-practices/SKILL.md
Source commit 077b6ea6d747b3f392314bc47e7bb5285f1159b1
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 5, 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)
- 6,989
- Repository last updated
- Nov 4, 2026
- License
- NOASSERTION
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- data Derived category
- design Derived category
- writing Derived category
- security Derived category
- data-databases Derived category
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
No licensed excerpt is available. You can inspect the pinned source.