MCP SqlServer

@RodrigoPAml

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

RodrigoPAml

关于 MCP SqlServer

A MCP Server implementation in C# for LLM integration with SQL Server tested with Claude Desktop

#sql-server #llm #mcp-server

MCP SqlServer 配置

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

{
  "mcpServers": {
    "database": {
      "command": "dotnet",
      "args": [
        "run",
        "--project",
        "C:\\Users\\{USER}\\Desktop\\MCP-SqlServer",
        "--no-build"
      ]
    }
  }
}

MCP SqlServer 工具

工具列表暂未提供

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

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

概览

What is MCP-SqlServer?

MCP-SqlServer is an MCP server (STDIO) written in C# that integrates LLMs with Microsoft SQL Server. It is tested with Claude Desktop and provides tools for database health checks, schema retrieval, and query execution.

How to use MCP-SqlServer?

Configure the connection string in the _env.database file, compile the project, then add the MCP server to your Claude Desktop configuration using dotnet run --project --no-build. Restart Claude Desktop to see the tools.

Key features of MCP-SqlServer

HealthCheck tool to test SQL Server connectivity.
GetSchema tool to list tables, schemas, columns, and types.
Query tool to execute SQL queries and return JSON results.
Logs server activity to mcp_server.log.
Caution: the LLM can modify your database.
Written in C# for .NET.

Use cases of MCP-SqlServer

Verify database connectivity before other operations.
Explore database schema for LLM‑driven data understanding.
Execute read queries and retrieve results as JSON.
Perform database modifications (with awareness of the included caution).

常见问题

What is MCP-SqlServer?

It is an MCP server implementation in C# that allows LLMs to interact with Microsoft SQL Server databases through a set of predefined tools.

What tools does MCP-SqlServer provide?

Three tools: HealthCheck (connection test), GetSchema (table and column metadata), and Query (run SQL queries, return JSON).

How is MCP-SqlServer configured with Claude Desktop?

Add a JSON entry to the `claude_desktop_config.json` file specifying the command `dotnet` with arguments `run`, `--project`, and the project path along with `--no-build`.

What runtime or dependencies are required?

The server requires the .NET runtime to compile and run via `dotnet`. No additional databases or authentication mechanisms are mentioned beyond the SQL Server connection string.

What caution should be taken when using MCP-SqlServer?

The LLM can modify your database, so you should protect sensitive data and restrict permissions as needed.

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

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl