mssql-mcp-server 是用于连接到 Microsoft SQL Server 的模型上下文协议 (MCP) 服务器,它为连接微软 SQL 服务器提供了便捷的解决方案。
git clone https://github.com/leopeng1995/mssql-mcp-server.git
cd mssql-mcp-server
uv sync
uv run mssql-mcp-server
{
"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" # 或 CP936 ...
},
"disabled": false,
"autoApprove": []
}
}
}
⚠️ 重要提示
MSSQL_CHARSET的值区分大小写。