MCP DBS

Name: MCP DBS
Author: cuongtl1992

cuongtl1992

开始使用源码仓库

Connects LLMs to SQL databases including SQLite, SQL Server and PostgreSQL to run queries.

接入配置

选择客户端，复制配置，再按项目文档补齐环境变量。

一键添加到 Cursor 一键添加到 VS Code

claude mcp add dbs --env MCP_MSSQL_SERVER='<MCP_MSSQL_SERVER>' --env MCP_MSSQL_PORT='<MCP_MSSQL_PORT>' --env MCP_MSSQL_DATABASE='<MCP_MSSQL_DATABASE>' --env MCP_MSSQL_USER='<MCP_MSSQL_USER>' --env MCP_MSSQL_PASSWORD='<MCP_MSSQL_PASSWORD>' --env MCP_MSSQL_ENCRYPT='<MCP_MSSQL_ENCRYPT>' --env MCP_MSSQL_TRUST_SERVER_CERTIFICATE='<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>' --env MCP_MONGODB_URI='<MCP_MONGODB_URI>' --env MCP_MONGODB_DATABASE='<MCP_MONGODB_DATABASE>' -- npx -y mcp-dbs@1.0.4 --stdio

~/.codex/config.toml

[mcp_servers.dbs]
command = "npx"
args = ["-y", "mcp-dbs@1.0.4", "--stdio"]
env = { MCP_MSSQL_SERVER = "<MCP_MSSQL_SERVER>", MCP_MSSQL_PORT = "<MCP_MSSQL_PORT>", MCP_MSSQL_DATABASE = "<MCP_MSSQL_DATABASE>", MCP_MSSQL_USER = "<MCP_MSSQL_USER>", MCP_MSSQL_PASSWORD = "<MCP_MSSQL_PASSWORD>", MCP_MSSQL_ENCRYPT = "<MCP_MSSQL_ENCRYPT>", MCP_MSSQL_TRUST_SERVER_CERTIFICATE = "<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>", MCP_MONGODB_URI = "<MCP_MONGODB_URI>", MCP_MONGODB_DATABASE = "<MCP_MONGODB_DATABASE>" }

# codex mcp add dbs --env MCP_MSSQL_SERVER='<MCP_MSSQL_SERVER>' --env MCP_MSSQL_PORT='<MCP_MSSQL_PORT>' --env MCP_MSSQL_DATABASE='<MCP_MSSQL_DATABASE>' --env MCP_MSSQL_USER='<MCP_MSSQL_USER>' --env MCP_MSSQL_PASSWORD='<MCP_MSSQL_PASSWORD>' --env MCP_MSSQL_ENCRYPT='<MCP_MSSQL_ENCRYPT>' --env MCP_MSSQL_TRUST_SERVER_CERTIFICATE='<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>' --env MCP_MONGODB_URI='<MCP_MONGODB_URI>' --env MCP_MONGODB_DATABASE='<MCP_MONGODB_DATABASE>' -- npx -y mcp-dbs@1.0.4 --stdio

~/.cursor/mcp.json

