Back to MCP directory
publicPublicdnsLocal runtime

mssql-mcp-server

一个用于连接Microsoft SQL Server的模型上下文协议(MCP)服务器

article

README

🚀 mssql-mcp-server

mssql-mcp-server 是用于连接 Microsoft SQL Server 的 Model Context Protocol (MCP) 服务器,它能帮助用户便捷地与 Microsoft SQL Server 建立连接,为相关业务提供有力支持。

🚀 快速开始

📦 安装指南

你可以按照以下步骤安装 mssql-mcp-server:

git clone https://github.com/leopeng1995/mssql-mcp-server.git
cd mssql-mcp-server

uv sync
uv run mssql-mcp-server

⚙️ 命令行配置

通过以下的 JSON 配置文件进行命令行配置:

{
  "mcpServers": {
    "mssql-mcp-server": {
      "command": "uv",
      "args": [
        "--directory",
        "H:/workspaces/leopeng1995/mssql-mcp-server",
        "run",
        "mssql-mcp-server"
      ],
      "env": {
        "MSSQL_SERVER": "localhost",
        "MSSQL_PORT": "1433",
        "MSSQL_USER": "username",
        "MSSQL_PASSWORD": "password"
      }
    }
  }
}
help

Runtime guide

cloud

Hosted runtime

Hosted servers run from a provider-managed environment. You usually connect the MCP client to the hosted endpoint or follow the provider's authorization flow, without keeping a local process alive

  1. Open provider connection page
  2. Authorize or copy endpoint
  3. Connect from your MCP client
terminal

Local runtime / other methods

Local servers run on your own machine or infrastructure. You normally copy the server_config into your MCP client, install the required package, and provide env variables from env_schema when needed

  1. Copy server_config
  2. Install required package
  3. Fill env variables and restart client