What databases does this skill support?

This skill is designed to work with all major SQL databases, with specific patterns and syntax for PostgreSQL, MySQL, and SQLite.

Does it explain complex EXPLAIN plans?

Absolutely. It translates technical EXPLAIN ANALYZE output into human-readable insights, identifying sequence scans, high-cost nodes, and filtering inefficiencies.

Can it help with N+1 query problems?

Yes, it provides specific strategies for detecting N+1 query patterns in application code and refactoring them into efficient JOINs or batched IN-queries.

How much of a speedup can I expect?

While results vary, applying these patterns typically results in 10x to 1000x improvements by converting full table scans into efficient index-only or index-cond scans.

Will it suggest specific indexes to create?

Yes, the skill provides guidance on single-column, composite (multi-column), partial, and covering indexes based on your specific WHERE, JOIN, and ORDER BY clauses.

SQL Query Optimization

Name: SQL Query Optimization
Author: applied-artificial-intelligence

byapplied-artificial-intelligence

•

Gestión de Bases de Datos

Optimizes database performance through advanced query rewriting, index design strategies, and EXPLAIN plan analysis.

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.

Características Principales

01Automated detection and refactoring of N+1 query patterns

02Query rewriting for JOIN optimization and subquery efficiency

03EXPLAIN and ANALYZE plan interpretation for PostgreSQL, MySQL, and SQLite

04Keyset pagination patterns to replace slow OFFSET-based paging

05Strategic index design including composite, partial, and covering indexes

0618 GitHub stars

Casos de Uso

01Designing optimal indexing strategies for new schemas or existing tables

02Debugging slow database queries and high CPU utilization in production

03Refactoring application code to eliminate performance-draining N+1 queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add applied-artificial-intelligence/claude-code-toolkit general-dev

For use in Claude.ai and ChatGPT

Download Skill