supabase-postgres-best-practices

To optimize slow Postgres queries in Supabase, apply best-practice rules across categories like query performance and connection management, using example SQL snippets and on-demand reference files for tuning guidance.

Write efficient RLS policies in Supabase by following structured best-practice security rules that provide clear explanations and example SQL snippets to ensure row-level security maintains query reliability and speed.

Identify missing indexes for slow Supabase Postgres queries by reviewing SQL against optimization rules and loading specific documentation from the references directory to apply the correct indexing strategy.

Yes, you can apply these Postgres best practices to partition tables in Supabase, as the skill provides systematic performance guidance covering partitioning alongside SQL tuning and RLS policy configuration.

You should carefully evaluate adding an index to a Postgres table by checking the categorized optimization rules and reference files, ensuring the tuning strategy matches your specific workload constraints.