shield_lock
JinDaGe
Contact
← Back to MCP directory
publicPublicdnsLocal runtime

mssql-mcp-server

一座连接人工智能助手和ArXiv研究存储库的桥梁，通过消息控制协议实现搜索、下载和阅读学术论文的功能。

article

README

mssql-mcp-server

mssql-mcp-server is a Model Context Protocol (MCP) server for connecting to Microsoft SQL Server.

Installation

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

uv sync
uv run mssql-mcp-server

Configuration in Cline

{
  "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",
        "MSSQL_DATABASE": "database",
        "MSSQL_CHARSET": "UTF-8" # or CP936 ...
      },
      "disabled": false,
      "autoApprove": []
    }
  }
}

Note: The MSSQL_CHARSET value is case-sensitive.

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