What databases does the SQL Quality Optimizer support?

This skill is specifically designed for MySQL query analysis and optimization using the Koriym.SqlQuality toolset.

How does the skill decide whether to keep a new index?

It re-analyzes the query cost after creating an index; if the cost does not improve by at least 5%, the index is automatically rolled back to prevent overhead.

Can I use this skill to analyze queries without making changes?

Yes, you can use the --no-index flag to skip index creation and only receive suggestions for SQL refactoring and DDL changes.

What kind of SQL patterns are automatically fixed?

The skill rewrites patterns like YEAR(col)=2024 into range queries, fixes ineffective LIKE patterns, and optimizes JOIN syntax to prevent full table scans.

SQL Quality Optimizer

Name: SQL Quality Optimizer
Author: koriym

bykoriym

•

데이터베이스 관리

Optimizes MySQL query performance by automatically refactoring inefficient SQL patterns and validating index impact through iterative measurement.

The SQL Quality Optimizer skill automates the detection and resolution of performance bottlenecks in MySQL databases. It performs a multi-step optimization process that includes rewriting problematic query patterns—such as index-invalidating functions and full table scans—and systematically testing new indexes. By measuring query cost reductions at every stage and automatically rolling back ineffective indexes, it ensures that all database improvements are data-driven, providing a transparent report of total cost reduction percentages.

주요 기능

01Automatic refactoring of index-invalidating functions and patterns

02Iterative index creation with automated performance impact testing

03Smart rollback of indexes that fail to improve query cost by at least 5%

04Detailed reporting of cost improvements for every optimization step

05Support for custom SQL directories and parameter files for deep analysis

064 GitHub stars

사용 사례

01Generating performance reports to identify and fix full table scans in large datasets

02Validating proposed database schema changes and index strategies before production

03Automating the optimization of legacy SQL queries with high execution costs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add koriym/koriym.sqlquality sql-quality-fix

For use in Claude.ai and ChatGPT

Download Skill