MCP-SqlServer

MCP-SqlServer

8
databases

MCP-SqlServer is a C# implementation of a Model Context Protocol Server that facilitates integration with SQL Server databases, offering functionalities such as health checks and schema retrieval. Designed to work with Claude Desktop, it supports executing queries and provides results in JSON format.

MCP-SqlServer

A MCP Server (STDIO) implementation in C# for integrating LLM with SQL Server, tested with Claude Desktop. It logs operations in a mcp_server.log file.

Tools

  • HealthCheck: Verifies the Microsoft SQL Server Database connection.
  • GetSchema: Retrieves a list of all tables with schemas, columns, and types.
  • Query: Executes a SQL query and returns the result as JSON.

Setup with Claude

  1. Fill the env.database with the SQL Server connection string.
  2. Compile the project.
  3. Configure the MCP settings in Claude Desktop in claude_desktop_config.json.
  4. Use the provided JSON configuration for setting up MCP servers.
  5. Restart Claude Desktop.

Testing

After configuration, reloading Claude Desktop should show available tools.