explain_query

MCP tool from Mysql MCP Server by askdba

Get execution plan for a SELECT query. Responses include optional warnings (e.g. full table scan, filesort) when the plan suggests optimizations.

How to use it

Project documentation lists explain_query for the Mysql MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

Install Mysql MCP Server

$mysql-mcp-server
FULL MYSQL MCP SERVER LISTING

Other tools in Mysql MCP Server (23)

add_connection

MCP only. Available when the server runs in MCP mode (stdio) with MYSQLMCPEXTENDED=1 and MYSQLMCPENABLEADDCONNECTION=1. It registers a new named MySQL connection at runtime and switches the process-wide active connection for that MCP process. There is no HTTP route to register a new DSN. REST API mo

database_size

Get database size information.

describe_table

Input:

foreign_keys

List foreign key constraints.

list_connections

List all configured MySQL connections.

list_databases

Returns non-system databases.

list_functions

List stored functions.

list_indexes

List indexes on a table.

list_partitions

List table partitions.

list_procedures

List stored procedures.

list_status

List MySQL server status variables.

list_tables

Input:

list_triggers

List triggers in a database.

list_variables

List MySQL server configuration variables.

list_views

List views in a database.

ping

Tests database connectivity and returns latency.

run_query

Input:

server_info

Returns MySQL server details.

show_create_table

Get the CREATE TABLE statement.

table_size

Get table size information.

use_connection

Switch to a different MySQL connection.

vector_info

List vector columns in a database.

vector_search

Perform similarity search on vector columns.