- Home
- Skills
- Data & Databases
- MySQL Slow-Query Surgeon
Works with the AI Agents you already use
MySQL Slow-Query Surgeon
Diagnoses slow MySQL/MariaDB queries from EXPLAIN plans, schemas and row counts and returns prioritized index, rewrite and tuning prescriptions with verification and rollback steps.
$19
MySQL Slow-Query Surgeon
Example session with this skill installed
This query takes 8 seconds on a 5M-row table. Here's the query, its EXPLAIN output and SHOW CREATE TABLE — tell me exactly what index or rewrite fixes it, and how to verify the fix.
- Read your context and instructions
- Compiled the mysql slow-query surgeon
You get a prioritized prescription: the exact index DDL or query rewrite, why it works, the expected effect, and the EXPLAIN check that proves the fix.
Connects securely to your tools. The creator never sees your data.
About this skill
An agent skill that diagnoses slow MySQL/MariaDB queries from evidence — EXPLAIN plans, schemas and row counts — and returns a prioritized prescription report: composite index designs, query rewrites (including keyset pagination and collation-mismatch join fixes) and server tuning such as InnoDB buffer pool sizing, each with verification and rollback steps. Built from production experience optimizing multi-million-row tables.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 21 days ago
Permissions
No special permissions declared or detected