mysql

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.

Try your first task

Review one slow MySQL query

Start a fresh conversation.

Use the mysql skill to review the slow query, table definitions, indexes, and EXPLAIN output I provide. Identify the main performance concern and propose the smallest query or index change, explaining trade-offs and how to validate it. Consider my MySQL version, hosting platform, workload, data volume, and latency target.

Required inputs

One slow SQL query, relevant table definitions, existing indexes, and EXPLAIN output.
MySQL version, hosting platform, read/write mix, approximate data volume, and latency target.

Suggested template by Skill Leaderboard, grounded in the linked source. Task evidence ↗

Inside SKILL.md

83 lines

Section content has not been verified for this skill yet.

Full source remains withheld under the current source-display policy. Read the author’s source ↗