SQL Server MCP Client

What is SQL Server MCP Client?

A comprehensive Microsoft SQL Server client implementing the Model Context Protocol (MCP). It provides tools for executing SQL queries, managing stored procedures, listing tables, and retrieving schema information from SQL Server databases. Built with .NET Core using the MCP C# SDK, it can be deployed directly or as a Docker container. The server operates in two modes: Database Mode (when a specific database is specified in the connection string) and Server Mode (when no database is specified, allowing server-wide operations across all databases).

How to use SQL Server MCP Client?

Install as a .NET global tool (dotnet tool install --global Ave.McpServer.MsSqlClient) or run as a Docker container. Configure it as an MCP server in Claude Desktop/Claude Code by adding the mssql entry to the mcpServers configuration with the MSSQL_CONNECTIONSTRING environment variable. By default, only read-only tools are enabled; to enable query and stored procedure execution, set the corresponding DatabaseConfiguration__Enable* environment variables to "true".

Key features of SQL Server MCP Client

• Execute SQL queries and stored procedures with type-safe automatic JSON-to-SQL conversion
• List all tables with schema and row count information
• Retrieve detailed schema information for specific tables
• Discover stored procedure parameters in table or JSON Schema format
• Configurable timeouts and background session management for long-running operations
• Automatic execution timing and optional query profiling with IO statistics and XML plans
• Two-mode architecture optimized for single-database or multi-database scenarios

Use cases of SQL Server MCP Client

• Enable AI assistants to query and interact with SQL Server databases through natural language
• Automate schema discovery and documentation generation across multiple databases
• Debug and analyze SQL Server performance with execution timing and profiling tools
• Manage stored procedures and parameters programmatically via MCP tools
• Integrate SQL Server operations into workflows built on the Model Context Protocol

FAQ from SQL Server MCP Client

Why are query and stored procedure execution tools disabled by default?

For security reasons as of version 0.0.5. You must explicitly enable them by setting the corresponding environment variables to "true" to prevent unintended data modification.

What are the prerequisites for running the server?

.NET 10.0 SDK for local development/deployment, or Docker for container deployment. For integration tests, Docker must be running.

How can I enable query and stored procedure execution?

Set the environment variables DatabaseConfiguration__EnableExecuteQuery, DatabaseConfiguration__EnableExecuteStoredProcedure, DatabaseConfiguration__EnableStartQuery, and DatabaseConfiguration__EnableStartStoredProcedure to "true" in the MCP server configuration.

What are the two modes of operation?

Database Mode restricts operations to a single database specified in the connection string. Server Mode allows operations across all databases on the server when no database is specified.

How is the server deployed?

As a .NET global tool from NuGet (Ave.McpServer.MsSqlClient) or as a Docker image on Docker Hub (aadversteeg/mssqlclient-mcp-server:latest). You can also build from source using dotnet build.