From craft-workspace-webconsulting-skills
Optimizes Postgres queries, schema designs, and database configurations using Supabase best practices across 8 priority categories including query performance, connection management, and security/RLS.
How this skill is triggered — by the user, by Claude, or both
Slash command
/craft-workspace-webconsulting-skills:postgres-best-practicesThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
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.
CHANGELOG.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.mdComprehensive 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/query-partial-indexes.md
references/_sections.md
Each rule file contains:
This skill is based on the excellent work by Supabase.
Original repository: https://github.com/supabase/agent-skills
Special thanks to Supabase for their generous open-source contributions, which helped shape this skill collection. Adapted by webconsulting.at for this skill collection
npx claudepluginhub dirnbauer/webconsulting-skillsProvides Postgres best practices from Supabase for optimizing queries, schema designs, indexes, connection pooling, RLS, and configurations.
Optimizes Postgres queries, schema designs, and database configurations using Supabase best practices across 8 priority-ranked categories.
Optimizes Postgres queries and schema design using Supabase best practices across 8 priority categories including indexes, connection management, and RLS.