mysql

Name: mysql
Availability: InStock
Author: muzhicaomingwang

Identify and optimize MySQL schemas, indexes, and queries for performance and reliability.

3|2|Updated Dec 26, 2025

Search Tags:#performance #indexing #database #replication #mysql #query-tuning #dba

Ready to run

npx skills add https://github.com/muzhicaomingwang/ai-ideas --skill mysql-muzhicaomingwang

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: mysql
Source: https://github.com/muzhicaomingwang/ai-ideas/tree/main/.project/ai/DBA/skills/MySQL
Command: npx skills add https://github.com/muzhicaomingwang/ai-ideas --skill mysql-muzhicaomingwang

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps you design robust MySQL schemas, optimize indexing, and tune queries to achieve better performance and reliability in production environments.

Core Features & Use Cases

Schema design review: Assess data types, nullability, PK decisions, and normalization for hot paths.
Indexing and query tuning: Propose composite indexes, explain plans, and optimize slow queries.
Operations & replication: Plan safe online schema changes, backups, and replication configuration.

Quick Start

Run a comprehensive health check on the MySQL instance to review schema design, indexing strategy, and replication configuration, and generate an actionable optimization plan.

Frequently Asked Questions about mysql

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

FAQPage Schema

How do I optimize slow MySQL queries in production?▼

To optimize slow MySQL queries, analyze execution plans and propose composite indexes to reduce table scans. This skill diagnoses slow queries by evaluating storage engines and character sets to output an actionable index plan and performance checks.

When do I need composite indexing for MySQL schema design?▼

You need composite indexing for MySQL schema design when optimizing hot paths that filter or sort on multiple columns. This skill assesses data types, nullability, and primary key decisions to propose composite indexes that improve query performance.

What is the best way to plan safe online schema changes for MySQL?▼

The best way to plan safe online schema changes for MySQL is to evaluate replication topology and storage engine versions beforehand. This skill generates a migration plan that ensures production reliability during partitioning and schema modifications.

Can I use this to diagnose MySQL replication configuration issues?▼

Yes, you can diagnose MySQL replication configuration by running a comprehensive health check. This skill evaluates replication topology alongside schema design and indexing strategy to output actionable optimization plans for reliability.

Does MySQL partitioning work with all storage engines?▼

MySQL partitioning depends on storage engine compatibility and version constraints. This skill evaluates your MySQL version, storage engine, and character set during schema review to determine if partitioning is viable and safe for your setup.

Why does my MySQL health check require reviewing character sets?▼

Your MySQL health check requires reviewing character sets because they impact storage efficiency and query comparison behavior. This skill evaluates character sets alongside schema design and indexing strategy to output a comprehensive performance optimization plan.