Does this skill support multiple database engines?

Yes, it provides optimization strategies and syntax recommendations tailored specifically for PostgreSQL, MySQL, and SQLite.

How does it handle index recommendations?

It analyzes filtering (WHERE), joining (JOIN), and sorting (ORDER BY) clauses to suggest the most effective single-column or composite indexes based on selectivity.

Will it provide the actual optimized SQL code?

Absolutely. The skill generates a refactored version of your query alongside a detailed explanation of the specific performance improvements made.

Can it detect N+1 issues in my application code?

Yes, the skill is designed to identify common N+1 patterns within query logs or application logic and suggests JOIN or batch-fetching solutions to fix them.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: physics91

byphysics91

データベース管理

Analyzes and optimizes SQL queries to improve database performance, resolve N+1 issues, and ensure efficient index usage.

概要

The SQL Optimizer skill is a specialized tool for developers designed to fine-tune database performance directly within Claude Code. It provides in-depth analysis of SQL queries, identifying critical issues like full table scans, inefficient joins, and N+1 query patterns that degrade application speed. By leveraging EXPLAIN plan insights and best practices, it generates actionable recommendations for composite indexes, subquery refactoring, and schema-specific optimizations for PostgreSQL, MySQL, and SQLite, transforming slow-running queries into highly efficient database operations.

主な機能

Join and subquery refactoring for performance gains
Query plan analysis using EXPLAIN command insights
0 GitHub stars
Intelligent index recommendation and composite index generation
Automated N+1 query detection and batch-fetching solutions
Detailed severity-based reporting on query efficiency

ユースケース

Auditing database migration files for missing or inefficient indexes
Detecting and refactoring N+1 query patterns in backend application code
Reviewing slow production queries to identify performance bottlenecks

概要

主な機能

Join and subquery refactoring for performance gains
Query plan analysis using EXPLAIN command insights
0 GitHub stars
Intelligent index recommendation and composite index generation
Automated N+1 query detection and batch-fetching solutions
Detailed severity-based reporting on query efficiency

ユースケース

Auditing database migration files for missing or inefficient indexes
Detecting and refactoring N+1 query patterns in backend application code
Reviewing slow production queries to identify performance bottlenecks