MCP cover image
See in Github
2025-04-11

使用Claude Desktop测试的SQL Server的C#中的MCP服务器实现

1

Github Watches

1

Github Forks

1

Github Stars

MCP-SqlServer

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

The server register logs into a mcp_server.log file

Caution, the LLM can modify your database

Tools

List of tools provided to the LLM

  • HealthCheck: Tests if the Microsoft SQL Server Database connection is good and alive.
  • GetSchema: Get a list of all tables with their respective schema, columns and types.
  • Query: Execute a query into the Microsoft SQL Server database and return the result as a JSON.

Setup with Claude

  1. Fill the env.database with the connection string from your SQL Server
  2. Compile the project
  3. In the Claude Destkop Go File->Configurations->Developer and edit the MCP configuration (claude_desktop_config.json)
  4. Paste the json as:
{
    "mcpServers": {
        "database": {
            "command": "dotnet",
            "args": [
                "run",
                "--project",
                "C:\\Users\\{USER}\\Desktop\\MCP-SqlServer",
                "--no-build"
            ]
        }
    }
}
  1. Restart Claude Desktop

Testing

Open Claude Desktop and if everything is configured well you should be able to see this

image

Click on the icon and you should be able to see the tools

image

Asking for connection check

image

Asking for schema/table informations

image

Asking for read query

image

Asking for modifications

image

相关推荐

  • https://suefel.com
  • Latest advice and best practices for custom GPT development.

  • Yusuf Emre Yeşilyurt
  • I find academic articles and books for research and literature reviews.

  • https://maiplestudio.com
  • Find Exhibitors, Speakers and more

  • Carlos Ferrin
  • Encuentra películas y series en plataformas de streaming.

  • Joshua Armstrong
  • Confidential guide on numerology and astrology, based of GG33 Public information

  • Contraband Interactive
  • Emulating Dr. Jordan B. Peterson's style in providing life advice and insights.

  • rustassistant.com
  • Your go-to expert in the Rust ecosystem, specializing in precise code interpretation, up-to-date crate version checking, and in-depth source code analysis. I offer accurate, context-aware insights for all your Rust programming questions.

  • Elijah Ng Shi Yi
  • Advanced software engineer GPT that excels through nailing the basics.

  • Emmet Halm
  • Converts Figma frames into front-end code for various mobile frameworks.

  • Alexandru Strujac
  • Efficient thumbnail creator for YouTube videos

  • lumpenspace
  • Take an adjectivised noun, and create images making it progressively more adjective!

  • apappascs
  • 发现市场上最全面,最新的MCP服务器集合。该存储库充当集中式枢纽,提供了广泛的开源和专有MCP服务器目录,并提供功能,文档链接和贡献者。

  • ShrimpingIt
  • MCP系列GPIO Expander的基于Micropython I2C的操作,源自ADAFRUIT_MCP230XX

  • modelcontextprotocol
  • 模型上下文协议服务器

  • Mintplex-Labs
  • 带有内置抹布,AI代理,无代理构建器,MCP兼容性等的多合一桌面和Docker AI应用程序。

  • n8n-io
  • 具有本机AI功能的公平代码工作流程自动化平台。将视觉构建与自定义代码,自宿主或云相结合,400+集成。

  • ravitemer
  • 一个功能强大的Neovim插件,用于管理MCP(模型上下文协议)服务器

  • WangRongsheng
  • 🧑‍🚀 llm 资料总结(数据处理、模型训练、模型部署、 o1 模型、mcp 、小语言模型、视觉语言模型)|摘要世界上最好的LLM资源。

  • jae-jae
  • MCP服务器使用剧作《无头浏览器》获取网页内容。

  • patruff
  • Ollama和MCP服务器之间的桥梁,使本地LLMS可以使用模型上下文协议工具

    Reviews

    3 (1)
    Avatar
    user_970NK99m
    2025-04-18

    MCP-SqlServer by RodrigoPAml is an outstanding tool for anyone working with SQL Server. The functionality and ease of use are top-notch, making database management a breeze. The documentation is comprehensive and the community support is fantastic. I highly recommend it for both beginners and advanced users. Check it out on GitHub!