supabase-postgres-best-practices by claudiodearaujo/izacenter
npx skills add https://github.com/claudiodearaujo/izacenter --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
每周安装数
1
代码库
GitHub 星标数
1
首次出现
1 天前
安全审计
安装于
zencoder1
amp1
cline1
openclaw1
opencode1
cursor1
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
1
Repository
GitHub Stars
1
First Seen
1 day ago
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
zencoder1
amp1
cline1
openclaw1
opencode1
cursor1
Azure 升级评估与自动化工具 - 轻松迁移 Functions 计划、托管层级和 SKU
79,900 周安装