mssql-mcp-server
13
The MSSQL MCP Server is a tool for connecting to Microsoft SQL Server databases, providing capabilities to execute SQL queries and manage connections securely. It features safeguards against risky operations and can be installed via Smithery or manually.
MSSQL MCP Server
A Model Context Protocol (MCP) server for connecting to Microsoft SQL Server databases. This server provides tools for executing SQL queries and managing database connections.
Installation
Installing via Smithery
To install MSSQL MCP Server for Claude Desktop automatically via Smithery:
Manual Installation
Usage
Add the server to your MCP settings configuration file.
Tools
query
Execute a SQL query on a MSSQL database.
Parameters
connectionString(string, optional)host(string, optional)port(number, optional)database(string, optional)username(string, optional)password(string, optional)query(string, required)encrypt(boolean, optional)trustServerCertificate(boolean, optional)
Running the Server
Local Development
Using Docker
Testing
Security
The server includes safeguards against dangerous SQL operations.