supabase-postgres-best-practices

Optimize Postgres query performance by identifying missing indexes and applying composite or partial indexes to tune execution plans. This Skill provides actionable rules and examples to refine data access patterns and sustain query speed.

Postgres schema design best practices involve selecting optimal data types, defining primary and foreign key strategies, and implementing partitioning. Regular VACUUM and ANALYZE maintenance patterns are codified to sustain long-term operational stability and performance.

Yes, it provides RLS-aware patterns specifically designed for multi-tenant setups. The Skill codifies security and Row Level Security best practices to ensure safe data access patterns across concurrent operations without compromising query performance.

Monitor and diagnose Postgres concurrency and locking issues using the operational readiness guidelines in this Skill. It includes monitoring and diagnostics rules to identify bottlenecks, analyze workloads, and generate a prioritized optimization plan.

The best way to audit an aging Postgres data model is to analyze the production workload and generate a prioritized optimization plan. This Skill references modern resources to apply a minimal, high-impact set of changes across schemas and configurations.

Use partitioning and advanced features when schema design changes alone cannot sustain performance for large datasets. This Skill outlines prioritized recommendations for applying advanced Postgres features alongside query tuning and connection management.