supabase-postgres-best-practices

To optimize slow PostgreSQL queries in Supabase, apply targeted indexing strategies and query performance rules. This Skill provides structured guidance and concrete SQL examples to refactor queries and improve database response times.

The best way to structure Row Level Security (RLS) policies is to follow consolidated security best practices. This Skill provides categorized RLS guidance with Supabase-specific notes to implement robust data access controls.

You need table partitioning for your Postgres database when managing large datasets that degrade query performance. This Skill helps plan partitioning strategies and scalable schema designs for production Supabase deployments.

Configure connection pooling and manage concurrency in Supabase using established connection management rules. This Skill provides concrete guidance on handling locking and pooling to maintain operational stability.

Yes, this guidance works for production-level Supabase apps. It consolidates operational stability, maintenance routines, and monitoring diagnostics specifically designed to tune PostgreSQL performance in live deployments.

Standard PostgreSQL tuning lacks Supabase-specific configurations and RLS considerations. This Skill addresses those limitations by providing categorized rule guidance and platform-specific notes to avoid common performance and security pitfalls.