Open Skills Logo
Open Skills

supabase-postgres-best-practices

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

View Source
name:supabase-postgres-best-practicesdescription:Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.license:MITmetadata:author:supabaseversion:"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:

    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