tsql-mcp-server

tsql-mcp-server

3.3

If you are the rightful owner of tsql-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol (MCP) server for interacting with SQL Server databases, enabling LLMs to query and inspect databases through a standardized protocol.

The SQL Server MCP Server is designed to facilitate seamless interaction between Large Language Models (LLMs) and SQL Server databases. By leveraging the Model Context Protocol, this server allows LLMs to execute SQL queries, inspect database schemas, and access database resources in a secure and efficient manner. The server supports features such as SQL injection prevention, resource caching, and schema inspection, making it a robust tool for database management and interaction. It can be installed as a .NET tool or built from source, providing flexibility in deployment. The server is configured to work with various LLM platforms that support MCP, such as Claude, and offers a RESTful approach to accessing database resources.

Features

  • Database Querying: Execute SQL queries and retrieve results.
  • Schema Inspection: List tables, views, stored procedures, and examine table schemas.
  • SQL Injection Prevention: Built-in validation to prevent SQL injection attacks.
  • Resource Caching: Metadata caching for improved performance.

Tools

  1. ExecuteQuery

    Executes a SQL query against the database and returns the results.