SqlServer.AdministrativeViews.McpServer.linux-arm64 1.1.306

There is a newer version of this package available.
See the version list below for details. 
dotnet add package SqlServer.AdministrativeViews.McpServer.linux-arm64 --version 1.1.306
                    


                    

                
NuGet\Install-Package SqlServer.AdministrativeViews.McpServer.linux-arm64 -Version 1.1.306
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="SqlServer.AdministrativeViews.McpServer.linux-arm64" Version="1.1.306" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="SqlServer.AdministrativeViews.McpServer.linux-arm64" Version="1.1.306" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="SqlServer.AdministrativeViews.McpServer.linux-arm64" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add SqlServer.AdministrativeViews.McpServer.linux-arm64 --version 1.1.306
                    


                    

                
#r "nuget: SqlServer.AdministrativeViews.McpServer.linux-arm64, 1.1.306"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#:package SqlServer.AdministrativeViews.McpServer.linux-arm64@1.1.306
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=SqlServer.AdministrativeViews.McpServer.linux-arm64&version=1.1.306
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=SqlServer.AdministrativeViews.McpServer.linux-arm64&version=1.1.306
                    


                            Install as a Cake Tool

SQL Server Queries with metrics and execition plans MCP Server

Prompt

List top 12 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

Sort option Description
Count Number of executions
Avg Duration Average elapsed time per execution (μs)
Total Duration Total elapsed time across all executions (μs) (default)
Avg CPU Time Average CPU time / WorkerTime per execution (μs)
Total CPU Time Total CPU time / WorkerTime across executions (μs)
Avg Reads Average logical reads per execution
Total Reads Total reads across all executions
Avg Writes Average writes per execution
Total Writes Total writes across all executions
Avg Rows Average rows returned/affected per execution
Total Rows Total rows across all executions
Avg Memory Average memory used per execution (KB)

AI-Free CLI

This tool is also available for CI on ethemerial 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:

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:

```json
{
  "servers": {
    "Local SQL Servers": {
      "type": "stdio",
      "command": "dnx",
      "args": [
        "SqlServer.AdministrativeViews.McpServer",
        "--yes"
      ]
    }
  }
}
There are no supported framework assets in this package.

Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.1.322 46 4/27/2026
1.1.321 42 4/27/2026
1.1.320 102 4/8/2026
1.1.319 101 4/8/2026
1.1.318 104 4/6/2026
1.1.317 103 4/6/2026
1.1.316 101 4/6/2026
1.1.313 107 4/5/2026
1.1.312 110 4/4/2026
1.1.311 108 4/4/2026
1.1.310 113 4/3/2026
1.1.309 101 4/3/2026
1.1.308 107 4/3/2026
1.1.307 103 4/3/2026
1.1.306 106 4/3/2026
1.1.305 101 4/3/2026
1.1.304 106 4/3/2026
1.1.303 99 4/3/2026