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

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

When to Use

This skill is applicable to execute the workflow or actions described in the overview.