Supabase Postgres 最佳实践指南 | 8大类别性能优化与安全规则

supabase-postgres-best-practices by davila7/claude-code-templates

271 周安装量

23,400 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/davila7/claude-code-templates --skill supabase-postgres-best-practices

云服务数据库性能优化

🇨🇳中文介绍

Supabase Postgres 最佳实践

由 Supabase 维护的全面 Postgres 性能优化指南。包含 8 个类别的规则，按影响优先级排序，以指导自动化查询优化和模式设计。

何时应用

在以下情况下参考这些指南：

编写 SQL 查询或设计模式时
实现索引或查询优化时
审查数据库性能问题时
配置连接池或扩展时
针对 Postgres 特定功能进行优化时
使用行级安全性 (RLS) 时

按优先级划分的规则类别

优先级	类别	影响	前缀
1	查询性能	关键	`query-`
2	连接管理	关键	`conn-`
3	安全与 RLS	关键

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

🇺🇸English

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:

rules/query-missing-indexes.md
rules/schema-partial-indexes.md
rules/_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)

Full Compiled Document

For the complete guide with all rules expanded: AGENTS.md

Weekly Installs

271

Repository

davila7/claude-…emplates

GitHub Stars

23.4K

First Seen

Jan 25, 2026

Security Audits

Gen Agent Trust HubPass SocketPass SnykPass

Installed on

opencode221

gemini-cli217

codex210

github-copilot202

claude-code194

cursor179