{
  "mcpServers": {
    "dbs": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dbs@1.0.4",
        "--stdio"
      ],
      "env": {
        "MCP_MSSQL_SERVER": "<MCP_MSSQL_SERVER>",
        "MCP_MSSQL_PORT": "<MCP_MSSQL_PORT>",
        "MCP_MSSQL_DATABASE": "<MCP_MSSQL_DATABASE>",
        "MCP_MSSQL_USER": "<MCP_MSSQL_USER>",
        "MCP_MSSQL_PASSWORD": "<MCP_MSSQL_PASSWORD>",
        "MCP_MSSQL_ENCRYPT": "<MCP_MSSQL_ENCRYPT>",
        "MCP_MSSQL_TRUST_SERVER_CERTIFICATE": "<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>",
        "MCP_MONGODB_URI": "<MCP_MONGODB_URI>",
        "MCP_MONGODB_DATABASE": "<MCP_MONGODB_DATABASE>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "dbs": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-dbs@1.0.4",
        "--stdio"
      ],
      "env": {
        "MCP_MSSQL_SERVER": "<MCP_MSSQL_SERVER>",
        "MCP_MSSQL_PORT": "<MCP_MSSQL_PORT>",
        "MCP_MSSQL_DATABASE": "<MCP_MSSQL_DATABASE>",
        "MCP_MSSQL_USER": "<MCP_MSSQL_USER>",
        "MCP_MSSQL_PASSWORD": "<MCP_MSSQL_PASSWORD>",
        "MCP_MSSQL_ENCRYPT": "<MCP_MSSQL_ENCRYPT>",
        "MCP_MSSQL_TRUST_SERVER_CERTIFICATE": "<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>",
        "MCP_MONGODB_URI": "<MCP_MONGODB_URI>",
        "MCP_MONGODB_DATABASE": "<MCP_MONGODB_DATABASE>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "dbs": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dbs@1.0.4",
        "--stdio"
      ],
      "env": {
        "MCP_MSSQL_SERVER": "<MCP_MSSQL_SERVER>",
        "MCP_MSSQL_PORT": "<MCP_MSSQL_PORT>",
        "MCP_MSSQL_DATABASE": "<MCP_MSSQL_DATABASE>",
        "MCP_MSSQL_USER": "<MCP_MSSQL_USER>",
        "MCP_MSSQL_PASSWORD": "<MCP_MSSQL_PASSWORD>",
        "MCP_MSSQL_ENCRYPT": "<MCP_MSSQL_ENCRYPT>",
        "MCP_MSSQL_TRUST_SERVER_CERTIFICATE": "<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>",
        "MCP_MONGODB_URI": "<MCP_MONGODB_URI>",
        "MCP_MONGODB_DATABASE": "<MCP_MONGODB_DATABASE>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "dbs": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dbs@1.0.4",
        "--stdio"
      ],
      "env": {
        "MCP_MSSQL_SERVER": "<MCP_MSSQL_SERVER>",
        "MCP_MSSQL_PORT": "<MCP_MSSQL_PORT>",
        "MCP_MSSQL_DATABASE": "<MCP_MSSQL_DATABASE>",
        "MCP_MSSQL_USER": "<MCP_MSSQL_USER>",
        "MCP_MSSQL_PASSWORD": "<MCP_MSSQL_PASSWORD>",
        "MCP_MSSQL_ENCRYPT": "<MCP_MSSQL_ENCRYPT>",
        "MCP_MSSQL_TRUST_SERVER_CERTIFICATE": "<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>",
        "MCP_MONGODB_URI": "<MCP_MONGODB_URI>",
        "MCP_MONGODB_DATABASE": "<MCP_MONGODB_DATABASE>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "dbs": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dbs@1.0.4",
        "--stdio"
      ],
      "env": {
        "MCP_MSSQL_SERVER": "<MCP_MSSQL_SERVER>",
        "MCP_MSSQL_PORT": "<MCP_MSSQL_PORT>",
        "MCP_MSSQL_DATABASE": "<MCP_MSSQL_DATABASE>",
        "MCP_MSSQL_USER": "<MCP_MSSQL_USER>",
        "MCP_MSSQL_PASSWORD": "<MCP_MSSQL_PASSWORD>",
        "MCP_MSSQL_ENCRYPT": "<MCP_MSSQL_ENCRYPT>",
        "MCP_MSSQL_TRUST_SERVER_CERTIFICATE": "<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>",
        "MCP_MONGODB_URI": "<MCP_MONGODB_URI>",
        "MCP_MONGODB_DATABASE": "<MCP_MONGODB_DATABASE>"
      }
    }
  }
}

需要的环境变量

MCP_MSSQL_SERVER
MCP_MSSQL_PORT
MCP_MSSQL_DATABASE
MCP_MSSQL_USER
MCP_MSSQL_PASSWORD
MCP_MSSQL_ENCRYPT
MCP_MSSQL_TRUST_SERVER_CERTIFICATE
MCP_MONGODB_URI
MCP_MONGODB_DATABASE

把占位值换成你自己的密钥；不要把密钥提交到代码仓库。

接入配置

需要的环境变量

相关推荐