Skills
.Work. You
Rest

mysql-index-audit

Community

Audit MySQL index correctness to enhance query performance

Software Engineering#static analysis#MySQL#query performance#database optimization#index audit
AuthorIntegralist
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Identifies and reports potential issues with MySQL indexes, such as unused indexes, partial index usage, and index killers, which can degrade database performance.

Core Features & Use Cases

  • Static Index Audit: Analyzes codebase for correct index usage without requiring a database connection.
  • EXPLAIN Analysis: Provides guidance on interpreting EXPLAIN output to understand query optimization.
  • Automated Reporting: Reports findings grouped by severity and includes detailed explanations and suggested fixes.

Quick Start

Run the skill to audit your codebase for MySQL index correctness with the command 'mysql-index-audit'.

Dependency Matrix

Required Modules

None required

Components

scripts

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: mysql-index-audit
Download link: https://github.com/Integralist/agent-skills/archive/main.zip#mysql-index-audit

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.