How do I use io.github.tkmawarire/sql-sentinel?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@io.github.tkmawarire/sql-sentinel Run a full health check and report any deadlocks or blocking" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

de en es ja ko ru zh

io.github.tkmawarire/sql-sentinel

by tkmawarire

Overview Schema Related Servers Score Discussions

Remote

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

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.dm_os_wait_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 (sp_reset_connection, 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

Related MCP server: mysql-mcp-server

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 (`claude_desktop_config.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 SQL_SENTINEL_CONNECTION_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

git clone https://github.com/tkmawarire/sql-sentinel.git
cd sql-sentinel
dotnet build

Run directly:

dotnet run --project SqlServer.Profiler.Mcp/

Or publish a self-contained single binary:

# Windows
dotnet publish SqlServer.Profiler.Mcp/ -c Release -r win-x64 --self-contained

# Linux
dotnet publish SqlServer.Profiler.Mcp/ -c Release -r linux-x64 --self-contained

# macOS (Apple Silicon)
dotnet publish SqlServer.Profiler.Mcp/ -c Release -r osx-arm64 --self-contained

# macOS (Intel)
dotnet publish SqlServer.Profiler.Mcp/ -c Release -r osx-x64 --self-contained

Output will be in bin/Release/net9.0/{runtime}/publish/

Connection Strings

All tools read the connection string from the SQL_SENTINEL_CONNECTION_STRING environment variable. Set it once before starting the server:

export SQL_SENTINEL_CONNECTION_STRING="Server=localhost;Database=master;User Id=sa;Password=YourPassword;TrustServerCertificate=false;Encrypt=true"

SQL Authentication:

Server=localhost;Database=master;User Id=sa;Password=YourPassword;TrustServerCertificate=false;Encrypt=true

Windows Authentication:

Server=localhost;Database=master;Integrated Security=true;TrustServerCertificate=false;Encrypt=true

Note: Only use TrustServerCertificate=true in development environments with self-signed certificates. For production, always use TrustServerCertificate=false with a valid SSL certificate.

Azure SQL:

Server=yourserver.database.windows.net;Database=yourdb;User Id=user;Password=password;Encrypt=true

MCP Tools Reference

Session Lifecycle

Tool	Description
`sqlsentinel_create_session`	Create an Extended Events session with filters (not started)
`sqlsentinel_start_session`	Start capturing events for an existing session
`sqlsentinel_stop_session`	Stop capturing; events are retained
`sqlsentinel_drop_session`	Drop session and discard all events
`sqlsentinel_list_sessions`	List all MCP-created sessions with state and buffer usage
`sqlsentinel_quick_capture`	Create and start a session in one step

Event Retrieval

Tool	Description
`sqlsentinel_get_events`	Retrieve captured events with filtering, sorting, and deduplication
`sqlsentinel_get_stats`	Aggregate statistics grouped by fingerprint, database, app, or login
`sqlsentinel_analyze_sequence`	Analyze query execution sequence with timing and gaps
`sqlsentinel_get_connection_info`	List databases, applications, logins, sessions, and blocking info
`sqlsentinel_stream_events`	Real-time event capture for a specified duration (1–300s)

Diagnostics

Tool	Description
`sqlsentinel_get_deadlocks`	Retrieve deadlock events with victim, processes, locks, and SQL text
`sqlsentinel_get_blocking`	Retrieve blocked process events with wait resources and SQL text
`sqlsentinel_get_wait_stats`	Query `sys.dm_os_wait_stats` categorized by type (no session required)
`sqlsentinel_health_check`	Comprehensive report: slow queries, deadlocks, blocking, wait stats, insights

Permissions

Tool	Description
`sqlsentinel_check_permissions`	Check current login permissions and blocked process threshold config
`sqlsentinel_grant_permissions`	Grant required permissions to a login (requires sysadmin)

Database Operations

Tool	Description
`sqlsentinel_list_tables`	List all user tables in the database (schema-qualified)
`sqlsentinel_describe_table`	Detailed table schema: columns, indexes, constraints, foreign keys
`sqlsentinel_create_table`	Create a new table via CREATE TABLE statement
`sqlsentinel_insert_data`	Insert data via INSERT statement
`sqlsentinel_read_data`	Execute SELECT queries and return results
`sqlsentinel_update_data`	Update data via UPDATE statement
`sqlsentinel_drop_table`	Drop a table via DROP TABLE statement

Usage Examples

Quick Debug Session

Agent: sqlsentinel_quick_capture(
    sessionName: "debug_api",
    applications: "MyWebApp",
    minDurationMs: 100
)

// User triggers the slow operation

Agent: sqlsentinel_get_events(
    sessionName: "debug_api",
    sortBy: "DurationDesc",
    limit: 20
)

Agent: sqlsentinel_drop_session(sessionName: "debug_api")

Find N+1 Queries

Agent: sqlsentinel_quick_capture(
    sessionName: "n_plus_one_check",
    databases: "OrdersDB"
)

// User loads a page

Agent: sqlsentinel_get_stats(
    sessionName: "n_plus_one_check",
    groupBy: "QueryFingerprint"
)

// Look for queries with high execution counts

Trace Specific Operation

Agent: sqlsentinel_analyze_sequence(
    sessionName: "my_session",
    correlationId: "order-12345",
    responseFormat: "Markdown"
)

Deadlock Detection

Agent: sqlsentinel_quick_capture(
    sessionName: "deadlock_monitor",
    eventTypes: "Deadlock"
)

// Wait for deadlocks to occur

Agent: sqlsentinel_get_deadlocks(
    sessionName: "deadlock_monitor",
    responseFormat: "Markdown"
)

Blocking Analysis

Agent: sqlsentinel_quick_capture(
    sessionName: "blocking_check",
    eventTypes: "BlockedProcess"
)

// Requires: sp_configure 'blocked process threshold', 5

Agent: sqlsentinel_get_blocking(
    sessionName: "blocking_check",
    responseFormat: "Markdown"
)

Server Health Check

Agent: sqlsentinel_health_check(
    sessionName: "my_session",
    slowQueryThresholdMs: 1000,
    responseFormat: "Markdown"
)

Database Operations

Agent: sqlsentinel_list_tables()

Agent: sqlsentinel_describe_table(
    name: "dbo.Products"
)

Agent: sqlsentinel_read_data(
    sql: "SELECT TOP 10 * FROM dbo.Products ORDER BY CreatedDate DESC"
)

Wait Stats (No Session Required)

Agent: sqlsentinel_get_wait_stats(
    topN: 20,
    responseFormat: "Markdown"
)

Query Fingerprinting

Queries are normalized to group similar ones:

-- These become one fingerprint:
SELECT * FROM Users WHERE id = 123
SELECT * FROM Users WHERE id = 456

-- Fingerprint: abc123:SELECT * FROM Users WHERE id = ?
-- Execution count: 2

Noise Filtering

Default excluded patterns (when excludeNoise=true):

sp_reset_connection — Connection pool reset
SET TRANSACTION ISOLATION LEVEL — Session setup
SET NOCOUNT, SET ANSI_* — Client configuration
sp_trace_*, fn_trace_* — Trace system queries

Supported Event Types

SqlBatchCompleted, RpcCompleted, SqlStatementCompleted, SpStatementCompleted, Attention, ErrorReported, Deadlock, BlockedProcess, LoginEvent, SchemaChange, Recompile, AutoStats

Project Structure

sql-profiler-mcp/
├── .github/
│   └── workflows/
│       ├── docker.yml                     # Build & push multi-arch Docker images
│       └── publish-mcp-registry.yml       # Publish NuGet + MCP registry
├── .mcp/
│   └── server.json                        # MCP manifest (NuGet + OCI packages)
├── SqlServer.Profiler.Mcp/                # Main MCP server (stdio transport)
│   ├── SqlServer.Profiler.Mcp.csproj
│   ├── Program.cs                         # Entry point, DI setup, MCP config
│   ├── Models/
│   │   ├── ProfilerModels.cs              # Records, enums, data models
│   │   └── DbOperationResult.cs           # Result model for CRUD operations
│   ├── Services/
│   │   ├── ProfilerService.cs             # Core Extended Events logic
│   │   ├── QueryFingerprintService.cs     # SQL normalization & fingerprinting
│   │   ├── WaitStatsService.cs            # DMV-based wait stats analysis
│   │   ├── SessionConfigStore.cs          # In-memory session config storage
│   │   └── EventStreamingService.cs       # Real-time event streaming
│   ├── Utilities/
│   │   └── SqlInputValidator.cs           # SQL input validation & escaping
│   └── Tools/
│       ├── SessionManagementTools.cs      # Session lifecycle tools (6)
│       ├── EventRetrievalTools.cs         # Event retrieval tools (5)
│       ├── DiagnosticTools.cs             # Diagnostic tools (4)
│       ├── PermissionTools.cs             # Permission tools (2)
│       └── DatabaseTools.cs               # Database CRUD tools (7)
├── SqlServer.Profiler.Mcp.Api/            # Debug REST API (Swagger on port 5100)
│   ├── SqlServer.Profiler.Mcp.Api.csproj
│   ├── Program.cs
│   ├── Controllers/
│   │   └── ProfilerController.cs
│   ├── Models/
│   │   └── RequestModels.cs
│   └── appsettings.json
├── SqlServer.Profiler.Mcp.Cli/            # Debug CLI (REPL + script mode)
│   ├── SqlServer.Profiler.Mcp.Cli.csproj
│   └── Program.cs
├── SqlServer.Profiler.Mcp.Tests/          # xUnit tests for core MCP library (228 tests)
│   └── ...
├── SqlServer.Profiler.Mcp.Api.Tests/      # xUnit tests for API project (29 tests)
│   └── ...
├── Dockerfile                             # Multi-stage build (bookworm-slim)
├── .dockerignore
├── SqlServer.Profiler.Mcp.slnx           # Solution file
├── CLAUDE.md
├── CONTRIBUTING.md
└── README.md

Development

Prerequisites

.NET 9 SDK
SQL Server 2012+ instance (local, Docker, or remote)
Docker (optional, for container builds)

Clone & Build

git clone https://github.com/tkmawarire/sql-sentinel.git
cd sql-sentinel
dotnet restore
dotnet build

Running the MCP Server Locally

dotnet run --project SqlServer.Profiler.Mcp/

The server communicates over stdio using the MCP protocol. Connect it to an MCP client (Claude Desktop, Claude Code, etc.) for interactive use.

Using the Debug API

The API project provides a REST wrapper around all MCP tools with Swagger UI for manual testing.

dotnet run --project SqlServer.Profiler.Mcp.Api/

Swagger UI: http://localhost:5100/
Configure the connection string via environment variable SQL_SENTINEL_CONNECTION_STRING

Using the Debug CLI

The CLI project provides an interactive REPL and script mode for testing tools directly.

# Interactive REPL mode
dotnet run --project SqlServer.Profiler.Mcp.Cli/

# List all available tools
dotnet run --project SqlServer.Profiler.Mcp.Cli/ list

# Get help for a specific tool
dotnet run --project SqlServer.Profiler.Mcp.Cli/ help sqlsentinel_quick_capture

# Execute a single tool
dotnet run --project SqlServer.Profiler.Mcp.Cli/ call sqlsentinel_list_sessions

Set the SQL_SENTINEL_CONNECTION_STRING environment variable before running.

Docker Build

docker build -t sql-sentinel-mcp:test .
docker run -i --rm --network host sql-sentinel-mcp:test

Architecture

Key Patterns

Dependency injection via Microsoft.Extensions.Hosting
stdio transport — stdout is reserved for MCP protocol; all logging goes to stderr
Tool auto-discovery — MCP tools are discovered from the assembly via WithToolsFromAssembly()
XE session prefix — All created sessions are prefixed with mcp_sentinel_
Two event shapes — Standard events (query, login, recompile) with typed fields, and XML-payload events (deadlock, blocking) parsed from Extended Events XML

Adding a New MCP Tool

Create a public static method in the appropriate file under Tools/ (or create a new file)
Decorate with [McpServerTool(Name = "sqlsentinel_your_tool")] and [Description("...")]
Add parameters with [Description("...")] attributes — they become the tool's input schema
Inject services via method parameters (e.g., IProfilerService, IWaitStatsService)
Return a string (JSON or Markdown) — the framework handles MCP response wrapping

[McpServerTool(Name = "sqlsentinel_example")]
[Description("Description shown to AI agents")]
public static async Task<string> Example(
    IProfilerService profilerService,
    [Description("Optional filter")] string? filter = null)
{
    var connectionString = ConnectionStringResolver.Resolve();
    // Implementation
    return JsonSerializer.Serialize(result);
}

Troubleshooting

"Permission denied" creating session

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

Check connection string credentials
For Windows auth, ensure process runs under correct user
For Azure SQL, ensure firewall allows your IP

No events captured

Verify session is RUNNING (sqlsentinel_list_sessions)
Check filters aren't too restrictive
Verify target database/app is generating queries
Check minDurationMs isn't filtering everything

No deadlock events

Ensure session was created with eventTypes: "Deadlock"
Deadlocks must actually occur while the session is running

No blocking events

Ensure blocked process threshold is configured: sp_configure 'blocked process threshold', 5
Ensure session was created with eventTypes: "BlockedProcess"
Blocking must exceed the configured threshold (seconds)

Timeout reading events

Large ring buffers with many events can be slow to parse. Use:

Time filters to narrow the window
Increase command timeout in code if needed

Security Notes

The SQL_SENTINEL_CONNECTION_STRING environment variable contains credentials — secure appropriately
Don't leave sessions running indefinitely on production
Query text may contain sensitive data
Grant minimum required permissions

Contributing

See CONTRIBUTING.md for guidelines on submitting issues and pull requests.

License

MIT

This server cannot be installed

license - permissive license

quality - not tested

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

0dRelease cycle

5Releases (12mo)

Commit activity

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Servers

mcp-sqlserver
Databases Developer Tools
mlsloynaz
F
license
A
quality
D
maintenance
An MCP server for Microsoft SQL Server that enables executing read-only queries, listing tables, and describing database schemas. It offers specialized support for custom ports and multiple authentication methods including SQL credentials, NTLM, and Windows Integrated Auth.
Updated 5 months ago (2026-03-10 03:06 UTC)
3
mysql-mcp-server
mukul975
A
license
-
quality
C
maintenance
A production-ready MCP server for MySQL database operations, providing secure HTTP endpoints for read-only queries, performance analysis, and server monitoring.
Updated 15 days ago (2026-08-03 04:12 UTC)
45
9
MIT
MCP SQL Server
Databases Developer Tools
Attilio81
A
license
-
quality
B
maintenance
MCP server for SQL Server database inspection and querying, with connection pooling, security features, and a web manager UI.
Updated 19 days ago (2026-07-29 13:33 UTC)
4
MIT
dmc-sql-saglikofficial
Databases Monitoring
dmcteknoloji
F
license
-
quality
A
maintenance
Provides read-only SQL Server health diagnostics (server health, blocking queries, missing indexes) via MCP, with a GUI installer that automatically configures AI clients like Claude Desktop.
Updated 2 months ago (2026-06-19 07:51 UTC)

View all related MCP servers

Related MCP Connectors

mcp
MCP server for managing Prisma Postgres.
Azure DevOps (ADO)
The MCP server for Azure DevOps, bringing the power of Azure DevOps directly to your agents.
Supabase
MCP server for interacting with the Supabase platform

View all MCP Connectors

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/tkmawarire/sql-sentinel'

If you have feedback or need assistance with the MCP directory API, please join our Discord server

SQL Sentinel MCP Server

Features

Requirements

Installation

Option 1: Docker (Recommended)

Claude Desktop (claude_desktop_config.json)

Claude Code

Option 2: .NET Global Tool (NuGet)

Option 3: Build from Source

Connection Strings

MCP Tools Reference

Session Lifecycle

Event Retrieval

Diagnostics

Permissions

Database Operations

Usage Examples

Quick Debug Session

Find N+1 Queries

Trace Specific Operation

Deadlock Detection

Blocking Analysis

Server Health Check

Database Operations

Wait Stats (No Session Required)

Query Fingerprinting

Noise Filtering

Supported Event Types

Project Structure

Development

Prerequisites

Clone & Build

Running the MCP Server Locally

Using the Debug API

Using the Debug CLI

Docker Build

Architecture

Key Patterns

Adding a New MCP Tool

Troubleshooting

"Permission denied" creating session

"Login failed"

No events captured

No deadlock events

No blocking events

Timeout reading events

Security Notes

Contributing

License

Maintenance

Resources

Looking for Admin?

Related MCP Servers

mcp-sqlserver

mysql-mcp-server

MCP SQL Server

dmc-sql-saglikofficial

Related MCP Connectors

Latest Blog Posts

MCP directory API

Claude Desktop (`claude_desktop_config.json`)