MCP SQL Express

Name: MCP SQL Express
Author: hanweg

hanweg

开始使用源码仓库

Lets agents work with Microsoft SQL Server Express: run queries, manage tables and check the server.

接入配置

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

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

claude mcp add sql-express -- uv --directory PATHTOPROJECTmcp-sqlexpress run mcp-server-sqlexpress --server serverinstance --auth windows --trusted-connection yes --trust-server-certificate yes --allowed-databases database1,database2

~/.codex/config.toml

[mcp_servers.sql-express]
command = "uv"
args = ["--directory", "PATHTOPROJECTmcp-sqlexpress", "run", "mcp-server-sqlexpress", "--server", "serverinstance", "--auth", "windows", "--trusted-connection", "yes", "--trust-server-certificate", "yes", "--allowed-databases", "database1,database2"]

# codex mcp add sql-express -- uv --directory PATHTOPROJECTmcp-sqlexpress run mcp-server-sqlexpress --server serverinstance --auth windows --trusted-connection yes --trust-server-certificate yes --allowed-databases database1,database2

~/.cursor/mcp.json

{
  "mcpServers": {
    "sql-express": {
      "command": "uv",
      "args": [
        "--directory",
        "PATHTOPROJECTmcp-sqlexpress",
        "run",
        "mcp-server-sqlexpress",
        "--server",
        "serverinstance",
        "--auth",
        "windows",
        "--trusted-connection",
        "yes",
        "--trust-server-certificate",
        "yes",
        "--allowed-databases",
        "database1,database2"
      ]
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "sql-express": {
      "type": "stdio",
      "command": "uv",
      "args": [
        "--directory",
        "PATHTOPROJECTmcp-sqlexpress",
        "run",
        "mcp-server-sqlexpress",
        "--server",
        "serverinstance",
        "--auth",
        "windows",
        "--trusted-connection",
        "yes",
        "--trust-server-certificate",
        "yes",
        "--allowed-databases",
        "database1,database2"
      ]
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "sql-express": {
      "command": "uv",
      "args": [
        "--directory",
        "PATHTOPROJECTmcp-sqlexpress",
        "run",
        "mcp-server-sqlexpress",
        "--server",
        "serverinstance",
        "--auth",
        "windows",
        "--trusted-connection",
        "yes",
        "--trust-server-certificate",
        "yes",
        "--allowed-databases",
        "database1,database2"
      ]
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "sql-express": {
      "command": "uv",
      "args": [
        "--directory",
        "PATHTOPROJECTmcp-sqlexpress",
        "run",
        "mcp-server-sqlexpress",
        "--server",
        "serverinstance",
        "--auth",
        "windows",
        "--trusted-connection",
        "yes",
        "--trust-server-certificate",
        "yes",
        "--allowed-databases",
        "database1,database2"
      ]
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "sql-express": {
      "command": "uv",
      "args": [
        "--directory",
        "PATHTOPROJECTmcp-sqlexpress",
        "run",
        "mcp-server-sqlexpress",
        "--server",
        "serverinstance",
        "--auth",
        "windows",
        "--trusted-connection",
        "yes",
        "--trust-server-certificate",
        "yes",
        "--allowed-databases",
        "database1,database2"
      ]
    }
  }
}

接入配置

相关推荐