mysql_explain

What mysql_explain does on Mysql Mcp

AI agents call mysql_explain to retrieve information from Mysql Mcp without modifying anything. It is typically the context-gathering step in research, monitoring, and reporting workflows, before the agent takes action elsewhere.

Why mysql_explain is rated Low

EXPLAIN is a diagnostic tool that retrieves metadata about how MySQL will execute a query. It does not execute the query, modify data, delete records, or trigger external side effects. It is purely informational and safe to classify as Read. Severity is low because misuse of EXPLAIN (e.g., on complex queries) would at worst consume CPU for planning but cannot corrupt data or cause financial harm.

From the tool's definition Tool name 'mysql_explain' and description 'Get query execution plan using EXPLAIN' indicate a read-only operation. EXPLAIN is a MySQL statement that analyzes and displays query execution plans without modifying data or executing the query itself.

The rule that runs mysql_explain safely

PolicyLayer is an MCP gateway: it sits between your AI agents and Mysql Mcp, and checks every tool call against a rule you set before the call runs. Nothing changes on the server itself. For mysql_explain, this is the rule to start with:

{
  "version": "1",
  "default": "deny",
  "tools": {
    "mysql_explain": {}
  }
}

Questions about mysql_explain