Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    MySQL Slow-Query Surgeon

    1

    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

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned

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

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

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

    Listed21 days ago

    What's inside

    Frequently Asked Questions

    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.

    This skill uses the open SKILL.md standard. Use it through an MCP-compatible agent connected to Agensi, and check the compatibility information on this page for confirmed agents and required capabilities.

    Connect your AI agent to Agensi through MCP, then ask it to use MySQL Slow-Query Surgeon on your task. Your agent loads the latest approved version each time. Paid skills require a purchase or active subscription. Skill files are not available for download; your licence does not allow you to save, copy or export any part of a skill.

    New in Data & Databases