How do I provide parameters for my SQL analysis?

You can pass the SQL directory and a parameters file path as arguments to the skill to ensure accurate query simulation.

Does this skill modify my SQL files?

No, the SQL Quality Check skill is strictly for analysis and reporting. It does not modify any source files.

What database systems are supported?

This skill is specifically designed to analyze MySQL queries for performance issues.

Can this skill block a CI build if issues are found?

Yes, the skill is designed for CI environments and returns an Exit 1 status code when critical issues like FullTableScan or IneffectiveJoin are detected.

What criteria does the skill use to judge query quality?

It evaluates query cost and execution patterns, flagging issues like missing indexes on joins, full table scans, and the use of temporary tables for grouping.

SQL Quality Analyzer

Name: SQL Quality Analyzer
Author: koriym

bykoriym

•

データベース管理

Analyzes MySQL queries to detect performance bottlenecks like full table scans and ineffective joins without modifying source files.

The SQL Quality Analyzer skill identifies potential performance issues in SQL files by calculating query costs and detecting inefficient execution patterns. It provides a structured breakdown of critical issues such as full table scans and ineffective joins, alongside warnings for temporary table grouping and inefficient sorting. Designed for both manual audits and automated environments, this skill helps developers maintain high-performance database interactions by surfacing high-cost queries before they reach production.

主な機能

01Detects critical performance issues including FullTableScan and IneffectiveJoin.

02Categorizes findings into Critical, Warning, and Info severity levels.

03Provides detailed cost analysis for every SQL file processed.

04Supports CI-friendly reporting with automated exit status codes.

05Operates safely by reporting findings without modifying any original files.

064 GitHub stars

ユースケース

01Integrating automated SQL performance checks into CI/CD pipelines to block inefficient releases.

02Auditing legacy SQL repositories to identify and prioritize query optimization tasks.

03Reviewing new database queries during development to ensure proper index usage and join efficiency.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill