supabase-postgres-best-practices

To optimize slow Postgres queries in Supabase, identify missing indexes and apply composite, partial, or covering indexes to reduce sequential scans and heap lookups. This skill guides query tuning by comparing incorrect versus correct SQL patterns for better performance.

Configuring connection pooling in Supabase requires applying connection limits, idle timeouts, and pooling patterns to prevent exhaustion. This skill provides rules for concurrency hardening and transaction management to maintain database reliability under load.

Row Level Security (RLS) affects Postgres performance by adding policy checks to queries, potentially slowing multi-tenant workloads if unoptimized. This skill helps structure RLS policies for performance while maintaining database-enforced security correctness.

To prevent deadlocks and manage locks in Supabase Postgres, apply specific transaction and lock strategies including SKIP LOCKED queue processing. This skill provides concurrency control rules to avoid deadlocks and handle concurrent database operations safely.

Yes, you can use this skill to review SQL schema migrations for Supabase by asking it to optimize your queries and schema changes using Supabase best practices. It applies during migration design and code review to guide indexing and schema decisions.