supabase-postgres-best-practices

To optimize slow Postgres queries in Supabase, you can apply best-practice rules for query speed and indexing. This skill provides anti-pattern-first guidance, showing incorrect vs. correct SQL rewrites to fix performance bottlenecks.

Designing safe RLS policies in Postgres requires applying Supabase best practices for Row Level Security. This skill guides you through RLS policy design by highlighting incorrect patterns and providing correct SQL rewrites to ensure data safety.

Analyzing a Postgres query plan with EXPLAIN involves running EXPLAIN ANALYZE to inspect execution paths. This skill helps you interpret query plans and use pg_stat_statements to identify and resolve performance issues.

Fixing Postgres connection pool limits in Supabase requires applying best practices for connection management. This skill provides operational guidance on connection pooling and limits to improve database reliability under load.

You need to run VACUUM and ANALYZE for Postgres maintenance when managing database bloat and statistics. This skill covers operational maintenance tasks, guiding you on when to execute these commands to maintain query performance.

Yes, this skill helps with Postgres schema design and concurrency locking patterns. It applies Supabase best-practice rules to your schema decisions and provides guidance on managing locking and concurrency for reliable performance.