MCP-SqlServer

Created By
RodrigoPAmla year ago
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?

  1. Checking the health of SQL Server connections.
  2. Retrieving database schema information.
  3. 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#.

Project Info
Created At
a year ago
Updated At
a year ago
Author Name
RodrigoPAml
Star
2
Language
C#
License
MIT license

Recommend Servers

View All
Payai X402 Tools

3 hours ago
Voyei

15 hours ago
Payai X402 Tools

3 hours ago