A MCP Server implementation in C# for LLM integration with SQL Server tested with Claude Desktop
Overview
What is MCP-SqlServer?
MCP-SqlServer is a C# implementation of a MCP Server designed for integrating Large Language Models (LLMs) with SQL Server, specifically tested with Claude Desktop.
How to use MCP-SqlServer?
To use MCP-SqlServer, you need to set up the connection string for your SQL Server in the environment configuration, compile the project, and configure it within Claude Desktop.
Key features of MCP-SqlServer?
- HealthCheck tool to verify SQL Server database connection.
- GetTablesWithColumnsAndTypes tool to retrieve all tables and their respective columns.
- Query tool to execute SQL queries and return results in JSON format.
Use cases of MCP-SqlServer?
- Checking the health of SQL Server connections.
- Retrieving database schema information.
- Executing SQL queries and processing results through LLMs.
FAQ from MCP-SqlServer?
- Can MCP-SqlServer modify my database?
Yes, caution is advised as the LLM can modify your database.
- Is there a logging feature?
Yes, all server logs are recorded in a mcp_server.log file.
- What programming language is used?
MCP-SqlServer is implemented in C#.