supabase-postgres-best-practices by supabase/agent-skills
npx skills add https://github.com/supabase/agent-skills --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 示例:
references/query-missing-indexes.md
references/schema-partial-indexes.md
references/_sections.md
每个规则文件包含:
每周安装量
50.4K
代码仓库
GitHub 星标数
1.7K
首次出现
2026 年 1 月 21 日
安全审计
安装于
opencode40.4K
codex40.1K
gemini-cli39.7K
github-copilot37.5K
cursor35.6K
amp33.2K
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:
Weekly Installs
50.4K
Repository
GitHub Stars
1.7K
First Seen
Jan 21, 2026
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
opencode40.4K
codex40.1K
gemini-cli39.7K
github-copilot37.5K
cursor35.6K
amp33.2K
React 组合模式指南:Vercel 组件架构最佳实践,提升代码可维护性
102,200 周安装