analyze_db_health

MCP tool from Mssql MCP by codegiveness

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

How to use it

Project documentation lists analyze_db_health 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_indexes

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

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.

get_top_queries

Top queries by CPU/duration/reads from sys.dmexecquerystats.

list_databases

List all databases with an iscurrent flag (system DBs excluded).

list_objects

List tables/views/procedures/functions with schema, type, and limit filters (default 1000).

list_schemas

List schemas in the current or specified database.