Optimize Postgres Queries with Supabase Best Practices

This skill is a comprehensive Postgres performance-optimization guide maintained by Supabase, organized into rules across eight categories prioritized by impact: Query Performance and Connection Management (both CRITICAL), Security & RLS (CRITICAL), Schema Design (HIGH), Concurrency & Locking (MEDIUM-HIGH), Data Access Patterns (MEDIUM), Monitoring & Diagnostics (LOW-MEDIUM), and Advanced Features (LOW), each with its own rule-file prefix (query-, conn-, security-, schema-, lock-, data-, monitor-, advanced-). Individual reference files (e.g. query-missing-indexes.md, query-partial-indexes.md) hold the actual guidance, each structured the same way: a brief explanation of why the rule matters, an incorrect SQL example with explanation, a correct SQL example with explanation, optional EXPLAIN output or metrics, additional context, and Supabase-specific notes where applicable. The skill itself is the index into this rule library rather than a standalone set of instructions.

Use it when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations - implementing indexes or query optimization, reviewing database performance issues, configuring connection pooling or scaling, optimizing for Postgres-specific features, or working with Row-Level Security (RLS). Since the substantive guidance lives in the individual reference files rather than this index, treat this skill as the entry point to read the relevant rule file for the specific category in question rather than a complete standalone reference.

Inputs: the specific Postgres or Supabase task at hand (a query to optimize, a schema to design, an RLS policy to review). Outputs: a pointer to the relevant prioritized rule category and its reference file, containing an incorrect/correct SQL example pair and any relevant EXPLAIN metrics or Supabase-specific notes.

Links out to the official PostgreSQL documentation, the PostgreSQL wiki's performance optimization page, and Supabase's own docs for database overview and Row-Level Security.

Developers writing or reviewing Postgres queries, schemas, or configurations on Supabase who want prioritized, example-backed best practices rather than generic Postgres advice.