supabase-postgres-best-practices
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
适合你，如果经常写或审查 Postgres 查询，想提升数据库性能。
npx oh-my-skill add supabase/agent-skills/supabase-postgres-best-practicescurl -fsSL https://oh-my-skill.com/install.sh | bash -s -- supabase/agent-skills/supabase-postgres-best-practicesnpx oh-my-skill verify supabase/agent-skills/supabase-postgres-best-practices怎么用
商店整理自技能原文 · 版本 1ad9aae · 表述以原文为准Claude 会根据 Supabase 维护的 Postgres 性能优化指南，帮你编写、审查或优化 SQL 查询、数据库模式设计和配置，并给出带示例的改进建议。
当你编写或审查 SQL 查询、设计数据库模式、配置索引或连接池，或处理行级安全策略时触发。
技能原文 SKILL.md
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)
Rule Categories by Priority
| 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- |
How to Use
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:
- Brief explanation of why it matters
- Incorrect SQL example with explanation
- Correct SQL example with explanation
- Optional EXPLAIN output or metrics
- Additional context and references
- Supabase-specific notes (when applicable)
References
- https://www.postgresql.org/docs/current/
- https://supabase.com/docs
- https://wiki.postgresql.org/wiki/Performance_Optimization
- https://supabase.com/docs/guides/database/overview
- https://supabase.com/docs/guides/auth/row-level-security