广告合作
MCP.so
登录

SQL Server MCP Client

@aadversteeg

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

aadversteeg

关于 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 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

SQL Server MCP Client 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

常见问题

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

评论

数据库 分类下的更多 MCP 服务器

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498
广告合作