supabase-postgres-best-practices

Optimize Supabase Postgres queries by applying concrete rewrite rules across eight priority categories including query performance, indexing, connection management, and schema design. The skill identifies bottlenecks and provides actionable checks to improve query execution.

Supabase RLS policy performance best practices involve auditing row-level security rules for table scan inefficiencies and applying proper indexing strategies. The skill provides specific rewrite rules and performance metrics to optimize secure data access patterns.

Use partitioning in Supabase Postgres for large datasets and multi-tenant data models to improve query speed and maintenance. The skill provides schema design guidance and concrete SQL examples for implementing safe data partitioning strategies.

Audit your Supabase database by applying included rules to identify top bottlenecks across queries, indexes, schemas, and server settings. The skill consolidates production-grade best practices to produce actionable checks and performance metrics.

Yes, this skill covers connection management and concurrency locking within its eight priority categories. It provides guidance for tuning fast-path read queries, managing locks, and ensuring reliable maintenance routines in real-world Supabase applications.