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 loa…
These states come from the source or distribution context. None of the entries below are SkillVetAI compatibility test results.
These checks parse the fixed package against dated platform rules. They do not execute the Skill or verify task behavior.
.claude/skills/supabase-postgres-best-practicesRuntime, accounts, dependencies, permissions, network behavior and task quality remain untested.
.agents/skills/supabase-postgres-best-practicesRuntime, accounts, dependencies, permissions, network behavior and task quality remain untested.
skills/supabase-postgres-best-practicesRuntime, accounts, dependencies, permissions, network behavior and task quality remain untested.
This command is recorded from the source ecosystem and resolves the registry's latest release. The fixed release shown on this page should be inspected before adoption.
clawhub install @eohmig/supabase-postgres-best-practicesclawhub inspect @eohmig/supabase-postgres-best-practices --version 1.0.0This automated, non-executing scan is bound to this release hash. It is not a safety certification and may contain false positives or false negatives.
This is registry-supplied evidence for the recorded release, not an independent SkillVetAI scan. Check the canonical source for the full report, scanner versions, scope, and current moderation state.
The catalog stores hashes and an inventory summary for change detection. It does not republish the package contents.
sha256:da1f715d16b4ad3e1c9c42859a4642e262a9ff2cae78f00fb5c5b80cb073d7b3CHANGELOG.mdreferences/_contributing.mdreferences/_sections.mdreferences/_template.mdreferences/advanced-full-text-search.mdreferences/advanced-jsonb-indexing.mdreferences/conn-idle-timeout.mdreferences/conn-limits.mdreferences/conn-pooling.mdreferences/conn-prepared-statements.mdreferences/data-batch-inserts.mdreferences/data-n-plus-one.mdreferences/data-pagination.mdreferences/data-upsert.mdreferences/lock-advisory.mdreferences/lock-deadlock-prevention.mdreferences/lock-short-transactions.mdreferences/lock-skip-locked.mdreferences/monitor-explain-analyze.mdreferences/monitor-pg-stat-statements.mdreferences/monitor-vacuum-analyze.mdreferences/query-composite-indexes.mdreferences/query-covering-indexes.mdreferences/query-index-types.mdreferences/query-missing-indexes.mdreferences/query-partial-indexes.mdreferences/schema-constraints.mdreferences/schema-data-types.mdreferences/schema-foreign-key-indexes.mdreferences/schema-lowercase-identifiers.md- Initial release of Supabase Postgres Best Practices. - Comprehensive guide covering Postgres performance, schema design, security (RLS), indexing, migrations, and advanced features. - Includes prioritized rule categories: query performance, connection management, security, schema design, and more. - Each rule features explanations, correct/incorrect SQL examples, and practical guidance for developers. - References official Postgres and Supabase documentation for further learning.