Description

This MCP server provides robust SQL Server database access for AI agents through a well-architected .NET application built with Akka.NET for internal coordination and the official MCP C# SDK. Created by Aaron Stannard to address reliability issues with existing database MCP solutions, particularly on Windows, it offers three core tools: execute_sql for running any SQL query, list_tables for schema discovery with row counts, and list_schemas for database exploration. The implementation includes comprehensive error handling, T-SQL syntax validation to prevent invalid inputs from AI agents, automatic connection validation, and Docker support with multi-platform container builds, making it valuable for AI-powered database administration, data analysis workflows, and applications requiring reliable SQL Server integration across Windows, macOS, and Linux environments.

Installation

git clone https://github.com/aaronontheweb/mssql-mcp

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": {
      "command": "node",
      "args": [
        "path/to/server.js"
      ]
    }
  }
}