supabase-postgres-best-practices

Overview

A Postgres performance optimization skill maintained by Supabase, containing best practice rules across 8 categories prioritized by impact. Each rule includes detailed explanations, incorrect vs. correct SQL examples, query plan analysis, and specific performance metrics. The skill covers everything from critical query performance and connection management to advanced Postgres features, with special attention to Supabase-specific patterns like Row-Level Security (RLS).

Key Features

• Query Performance rules (Critical): Index optimization, query plan analysis, and SQL anti-patterns
• Connection Management guidance (Critical): Connection pooling and scaling strategies
• Security and RLS patterns (Critical): Row-Level Security best practices for Supabase
• Schema Design rules (High): Partial indexes, table structure, and data type selection
• Concurrency and Locking guidance (Medium-High): Lock contention and deadlock prevention
• Data Access Patterns (Medium): Efficient data retrieval and pagination strategies
• Monitoring and Diagnostics (Low-Medium): Performance monitoring queries and tools
• Each rule file includes incorrect/correct SQL examples with EXPLAIN output

Who is this for?

Developers using Supabase or Postgres who want to write optimized queries and schemas, and AI coding agents that assist with database development and performance tuning.