supabase-postgres-best-practices

Optimize slow Supabase Postgres queries by analyzing query patterns, evaluating execution plans, and applying targeted indexes. This skill provides concrete rules for schema design and plan analysis to improve database speed and reliability.

Design indexes by analyzing query patterns and applying multi-column indexes for slow catalog queries. This skill provides concrete rules and real-world examples to guide index selection and improve Postgres query speed.

Connection management affects performance by preventing pool exhaustion and concurrency bottlenecks. This skill provides concrete rules for managing connections, locking, and data access patterns to maintain database reliability under load.

Yes, you can use these practices to implement effective Row Level Security (RLS). The skill covers Security & RLS as one of eight categories, providing concrete rules to ensure data access patterns remain performant.

You need partitioning when optimizing schema design for large datasets and specific data access patterns. This skill includes partitioning and configuration tuning rules to guide advanced Postgres schema optimization.

Limitations when tuning Supabase Postgres configurations include potential locking and concurrency issues if applied incorrectly. Always apply top-priority optimization rules to a staging database first to verify performance gains.