Description

A free, open-source SQL Server performance monitoring tool (Lite edition) that remotely queries DMVs without installing anything on the target server. Stores collected metrics locally in DuckDB with automatic Parquet archival. Includes an embedded MCP server exposing tools for diagnosing CPU issues, wait statistics, blocking chains, query performance, memory pressure, I/O bottlenecks, TempDB contention, SQL Agent job health, and alerting. Supports SQL Server 2016-2025, Azure SQL MI, AWS RDS, and Azure SQL Database.

Installation

git clone https://github.com/erikdarlingdata/performancemonitor/tree/HEAD/Lite

Claude Desktop Configuration

Add this configuration to your Claude Desktop config file to enable this MCP server:

Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json

Config file location: %APPDATA%\Claude\claude_desktop_config.json

Config file location: ~/.config/Claude/claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "sql-server-performance-monitor": {
      "command": "node",
      "args": [
        "path/to/server.js"
      ]
    }
  }
}