analyze_indexes

MCP tool from Mssql MCP by codegiveness

Missing-index analysis from sys.dmdbmissingindex DMVs (workload-wide or per-query).

How to use it

Project documentation lists analyze_indexes for the Mssql MCP 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 Mssql MCP

$npx -y @codegiveness/mssql-mcp --version

FULL MSSQL MCP LISTING

Other tools in Mssql MCP (8)

analyze_db_health

Summary health check: size, VLFs, fragmentation, stats staleness, blocking.

execute_sql

Execute a T-SQL batch. SELECT in Restricted; DML/DDL in Unrestricted.

explain_query

Show the execution plan summary (or raw XML) without executing the query.

get_object_details

Return columns, parameters, indexes, and triggers for a specific object.