让智能体连接 SQL Server(mssql)数据库并执行查询。
接入配置
选择客户端,复制配置,再按项目文档补齐环境变量。
claude mcp add jewei-mssql --env DB_HOST='<DB_HOST>' --env DB_NAME='<DB_NAME>' --env DB_PASSWORD='<DB_PASSWORD>' --env DB_PORT='<DB_PORT>' --env DB_USER='<DB_USER>' -- uvx jewei-mssql-mcp-server~/.codex/config.toml
[mcp_servers.jewei-mssql]
command = "uvx"
args = ["jewei-mssql-mcp-server"]
env = { DB_HOST = "<DB_HOST>", DB_NAME = "<DB_NAME>", DB_PASSWORD = "<DB_PASSWORD>", DB_PORT = "<DB_PORT>", DB_USER = "<DB_USER>" }
# codex mcp add jewei-mssql --env DB_HOST='<DB_HOST>' --env DB_NAME='<DB_NAME>' --env DB_PASSWORD='<DB_PASSWORD>' --env DB_PORT='<DB_PORT>' --env DB_USER='<DB_USER>' -- uvx jewei-mssql-mcp-server~/.cursor/mcp.json
{
"mcpServers": {
"jewei-mssql": {
"command": "uvx",
"args": [
"jewei-mssql-mcp-server"
],
"env": {
"DB_HOST": "<DB_HOST>",
"DB_NAME": "<DB_NAME>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_PORT": "<DB_PORT>",
"DB_USER": "<DB_USER>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"jewei-mssql": {
"type": "stdio",
"command": "uvx",
"args": [
"jewei-mssql-mcp-server"
],
"env": {
"DB_HOST": "<DB_HOST>",
"DB_NAME": "<DB_NAME>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_PORT": "<DB_PORT>",
"DB_USER": "<DB_USER>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"jewei-mssql": {
"command": "uvx",
"args": [
"jewei-mssql-mcp-server"
],
"env": {
"DB_HOST": "<DB_HOST>",
"DB_NAME": "<DB_NAME>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_PORT": "<DB_PORT>",
"DB_USER": "<DB_USER>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"jewei-mssql": {
"command": "uvx",
"args": [
"jewei-mssql-mcp-server"
],
"env": {
"DB_HOST": "<DB_HOST>",
"DB_NAME": "<DB_NAME>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_PORT": "<DB_PORT>",
"DB_USER": "<DB_USER>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"jewei-mssql": {
"command": "uvx",
"args": [
"jewei-mssql-mcp-server"
],
"env": {
"DB_HOST": "<DB_HOST>",
"DB_NAME": "<DB_NAME>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_PORT": "<DB_PORT>",
"DB_USER": "<DB_USER>"
}
}
}
}需要的环境变量
DB_HOSTDB_NAMEDB_PASSWORDDB_PORTDB_USER
把占位值换成你自己的密钥;不要把密钥提交到代码仓库。