Optimizes Postgres performance and schema design using Supabase-vetted best practices and SQL patterns.
This skill provides a comprehensive framework for optimizing PostgreSQL databases, specifically tailored for developers using the Supabase ecosystem. It categorizes performance rules across eight critical areas, ranging from query execution and connection management to Row-Level Security (RLS) and schema design. By providing detailed 'correct vs. incorrect' SQL examples, query plan analysis, and specific performance metrics, the skill guides developers in building scalable, secure, and high-performing database architectures while avoiding common pitfalls in indexing and concurrency.
주요 기능
01Performance diagnostic tools including EXPLAIN output analysis and metric tracking
02Detailed SQL patterns with comparative examples of correct and incorrect implementations
03Advanced schema design guidance including partial indexing and data access patterns
04Prioritized optimization rules covering query performance and connection management
050 GitHub stars
06Comprehensive Row-Level Security (RLS) best practices for secure data access
사용 사례
01Implementing secure and efficient Row-Level Security (RLS) for multi-tenant applications
02Designing and optimizing database schemas for high-concurrency environments
03Refactoring slow-running SQL queries to improve application responsiveness
