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.

主要功能

Intelligent index and composite index recommendations
Automated query rewriting for better performance
Interpretation of EXPLAIN execution plans
Identification of performance bottlenecks
Comprehensive SQL query structure analysis
884 GitHub stars

使用场景

Optimizing slow-running queries in production environments
Generating indexing strategies for complex data filtering
Refactoring 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

GitHub

关于