MCP SQL Express

Name: MCP SQL Express
Author: hanweg

hanweg

Get started Repository

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

Setup

Choose your client, copy the config, then fill in any required environment variables.

Add to Cursor Add to 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"
      ]
    }
  }
}

Setup

Related