tkmawarire avatar

SQL Sentinel MCP Server

tkmawarire/sql-sentinel

This server wraps SQL Server Extended Events in MCP tools so Claude can monitor production databases without ODBC. You get session lifecycle control, query fingerprinting, deadlock and blocking analysis, wait stats from sys.dm_os_wait_stats, and real-time event streaming. It also handles basic database operations like listing tables, describing schemas, and running SELECT/INSERT/UPDATE queries. Built on Microsoft.Data.SqlClient with native TDS protocol. Ships as a Docker container or .NET global tool. Useful when you need to diagnose slow queries, trace execution sequences, or let an agent interact with SQL Server metadata and performance counters directly from chat.

GitHub stars
3
tools
24
transport
STDIO
last updated
Feb 25, 2026

Tools

24 tools

Public tool metadata for what this MCP can expose to an agent.

sqlsentinel_create_sessionCreate an Extended Events session with filters (not started)

Create an Extended Events session with filters (not started)

No parameter schema in public metadata yet.

sqlsentinel_start_sessionStart capturing events for an existing session

Start capturing events for an existing session

No parameter schema in public metadata yet.

sqlsentinel_stop_sessionStop capturing; events are retained

Stop capturing; events are retained

No parameter schema in public metadata yet.

sqlsentinel_drop_sessionDrop session and discard all events

Drop session and discard all events

No parameter schema in public metadata yet.

sqlsentinel_list_sessionsList all MCP-created sessions with state and buffer usage

List all MCP-created sessions with state and buffer usage

No parameter schema in public metadata yet.

sqlsentinel_quick_captureCreate and start a session in one step

Create and start a session in one step

No parameter schema in public metadata yet.

sqlsentinel_get_eventsRetrieve captured events with filtering, sorting, and deduplication

Retrieve captured events with filtering, sorting, and deduplication

No parameter schema in public metadata yet.

sqlsentinel_get_statsAggregate statistics grouped by fingerprint, database, app, or login

Aggregate statistics grouped by fingerprint, database, app, or login

No parameter schema in public metadata yet.

sqlsentinel_analyze_sequenceAnalyze query execution sequence with timing and gaps

Analyze query execution sequence with timing and gaps

No parameter schema in public metadata yet.

sqlsentinel_get_connection_infoList databases, applications, logins, sessions, and blocking info

List databases, applications, logins, sessions, and blocking info

No parameter schema in public metadata yet.

sqlsentinel_stream_eventsReal-time event capture for a specified duration (1–300s)

Real-time event capture for a specified duration (1–300s)

No parameter schema in public metadata yet.

sqlsentinel_get_deadlocksRetrieve deadlock events with victim, processes, locks, and SQL text

Retrieve deadlock events with victim, processes, locks, and SQL text

No parameter schema in public metadata yet.

sqlsentinel_get_blockingRetrieve blocked process events with wait resources and SQL text

Retrieve blocked process events with wait resources and SQL text

No parameter schema in public metadata yet.

sqlsentinel_get_wait_statsQuery sys.dm_os_wait_stats categorized by type (no session required)

Query sys.dm_os_wait_stats categorized by type (no session required)

No parameter schema in public metadata yet.

sqlsentinel_health_checkComprehensive report: slow queries, deadlocks, blocking, wait stats, insights

Comprehensive report: slow queries, deadlocks, blocking, wait stats, insights

No parameter schema in public metadata yet.

sqlsentinel_check_permissionsCheck current login permissions and blocked process threshold config

Check current login permissions and blocked process threshold config

No parameter schema in public metadata yet.

sqlsentinel_grant_permissionsGrant required permissions to a login (requires sysadmin)

Grant required permissions to a login (requires sysadmin)

No parameter schema in public metadata yet.

sqlsentinel_list_tablesList all user tables in the database (schema-qualified)

List all user tables in the database (schema-qualified)

No parameter schema in public metadata yet.

sqlsentinel_describe_tableDetailed table schema: columns, indexes, constraints, foreign keys

Detailed table schema: columns, indexes, constraints, foreign keys

No parameter schema in public metadata yet.

sqlsentinel_create_tableCreate a new table via CREATE TABLE statement

Create a new table via CREATE TABLE statement

No parameter schema in public metadata yet.

sqlsentinel_insert_dataInsert data via INSERT statement

Insert data via INSERT statement

No parameter schema in public metadata yet.

sqlsentinel_read_dataExecute SELECT queries and return results

Execute SELECT queries and return results

No parameter schema in public metadata yet.

sqlsentinel_update_dataUpdate data via UPDATE statement

Update data via UPDATE statement

No parameter schema in public metadata yet.

sqlsentinel_drop_tableDrop a table via DROP TABLE statement

Drop a table via DROP TABLE statement

No parameter schema in public metadata yet.

Sponsors

Readme

SQL Sentinel MCP Server

NuGet Docker License: MIT

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


View the full README on GitHub

Details

Repository
github.com/tkmawarire/sql-sentinel
Website
github.com/tkmawarire/sql-sentinel
Category
Databases
Package
Neofenyx.SqlSentinel.Mcp
Transport
STDIO
Registry
MCP registry, active

Related Databases MCP servers

View all
1ofershap avatarSqliteofershap/mcp-server-sqliteSQLite MCP — query databases, inspect schemas, explain queries, export data.2stars
2pinion05 avatarPinion05 Supabase Mcp Litepinion05/supabase-mcp-liteSame functionality, consuming only 1/20 of the context window tokens.1stars
3daedalus avatarMcp Redis Serverdaedalus/mcp-redis-serverMCP server that exposes Redis API to AI models0stars
4aguantar avatarClickhouse Dataops Mcpaguantar/clickhouse-mcp-serverDataOps ClickHouse MCP server with query optimization and pipeline monitoring0stars
5rosch100 avatarMcp Sqliterosch100/mcp-sqliteMCP server for SQLCipher 4 encrypted SQLite databases with full CRUD operations and query support0stars
6elastic avatarElasticsearchelastic/mcp-server-elasticsearchProvides MCP access to Elasticsearch data, enabling index discovery, mappings, searches, and shard information.662stars