skills.rest
Integralist
IntegralistCOMMUNITY
Explore all skills by this author →
Website𝕏@integralistGitHub

mysql-index-audit

Audit MySQL index usage in codebases via static analysis.

2|Updated Jan 7, 2026
Search Tags:#static analysis#MySQL#query performance#database optimization#index audit
One-click install
npx skills add https://github.com/Integralist/agent-skills --skill mysql-index-audit
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mysql-index-audit
Source: https://github.com/Integralist/agent-skills/tree/main/.agents/skills/mysql-index-audit
Command: npx skills add https://github.com/Integralist/agent-skills --skill mysql-index-audit

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

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'.

Frequently Asked Questions about mysql-index-audit

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

FAQPage Schema
How do I audit MySQL index usage without a live database connection?▼

You can audit MySQL index correctness through static codebase analysis, examining index definitions and queries directly in code without needing a database connection. This identifies unused, partially used, and broken indexes to enhance query performance.

What are common MySQL index killers that degrade database performance?▼

Common MySQL index killers include unused indexes, partial index usage, and broken indexes. Static analysis can detect these issues in your codebase and provide detailed explanations and suggested fixes based on indexing best practices.

How do I interpret MySQL EXPLAIN output for query optimization?▼

Interpreting MySQL EXPLAIN output is essential for understanding query optimization. Static analysis provides guidance on reading EXPLAIN results to identify inefficient query paths and recommends improvements using indexing best practices.

Can I run static analysis to find unused MySQL indexes in my codebase?▼

Yes, you can run static analysis to find unused MySQL indexes by scanning your codebase. This process evaluates index definitions and queries without a database connection, reporting findings grouped by severity with suggested fixes.

What is the best way to identify partial index usage in MySQL queries?▼

The best way to identify partial index usage is through static codebase analysis that examines your MySQL queries and index definitions. It reports these findings grouped by severity and offers suggestions for improvement.

Related Skills

Explore More Software Engineering Skills→
1479089714790897
7

kwp-data-data-context-extractor

Extracts analyst-defined company data knowledge to generate structured SQL reference files.

Community
Advanced
ringlochidringlochid

performance-query-review

Identify slow database queries and ORM bottlenecks in backend services.

Community
Advanced
Mentor-WizardMentor-Wizard
10

postgresql-optimization

Analyze PostgreSQL queries with EXPLAIN ANALYZE and tune indexes and configuration.

Official
Advanced
HieubkavHieubkav

database-performance

Analyze database indexes and query execution plans to recommend optimizations.

Community
Advanced