knight0zh_mssql-mcp-server

knight0zh_mssql-mcp-server

3.2

If you are the rightful owner of knight0zh_mssql-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 connecting to Microsoft SQL Server databases, providing tools for executing SQL queries and managing database connections.

The MSSQL MCP Server is a specialized server designed to facilitate seamless interaction with Microsoft SQL Server databases. It leverages the Model Context Protocol (MCP) to provide a robust framework for executing SQL queries and managing database connections efficiently. This server is particularly useful for developers and database administrators who require a reliable and scalable solution for database operations. By abstracting the complexities of direct database interactions, the MSSQL MCP Server allows users to focus on their core tasks without worrying about the underlying connection management. It supports both full connection strings and individual connection parameters, offering flexibility in how connections are configured. Additionally, the server includes features for encryption and server certificate trust, ensuring secure data transactions. With its easy installation process via Smithery or manual setup, the MSSQL MCP Server is accessible to a wide range of users, from those using Claude Desktop to those integrating it into custom environments.

Features

  • Seamless integration with Microsoft SQL Server databases.
  • Support for executing SQL queries and managing connections.
  • Flexible connection configuration with full connection strings or individual parameters.
  • Security features including encryption and server certificate trust.
  • Easy installation via Smithery or manual setup.

Tools

  1. query

    Execute a SQL query on a MSSQL database.