Advertise
MCP.so
Sign In

SQL Server MCP Client

@aadversteeg

Repository

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

aadversteeg

About SQL Server MCP Client

A Microsoft SQL Server client implementing the Model Context Protocol (MCP). This server provides SQL query capabilities through a simple MCP interface.

SQL Server MCP Client config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mssqlclient-mcp-server": {
      "command": "docker",
      "args": [
        "pull",
        "aadversteeg/mssqlclient-mcp-server:latest"
      ]
    }
  }
}

SQL Server MCP Client tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

1

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.

2

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.

3

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.

4

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.

5

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`.

Comments

More Databases MCP servers

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Advertise