Supabase Query Optimizer

소개

This skill empowers Claude to diagnose and resolve performance bottlenecks within Supabase databases. It automates the analysis of slow-running PostgreSQL queries using EXPLAIN ANALYZE, identifies missing indexes, and provides specific recommendations for Row-Level Security (RLS) optimizations and query restructuring. By generating production-ready migration scripts and measuring performance gains, it ensures that your Supabase applications remain scalable and responsive even under heavy data loads.

주요 기능

• Intelligent index recommendation and concurrent creation
• 0 GitHub stars
• Automated EXPLAIN ANALYZE execution plan analysis
• Query restructuring for complex joins and aggregations
• Row-Level Security (RLS) performance tuning and optimization
• Automated migration script generation with verification steps

사용 사례

• Resolving slow-loading dashboards or timeout errors in Supabase applications
• Scaling database schemas to handle high-traffic production environments
• Auditing and optimizing complex RLS policies to reduce query latency