About
The SQL Query Optimization skill empowers Claude to identify and resolve database bottlenecks across PostgreSQL, MySQL, and SQLite. It provides systematic guidance for interpreting EXPLAIN plans, designing efficient composite and partial indexes, and refactoring problematic query patterns such as N+1 selects or implicit type conversions. By applying these production-tested patterns, developers can achieve significant performance gains, often reducing execution times from seconds to milliseconds while minimizing database CPU load and improving overall application responsiveness.
