2.7k supabase

supabase-postgres-best-practices Skill

由 Supabase 维护的 Postgres 最佳实践，适用于任何环境运行的 Postgres。在编写或修改任何存于 Postgres 数据库中的内容之前加载此技能：创建或修改表和列(包括选择列类型)、schema 设计、迁移与声明式 schema 文件、RLS 策略及其验证测试、索引、触发器、数据库函数、队列与定时任务(pg_cron、pgmq)、向量/语义搜索(pgvector),以及恢复转储(pg_restore)或导入数据。诊断慢查询、高 CPU、超时、EXPLAIN 计划、连接问题时也应加载。

安装方式:把技能目录放入 ~/.claude/skills/(Claude Code)或在 claude.ai 设置中启用;也可复制右侧安装命令一键添加。

查看源码

技能指令原文(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