From supabase-skills
Provides Supabase Postgres best practices for query performance, schema design, connection management, RLS security, and more with SQL examples and metrics.
npx claudepluginhub fcakyon/claude-codex-settings --plugin supabase-skillsThis skill uses the workspace's default tool permissions.
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.
references/_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.mdProvides Supabase Postgres best practices for optimizing queries, schema designs, connection management, security, RLS, and performance. Use when writing, reviewing, or tuning Postgres databases.
Provides Supabase Postgres best practices for query performance, connection management, schema design, security, RLS, and more. Use when writing, reviewing, or optimizing Postgres queries and configurations.
Provides Supabase Postgres best practices for optimizing queries, schemas, connections, RLS security, and configurations across 8 prioritized categories with SQL examples and metrics.
Share bugs, ideas, or general feedback.
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.
Reference these guidelines when:
| Priority | Category | Impact | Prefix |
|---|---|---|---|
| 1 | Query Performance | CRITICAL | query- |
| 2 | Connection Management | CRITICAL | conn- |
| 3 | Security & RLS | CRITICAL | security- |
| 4 | Schema Design | HIGH | schema- |
| 5 | Concurrency & Locking | MEDIUM-HIGH | lock- |
| 6 | Data Access Patterns | MEDIUM | data- |
| 7 | Monitoring & Diagnostics | LOW-MEDIUM | monitor- |
| 8 | Advanced Features | LOW | advanced- |
Read individual rule files for detailed explanations and SQL examples:
references/query-missing-indexes.md
references/schema-partial-indexes.md
references/_sections.md
Each rule file contains: