supabase-postgres-best-practices

To optimize slow PostgreSQL queries, analyze SQL with EXPLAIN ANALYZE and apply composite or covering indexes. This skill provides concrete incorrect versus correct SQL rewrites and prioritized index recommendations to eliminate inefficient query execution.

Configuring connection pooling for Postgres requires managing connection limits and using prepared-statement patterns safe for pooled environments. This skill delivers operational guidance to prevent connection exhaustion while maintaining transaction and lock management efficiency.

Writing secure RLS policies in PostgreSQL involves applying RLS-safe policy patterns that prevent data leaks while maintaining query speed. This skill provides actionable schema design and security rules to diagnose and fix insecure or slow Row Level Security configurations.

Adding migration-safe constraints and partitions to a PostgreSQL schema requires generating safe ALTER commands and applying efficient data-type recommendations. This skill produces migration-safe commands with impact estimates for schema changes across OLTP and analytics workloads.

Monitoring PostgreSQL performance with pg_stat_statements involves running prioritized monitoring queries to identify resource bottlenecks. This skill provides operational guidance to track query performance impact, analyze locks, and manage queue processing using SKIP LOCKED.