Which database systems are supported?

The skill provides general SQL optimization principles applicable to most relational databases including PostgreSQL, MySQL, SQL Server, and SQLite.

Does it automatically modify my database tables?

No, the skill generates recommendations and SQL snippets that you can review and test in a staging environment before applying them to your database.

How does the SQL Query Optimizer identify bottlenecks?

It analyzes the SQL query logic and can interpret EXPLAIN plan output to identify inefficient operations like full table scans or suboptimal join types.

What is the best way to get accurate optimization results?

For the best results, provide the full SQL query text and the output of the EXPLAIN command for the specific query you want to optimize.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: jeremylongshore

byjeremylongshore

•

884

•

数据库管理

Analyzes and optimizes SQL queries to improve database performance through indexing suggestions and structural rewrites.

The SQL Query Optimizer skill empowers Claude to act as a database performance engineer, identifying slow-running queries and recommending actionable improvements. By analyzing query structures, interpreting execution plans, and identifying missing or redundant indexes, this skill helps developers eliminate bottlenecks and reduce database load. Whether you are refactoring legacy code or scaling a new application, this tool provides the specific guidance needed to ensure your SQL queries run at peak efficiency.

主要功能

01Intelligent index and composite index recommendations

02Automated query rewriting for better performance

03Interpretation of EXPLAIN execution plans

04Identification of performance bottlenecks

05Comprehensive SQL query structure analysis

06884 GitHub stars

使用场景

01Optimizing slow-running queries in production environments

02Generating indexing strategies for complex data filtering

03Refactoring inefficient JOIN structures and subqueries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills sql-query-optimizer

For use in Claude.ai and ChatGPT

Download Skill