SQL Sentinel MCP Server — Claude Code MCP server: features and setup
Connect an AI agent to SQL Server monitoring and diagnostics through Extended Events. Use it to inspect query activity, blocking, deadlocks, and wait statistics.
claude mcp add sql-sentinel-mcp-server -- docker run -i --rm ghcr.io/tkmawarire/sql-sentinel-mcpWhat SQL Sentinel MCP Server does
SQL Sentinel lets an agent manage Extended Events sessions, collect events, and filter the results. It can group queries with matching fingerprints, trace execution order, and inspect deadlock reports, blocked processes, and wait statistics. The server also supports timed event streaming and database tasks such as reading schemas, querying rows, and changing table data.
Set SQL_SENTINEL_CONNECTION_STRING for the database connection. The server requires SQL Server 2012 or later with Extended Events enabled, plus ALTER ANY EVENT SESSION and VIEW SERVER STATE permissions for session management. Blocked-process detection also depends on configuring blocked process threshold. Docker is one launch option, and requires Docker to be installed. Without a connection string, the server has no database to inspect.
What it helps with
- capture SQL query activity with Extended Events
- inspect deadlocks and identify their processes
- trace blocked processes and their wait resources
- group similar queries by fingerprint
- check SQL Server wait statistics
Example prompts for the agent
- Create an Extended Events session for the app's queries and show me the captured events.
- Find deadlocks and explain which processes were involved.
- Group similar queries and compare their execution timings.
How to install SQL Sentinel MCP Server
Platform CLI
claude mcp add sql-sentinel-mcp-server -- docker run -i --rm ghcr.io/tkmawarire/sql-sentinel-mcpPlatform CLI
codex mcp add sql-sentinel-mcp-server -- docker run -i --rm ghcr.io/tkmawarire/sql-sentinel-mcpConfig file
{
"mcpServers": {
"sql-sentinel-mcp-server": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/tkmawarire/sql-sentinel-mcp"
]
}
}
}Config file
{
"servers": {
"sql-sentinel-mcp-server": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/tkmawarire/sql-sentinel-mcp"
]
}
}
}Platform CLI
gemini mcp add sql-sentinel-mcp-server docker run -i --rm ghcr.io/tkmawarire/sql-sentinel-mcpStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about SQL Sentinel MCP Server
How do I install SQL Sentinel MCP Server in Claude Code?
With Docker, run claude mcp add sql-sentinel-mcp-server -- docker run -i --rm ghcr.io/tkmawarire/sql-sentinel-mcp. Set SQL_SENTINEL_CONNECTION_STRING for the database connection.
What does SQL Sentinel MCP Server do?
It gives an AI agent tools to monitor SQL Server with Extended Events and inspect queries, blocking, deadlocks, and wait statistics.
What is required to detect blocked processes?
Use SQL Server 2012 or later. Configure blocked process threshold with sp_configure as well.
