MCPVault

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

explain_query is exposed by the Mysql MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the explain_query tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

FULL MYSQL MCP SERVER LISTING

Other tools in Mysql MCP Server (26)

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:

description

No

dsn

Yes

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.

name

Yes

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.