supabase-postgres-best-practices

To optimize slow Postgres queries in Supabase, you should run EXPLAIN ANALYZE to diagnose bottlenecks and apply indexing, query-shape rewrites, and connection pooling rules. This skill provides concrete incorrect versus correct SQL patterns to refactor queries for maximum performance impact.

Supabase RLS best practices involve building tenant-safe policies that avoid expensive per-row function calls and ensuring proper indexing. This skill provides correct SQL patterns to harden multi-tenant RLS policies without degrading query performance.

Fix Postgres connection pooling issues by configuring idle timeouts, managing prepared statements correctly with poolers, and applying operational safety rules. This skill outlines connection-management practices to stabilize production workloads and prevent pool exhaustion.

Use composite, partial, or covering indexes in Postgres when query shapes involve multiple columns, conditional filters, or require index-only scans. This skill helps identify missing indexes and provides precise SQL rewrites to select the correct index type for your workload.

Write migration-safe DDL for production Postgres by following schema best practices that minimize lock contention and prevent downtime. This skill provides operational guidance on vacuum, analyze, and locking practices to ensure smooth schema changes in Supabase-backed systems.