executionPlanXml
Actual XML execution plan (only when includeExecutionPlan was true on the start tool)
How to use it
executionPlanXml is exposed by the Mssqlclient MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the executionPlanXml tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install Mssqlclient MCP Server
docker run -d --name mssql-mcp -e "MSSQL_CONNECTIONSTRING=Server=your_server;Database=your_db;User Id=your_user;Password=your_password;TrustServerCertificate=True;" mssqlclient-mcp-server:latestOther tools in Mssqlclient MCP Server (39)
Enable executequery / executequeryindatabase tools
Enable executestoredprocedure / executestoredprocedureindatabase tools
Enable startquery / startqueryindatabase session tools
Enable startstoredprocedure / startstoredprocedureindatabase session tools
Maximum characters displayed per cell in query results. Values longer than this are truncated with .... Set to 0 to disable truncation.
(required): The name of the database to execute the query in.
Executes a SQL query on the connected SQL Server database.
Executes a SQL query in a specific database.
Executes a stored procedure with automatic parameter type conversion.
(optional): Output format - "table" (default) or "json".
Returns current timeout configuration settings.
Get results from a completed or running query/stored procedure session.
Check the status of a running query or stored procedure session.
Gets the SQL definition of a stored procedure.
Gets parameter information for a stored procedure in table or JSON Schema format.
Gets the schema of a table from the connected SQL Server database.
(optional): Include the actual XML execution plan. Default is false.
(optional): Include per-table IO statistics. Default is false.
Per-table IO statistics (only when includeIoStats was true on the start tool)
Lists all databases on the SQL Server instance.
List all query and stored procedure sessions.
Lists all stored procedures in the current database with detailed information.
Lists all tables in the connected SQL Server database with schema and row count information.
(optional): Maximum characters displayed per cell. Values longer than this are truncated with .... Set to 0 to disable truncation. If not specified, uses the server default (MaxCellOutputLength, default 40).
(optional): Maximum number of rows to return
(required): JSON string containing parameter values.
(required): The name of the stored procedure.
(required): The SQL query to execute.
Total rows affected by DML operations (always captured)
Returns detailed information about the capabilities and features of the connected SQL Server instance.
/ serverCpuTimeMs: SQL Server-side timing (always captured)
(required): The session ID to check
Updates the default command timeout for all new operations.
Start a SQL query in the background on the connected database. Returns a session ID to check progress. Best for long-running queries.
Start a stored procedure execution in the background. Returns a session ID to check progress. Best for long-running procedures.
(optional): Filter by status - "all" (default), "running", or "completed"
Stop a running query or stored procedure session.
(required): The name of the table to get schema information for.
(required): New timeout in seconds (1-3600)