MCPVault

analyze_db_health

MCP tool from Mssql MCP by codegiveness

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

How to use it

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

Install Mssql MCP

$npx -y @codegiveness/mssql-mcp --version
FULL MSSQL MCP LISTING

Other tools in Mssql MCP (17)

analyze_indexes

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

database

string

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.

format

enum

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.

limit

int

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.

name

string

order_by

enum

query

string

schema

string

sql

string

type

enum