AgentSkillsCN

supabase-postgres-best-practices

掌握来自 Supabase 的 PostgreSQL 性能优化与最佳实践。在编写、审查或优化 PostgreSQL 查询、数据库架构设计或数据库配置时，可灵活运用这一技能。

SKILL.md
--- frontmatter
name: supabase-postgres-best-practices
description: Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
license: MIT
metadata:
  author: supabase
  version: "1.0.0"

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

PriorityCategoryImpactPrefix
1Query PerformanceCRITICALquery-
2Connection ManagementCRITICALconn-
3Security & RLSCRITICALsecurity-
4Schema DesignHIGHschema-
5Concurrency & LockingMEDIUM-HIGHlock-
6Data Access PatternsMEDIUMdata-
7Monitoring & DiagnosticsLOW-MEDIUMmonitor-
8Advanced FeaturesLOWadvanced-

How to Use

Read individual rule files for detailed explanations and SQL examples:

code
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