mysql

Audit MySQL schemas, indexes, queries, and replication settings for performance bottlenecks.

Updated Aug 23, 2026

Search Tags:#performance #indexing #mysql #query-optimization #database-design #innodb

Ready to run

npx skills add https://github.com/tomrford/dotfiles --skill mysql-tomrford

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: mysql
Source: https://github.com/tomrford/dotfiles/tree/main/.agents/skills/mysql
Command: npx skills add https://github.com/tomrford/dotfiles --skill mysql-tomrford

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Plan and review MySQL/InnoDB schema, indexing, query tuning, transactions, and operations. Use when creating or modifying MySQL tables, indexes, or queries; diagnosing slow/locking behavior; planning migrations; or troubleshooting replication and connection issues. Load when using a MySQL database.

Core Features & Use Cases

Workflow-oriented guidance for designing, indexing, and tuning MySQL schemas.
Step-by-step approach to evaluating performance, applying minimal changes, and validating results.
Real-world use cases including migrations, replication troubleshooting, and production-safe rollouts.

Quick Start

Audit a MySQL instance for schema design, indexing, and query performance and implement a safe optimization plan.

Frequently Asked Questions about mysql

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

FAQPage Schema

How do I identify performance bottlenecks in a MySQL database?▼

Identify MySQL performance bottlenecks by auditing schemas, indexes, queries, and replication settings. This process detects design issues and slow or locking behavior to provide structured optimization recommendations across development, staging, and production environments.

What is the best way to plan a safe-rollback schema migration in MySQL?▼

Plan safe-rollback MySQL schema migrations by evaluating performance and applying minimal changes with validation. This approach provides step-by-step guidance for creating tables, modifying indexes, and ensuring production-safe rollouts during transitions.

How do I optimize MySQL indexing strategy and query tuning?▼

Optimize MySQL indexing and queries by following workflow-oriented guidance for schema design and tuning. This evaluates performance systematically to apply minimal changes and validate results for improved InnoDB transactional behavior.

Can I use this to troubleshoot MySQL replication and connection issues?▼

Yes, you can troubleshoot MySQL replication and connection issues across development and production environments. It diagnoses slow or locking behavior and provides structured recommendations supported by best-practice references.

Why does my MySQL database experience slow locking behavior during transactions?▼

MySQL slow locking behavior during transactions often stems from schema design and indexing issues. Auditing InnoDB transactional behavior, indexing strategy, and query tuning identifies these bottlenecks and provides structured optimization recommendations.