AI Query Performance Explainer

WHAT IT DOES

The AI Query Performance Explainer takes your slow-performing query and execution plan details—and instantly returns a clear, plain-language explanation that helps you diagnose and fix performance problems. The output is organised into four clear sections: a query performance summary showing execution time and rows scanned, a bottleneck identification that pinpoints the root cause (such as missing indexes, full table scans, or join issues), 2 optimisation recommendations to improve performance, and 1 critical monitoring suggestion to prevent future issues. This removes hours of manual analysis and helps your database and development teams quickly understand and resolve performance bottlenecks.

HOW TO USE

Open the agent inside BotSurf. Paste your OpenAI API key once (it stays locally in your browser). In the input box, paste your slow-performing query and execution plan details. Press the "Explain performance" button. Within seconds, the agent returns your structured performance explanation. Copy it, share it with your database team, or use it to guide your optimisation efforts.

WHAT IT SENDS

The agent sends exactly the text you paste into the input box—nothing more, nothing less. It does not access your browser history, files, emails, or any other data. It does not send any identifying metadata beyond the content you explicitly submit. The only external transmission is that text to the AI API. Usage logs record only the count of runs for billing purposes; they do not store, log, or transmit the content of your query details or the generated explanation. Your data and the generated output remain solely on your device unless you choose to save or share them.

SUBSCRIPTION

$19.99/month with a 7-day free trial. Each subscription includes 100 runs per month (one run = one query performance explanation from your query details). Unused runs do not roll over. You can cancel anytime from your account settings—no questions asked, no long-term commitment.

THE PANEL

This agent runs inside BotSurf's draggable, resizable panel. Drag it anywhere on your screen. Snap it to the left or right edge for a clean workspace. Collapse it to a minimal title bar when not in use. Press Escape to close the panel instantly. It stays persistent across tabs so you can troubleshoot performance issues and generate explanations without losing context.

PLEASE NOTE

AI-generated explanations are probabilistic, not factual guarantees. The agent may mis-identify the bottleneck, suggest inappropriate optimisations, or miss critical context about your database schema and workload. Always review any explanation against your actual execution plan, database environment, and system context, and consult your database team before making changes. This tool is general database guidance only—not professional legal or compliance advice. In regulated sectors, treat this as a starting point only—not as a verified performance analysis. The final responsibility for accuracy, diagnosis, and optimisation lies with you and your database team.