supabase-postgres-best-practices

PostgreSQL query optimization in Supabase involves applying rules across eight categories including query performance, connection management, and schema design. Use this skill during code reviews, migrations, and deployments to enforce tuning practices like index optimization and lock contention reduction.

Tuning indexes and improving schema design requires applying specific performance rules with SQL examples and metrics. This skill provides a catalog of rules for data access patterns and schema design to guide automated optimization and ensure scalable Supabase deployments.

Yes, it covers Row Level Security and connection management. The skill includes a catalog of performance rules across security, RLS, and concurrency to ensure scalable and secure data access patterns for Supabase-based applications.

Monitoring Postgres performance and reducing lock contention involves applying rules from the monitoring, diagnostics, and concurrency categories. This skill provides explanations and SQL examples to identify bottlenecks and enforce best practices across your database configuration.

Yes, you can use this skill for automated tooling and database migrations. It provides a catalog of rules with metrics and references designed to guide automated optimization, enforce best practices, and validate schema changes during project deployments.

You should not use these rules if your application does not use Supabase or PostgreSQL. The skill is specifically scoped to Supabase-backed applications and requires applying rules across categories like query performance, concurrency, and advanced features tailored to that environment.