MSSQL MCP Server

Name: MSSQL MCP Server
Author: c0h1b4

@c0h1b4

代码仓库

关于 MSSQL MCP Server

暂无概览

基本信息

分类

数据库

许可证

MIT

运行时

node

传输方式

stdio

发布者

c0h1b4

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mssql-mcp-server-c0h1b4": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@c0h1b4/mssql-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MSSQL MCP Server?

A Model Context Protocol (MCP) server that connects to Microsoft SQL Server databases. It provides tools for executing SQL queries and managing database connections, primarily for AI assistants like Claude.

How to use MSSQL MCP Server?

Install via npm (npm install mssql-mcp-server) or using Smithery. Add the server to your MCP settings configuration file with environment variables for either a full connection string or individual connection parameters (host, port, database, user, password). Then invoke the query tool to run SQL queries.

Key features of MSSQL MCP Server

Execute SQL queries on Microsoft SQL Server databases
Supports connection string or individual connection parameters
Blocks dangerous SQL commands (DROP, TRUNCATE, ALTER, etc.)
Validates input parameters and database names
Implements connection pooling for performance and security
Runs locally or in Docker container

Use cases of MSSQL MCP Server

Let an AI assistant query a SQL Server database in natural language
Automate database reporting through an AI agent
Build intelligent workflows that read and analyze database tables
Provide a secure, sandboxed SQL interface for LLM-based tools

FAQ from MSSQL MCP Server

What is MSSQL MCP Server?

It is an MCP server that enables AI assistants to connect to and query Microsoft SQL Server databases using the Model Context Protocol.

How do I install MSSQL MCP Server?

You can install it via npm with npm install mssql-mcp-server or automatically through Smithery using npx -y @smithery/cli install @c0h1b4/mssql-mcp-server --client claude.

How do I configure the database connection?

Set environment variables in your MCP settings file: either MSSQL_CONNECTION_STRING with a full connection string, or individual parameters like MSSQL_HOST, MSSQL_PORT, MSSQL_DATABASE, MSSQL_USER, and MSSQL_PASSWORD.

What safety measures does MSSQL MCP Server include?

It blocks potentially harmful commands such as DROP, TRUNCATE, ALTER, CREATE, and EXEC. It also validates input parameters, limits query length and timeout, and uses connection pooling.

Can I run MSSQL MCP Server with Docker?

Yes. A docker-compose.yml is provided to start both SQL Server and the MCP server, or you can build the image manually with docker build -t mssql-mcp-server . and run the container.