PostgreSQL Optimization Patterns
Optimizes PostgreSQL performance and schema design using production-ready patterns and Supabase best practices.
This skill provides a comprehensive toolkit for PostgreSQL database management, focusing on high-performance schema design and query optimization. It equips Claude with specialized knowledge for selecting the right index types, implementing advanced SQL patterns like UPSERT and cursor-based pagination, and hardening security through optimized Row-Level Security (RLS) policies. By integrating industry-standard best practices from the Supabase ecosystem, it helps developers avoid common anti-patterns such as unindexed foreign keys and table bloat while providing ready-to-use configuration templates for connection pooling and monitoring.