sql-quality-fix

Fixes SQL performance issues with automated analysis and validation.

3|2|Updated Dec 19, 2024
One-click install
npx skills add https://github.com/koriym/Koriym.SqlQuality --skill sql-quality-fix
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sql-quality-fix
Source: https://github.com/koriym/Koriym.SqlQuality/tree/main/skills/sql-quality-fix
Command: npx skills add https://github.com/koriym/Koriym.SqlQuality --skill sql-quality-fix

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automatically fixes SQL performance issues by applying step-by-step measurements and safe, validated changes.

Core Features & Use Cases

  • Rewrites problematic SQL patterns such as functions on columns and implicit conversions.
  • Creates and tests indexes, measures impact, and rolls back ineffective changes.
  • Reports improvements at each step with cost-reduction percentages to guide decision-making.

Quick Start

Run the sql-quality fix workflow against your sql directory to analyze, apply fixes, and generate a report.

Frequently Asked Questions about sql-quality-fix

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automatically fix SQL performance issues and validate the impact?

You can fix SQL performance issues automatically by applying measured, incremental optimizations that rewrite problematic patterns, test indexes, and validate impact before keeping the changes.

How does automated SQL indexing and query rewriting work?

Automated SQL indexing works by analyzing queries, creating candidate indexes, measuring their performance impact, and rolling back ineffective changes to ensure only beneficial optimizations are applied.

Do I need a PHP environment to run automated SQL analysis and index testing?

Yes, you need a PHP-based environment and access to the project's SQL Quality tool to perform end-to-end analysis, index experimentation, and cost-based evaluation.

What is the best way to optimize SQL queries that use functions on indexed columns?

The best way to optimize these SQL queries is through automated rewriting of problematic patterns like functions on columns and implicit conversions, followed by measured impact validation.

Can I generate a report showing SQL performance improvements and cost reductions?

Yes, the process generates a concise report detailing improvements at each step with cost-reduction percentages to guide your optimization decision-making.