About
The SQL Optimization Patterns skill empowers Claude to act as a database performance engineer, providing expert guidance on transforming slow queries into high-performance operations. It offers systematic approaches to interpreting EXPLAIN execution plans, implementing sophisticated indexing strategies—such as composite, partial, and covering indexes—and refactoring inefficient query logic to eliminate common anti-patterns like N+1 queries and expensive offsets. This skill is essential for developers looking to reduce database load, minimize infrastructure costs, and ensure application scalability across PostgreSQL, MySQL, and other relational databases.