get_top_queries

MCP tool from Mssql MCP by codegiveness

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

How to use it

Project documentation lists get_top_queries 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.

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.

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.