SqlServer.AdministrativeViews.McpServer.linux-arm64 1.1.320

SQL Server Queries with metrics and execition plan MCP Server

Prompts

Top 3 slowest queries with metrics and execution plan on local sql server '(local)' for database 'Adventureworks2014'

List online sql servers and localdb servers

List top 5 heaviest queries on SQL Server '(local)' of any database (or 'database AdventureWorks') ordered by average | cumulative IO reads. Explain execution plan, find potential problems with performance and scalability, suggest resolutions, and highlight recommendations by engine.

Supported sorting

AI-Free CLI

This tool is also available for CI build agents as CLI tool:

https://www.nuget.org/packages/SqlServer.AdministrativeViews

Build info

The MCP server is built as a self-contained application and does not require the .NET runtime to be installed on targets:

• win-x64
• win-arm64
• osx-arm64
• osx-x64
• linux-x64
• linux-arm64
• linux-musl-x64

Developing locally

To test this MCP server from source code (locally) without using a built MCP server package, you can configure your IDE to run the project directly using dotnet run.

{
  "servers": {
    "SqlServer.AdministrativeViews.McpServer": {
      "type": "stdio",
      "command": "dotnet",
      "args": [
        "run",
        "--project",
        "<PATH TO PROJECT DIRECTORY>"
      ]
    }
  }
}

Refer to the VS Code or Visual Studio documentation for more information on configuring and using MCP servers:

• Use MCP servers in VS Code (Preview)
• Use MCP servers in Visual Studio (Preview)

Using the MCP Server from NuGet.org

Once the MCP server package is published to NuGet.org, you can configure it in your preferred IDE. Both VS Code and Visual Studio use the dnx command to download and install the MCP server package from NuGet.org.

• VS Code: Create a <WORKSPACE DIRECTORY>/.vscode/mcp.json file
• Visual Studio: Create a <SOLUTION DIRECTORY>\.mcp.json file
• Claude: Add local mcp server

Example

:: Windows
claude mcp add --transport stdio local-sql-servers -- cmd /c dnx SqlServer.AdministrativeViews.McpServer --yes
# Linux and MAC
claude mcp add --transport stdio --env SQLSERVER_WELLKNOWN_1="<Connection String>" local-sql-servers -- dnx SqlServer.AdministrativeViews.McpServer --yes

For both VS Code and Visual Studio, the configuration file uses the following server definition:

{
  "servers": {
    "Local SQL Servers": {
      "type": "stdio",
      "command": "dnx",
      "args": [
        "SqlServer.AdministrativeViews.McpServer",
        "--yes"
      ]
    }
  }
}

Non-local SQL Server with alias

{
  "mcpServers": {
    "SQL Servers": {
      "command": "cmd",
      "args": [
        "/c",
        "dnx",
        "SqlServer.AdministrativeViews.McpServer",
        "--yes",
        "--",
        "--alias",
        "Everest",
        "--connection-string",
        "Data Source=<network or cloud sql server>; User ID=...; Password=...; TrustServerCertificate=true; Encrypt=False; Pooling=True"
      ]
    }
  }
}

Parameters --alias (-a) and --connection-string (-cs) can be specified multiple times.