supabase-postgres-best-practices by davila7/claude-code-templates
npx skills add https://github.com/davila7/claude-code-templates --skill supabase-postgres-best-practices由 Supabase 维护的全面 Postgres 性能优化指南。包含 8 个类别的规则,按影响优先级排序,以指导自动化查询优化和模式设计。
在以下情况下参考这些指南:
| 优先级 | 类别 | 影响 | 前缀 |
|---|---|---|---|
| 1 | 查询性能 | 关键 | query- |
| 2 | 连接管理 | 关键 | conn- |
| 3 | 安全与 RLS | 关键 |
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
security-| 4 | 模式设计 | 高 | schema- |
| 5 | 并发与锁定 | 中高 | lock- |
| 6 | 数据访问模式 | 中 | data- |
| 7 | 监控与诊断 | 低中 | monitor- |
| 8 | 高级功能 | 低 | advanced- |
阅读各个规则文件以获取详细解释和 SQL 示例:
rules/query-missing-indexes.md
rules/schema-partial-indexes.md
rules/_sections.md
每个规则文件包含:
要获取包含所有展开规则的完整指南:AGENTS.md
每周安装次数
271
代码仓库
GitHub 星标
23.4K
首次出现
2026 年 1 月 25 日
安全审计
安装于
opencode221
gemini-cli217
codex210
github-copilot202
claude-code194
cursor179
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:
rules/query-missing-indexes.md
rules/schema-partial-indexes.md
rules/_sections.md
Each rule file contains:
For the complete guide with all rules expanded: AGENTS.md
Weekly Installs
271
Repository
GitHub Stars
23.4K
First Seen
Jan 25, 2026
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
opencode221
gemini-cli217
codex210
github-copilot202
claude-code194
cursor179
Supabase Postgres 最佳实践指南 - 8大类别性能优化规则与SQL示例
57,300 周安装