More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Database Slow Query Rescue

    1

    Rank slow queries by total damage, not single worst time, then fix in order and check the plan before and after.

    $5

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Database Slow Query Rescue

    Database Slow Query Rescue

    Example session with this skill installed

    Two orders queries at 350 ms and one users query at 18 ms.

    • Read your context and instructions
    • Compiled the database slow query

    Verbatim script output on the shipped sample:

    share=97.5% n=2 total=700ms mean=350 max=350 :: select * from orders where status=?
    share=2.5% n=1 total=18ms mean=18 max=18 :: select id from users where id=?
    

    Reading: one normalised shape owns 97.5 percent of sampled time, so it is fixed first. The full worked example in SKILL.md walks through the same method on a larger realistic case, including the limits of the first fix.

    time, so it is fixed first. The full worked example in SKILL.md

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Database Slow Query Rescue is a step-by-step workflow for relational database slow-query diagnosis and remediation. It ranks causes by measured impact before any fix is attempted, so effort goes to the largest contributor first. It includes diagnostic trees, thresholds to state in advance, decision tables, templates, checklists, and a scoring rubric, plus a runnable script that performs the core ranking or measurement on real input. The worked example in the skill shows the method end to end on a realistic case, including what remains unresolved after the first fix.

    Results depend on the quality and coverage of the input data; missing logs, missing timings, or a biased sample will limit conclusions. Thresholds in the skill are defaults and must be adjusted to the system at hand. The script performs the core measurement only; judgement about causes, guards, and rollout remains with the user.
    Normalisation groups queries by shape only; it cannot see plan changes, lock waits, or write overhead, which the skill requires checking on a replica before shipping.

    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 any payment.

    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 23 days ago

    Permissions

    Terminal / Shell
    Listed23 days ago
    Updated21 days ago

    What's inside

    Frequently Asked Questions

    No. It diagnoses, ranks, and guides a fix, and its script measures the inputs. Applying a fix stays a deliberate change with a rollback note.

    The inputs listed in the skill: a baseline window, a sample of the failing cases, and whatever timing, log, or label data the workflow ranks. If an input is missing, the skill says to create it first rather than guess.

    It forces ranking by total measured impact, one change at a time, and re-measurement on the same sample shape, with guard metrics checked. A generic checklist rarely requires any of those.

    New in Workflow Automation