SQL Sentinel MCP Server

<!-- mcp-name: io.github.tkmawarire/sql-sentinel -->

SQL Sentinel MCP Server

A production-ready MCP (Model Context Protocol) server for SQL Server monitoring, diagnostics, and database operations. Built with .NET 9 and Microsoft.Data.SqlClient for native SQL Server connectivity — no ODBC drivers required.

Features

• Session Management — Create, start, stop, drop, and list Extended Events sessions
• Smart Filtering — Filter by application, database, user, duration, host, and text patterns
• Query Fingerprinting — Normalize and group similar queries differing only in literal values
• Sequence Analysis — Trace execution order with timing gaps and cumulative duration
• Deadlock Detection — Capture and analyze XML deadlock reports with victim/process details
• Blocking Analysis — Monitor blocked process events with wait resource and SQL text
• Wait Stats — Query sys.dmoswait_stats directly, categorized by type (CPU, I/O, Lock, Memory, etc.)
• Health Check — Comprehensive server diagnostic: slow queries, deadlocks, blocking, wait stats, and insights
• Real-Time Streaming — Stream captured events for a specified duration
• Production-Safe — Auto-excludes noise (spresetconnection, SET statements, trace queries)
• Database Operations — List tables, describe schemas, query data, insert, update, and drop tables
• AI-Optimized — Structured JSON output with optional Markdown formatting

Requirements

• SQL Server 2012+ with Extended Events enabled (default)
• Required permissions:

GRANT ALTER ANY EVENT SESSION TO [your_login];
  GRANT VIEW SERVER STATE TO [your_login];

• For blocked process detection:

EXEC sp_configure 'show advanced options', 1;
  RECONFIGURE;
  EXEC sp_configure 'blocked process threshold', 5;
  RECONFIGURE;

Installation

Option 1: Docker (Recommended)

No .NET SDK required. Works on any system with Docker installed.

docker pull ghcr.io/tkmawarire/sql-sentinel-mcp:latest

Claude Desktop (claudedesktopconfig.json)

{
  "mcpServers": {
    "sql-sentinel": {
      "command": "docker",
      "args": ["run", "-i", "--rm", "--network", "host",
               "-e", "SQL_SENTINEL_CONNECTION_STRING=Server=localhost;Database=master;User Id=sa;Password=YourPassword;TrustServerCertificate=true",
               "ghcr.io/tkmawarire/sql-sentinel-mcp:latest"]
    }
  }
}

Claude Code

claude mcp add sql-sentinel \
  -e SQL_SENTINEL_CONNECTION_STRING="Server=localhost;Database=master;User Id=sa;Password=YourPassword;TrustServerCertificate=true" \
  -- docker run -i --rm --network host \
  -e SQL_SENTINEL_CONNECTION_STRING \
  ghcr.io/tkmawarire/sql-sentinel-mcp:latest

Network access: The -i flag is required for stdio transport. Use --network host so the container can reach SQL Server on your host machine. For remote SQL Server, omit --network host and use the accessible hostname in your connection string.

Connection string: Set SQLSENTINELCONNECTION_STRING via -e. All tools read the connection string from this environment variable.

Option 2: .NET Global Tool (NuGet)

Requires .NET 9 SDK or later.

dotnet tool install -g Neofenyx.SqlSentinel.Mcp

{
  "mcpServers": {
    "sql-sentinel": {
      "command": "sql-sentinel-mcp",
      "env": {
        "SQL_SENTINEL_CONNECTION_STRING": "Server=localhost;Database=master;User Id=sa;Password=YourPassword;TrustServerCertificate=true"
      }
    }
  }
}

Option 3: Build from Source

Shortened. The full README is on GitHub.