Skip to content
Conduit

mcp server

sqlbot-mcp-proxy

MCP server proxy for SQLBot natural-language data querying and report generation.

wenRou21/sqlbot-mcp-proxycommunitylistedunreviewed
Use tool

Set up

Runs on your computer. Pick your agent and operating system.

Before you start

  • Docker Desktop
~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "sqlbot-mcp-proxy": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "SQLBOT_MCP_PROXY_BASE_URL",
        "-e",
        "SQLBOT_MCP_PROXY_ACCESS_KEY",
        "-e",
        "SQLBOT_MCP_PROXY_SECRET_KEY",
        "-e",
        "SQLBOT_MCP_PROXY_DOCKER_CONTAINER",
        "ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0"
      ]
    }
  }
}

same format Cursor, GitHub Copilot CLI, Junie, JetBrains AI Assistant, Augment (Auggie CLI), Factory Droid, Kiro, Devin CLI +12

Values in angle brackets are placeholders. Restart Claude Desktop after editing its config.Claude Desktop docs

README

synced Oct 17, 2026

SQLBot MCP Proxy

MCP server proxy for SQLBot. It exposes SQLBot datasource discovery, table metadata, natural-language Text-to-SQL questions, and local fallback report generation as MCP tools.

Requirements

  • Docker
  • A running SQLBot service
  • SQLBot API keys

Recommended Codex Config

Users do not need to download this repository manually. Add this single MCP server to Codex config and replace the SQLBot URL and keys:

[mcp_servers.sqlbot]
command = "docker"
args = [
  "run",
  "--rm",
  "-i",
  "-e",
  "SQLBOT_MCP_PROXY_BASE_URL",
  "-e",
  "SQLBOT_MCP_PROXY_ACCESS_KEY",
  "-e",
  "SQLBOT_MCP_PROXY_SECRET_KEY",
  "ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0"
]
enabled = true
startup_timeout_sec = 120

[mcp_servers.sqlbot.env]
SQLBOT_MCP_PROXY_BASE_URL = "http://183.196.108.32:18088"
SQLBOT_MCP_PROXY_ACCESS_KEY = "<YOUR_SQLBOT_ACCESS_KEY>"
SQLBOT_MCP_PROXY_SECRET_KEY = "<YOUR_SQLBOT_SECRET_KEY>"

Then restart Codex completely.

If SQLBot is reachable through another public or LAN address, replace SQLBOT_MCP_PROXY_BASE_URL with that address, for example https://sqlbot.example.com or http://192.168.1.10:18088.

Prompt Template

Please configure SQLBot MCP for Codex.

MCP image:
ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0

My SQLBot URL:
http://183.196.108.32:18088

My SQLBot access key:
<YOUR_SQLBOT_ACCESS_KEY>

My SQLBot secret key:
<YOUR_SQLBOT_SECRET_KEY>

Add this MCP to Codex config:
- MCP name: sqlbot
- command: docker
- args: ["run", "--rm", "-i", "-e", "SQLBOT_MCP_PROXY_BASE_URL", "-e", "SQLBOT_MCP_PROXY_ACCESS_KEY", "-e", "SQLBOT_MCP_PROXY_SECRET_KEY", "ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0"]
- startup_timeout_sec: 120
- SQLBOT_MCP_PROXY_BASE_URL: use the SQLBot URL above
- SQLBOT_MCP_PROXY_ACCESS_KEY: use the access key above
- SQLBOT_MCP_PROXY_SECRET_KEY: use the secret key above

After configuration, remind me to fully restart Codex.

After restart:
- Check available datasources with sqlbot_list_datasources.
- Use sqlbot_list_tables and sqlbot_describe_table before asking data questions.
- Use sqlbot_ask_data for Text-to-SQL questions.
- Use sqlbot_generate_report when I ask for an analysis report or chart.

Quick Docker Test

You can test the image outside Codex:

docker run --rm -i \
  -e SQLBOT_MCP_PROXY_BASE_URL=http://183.196.108.32:18088 \
  -e SQLBOT_MCP_PROXY_ACCESS_KEY=your-access-key \
  -e SQLBOT_MCP_PROXY_SECRET_KEY=your-secret-key \
  ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0

Tools

  • sqlbot_list_datasources: list SQLBot datasources visible to the configured API key
  • sqlbot_list_tables: list checked SQLBot metadata tables for a datasource
  • sqlbot_describe_table: describe checked fields for a SQLBot metadata table
  • sqlbot_ask_data: ask SQLBot a natural-language data question
  • sqlbot_generate_report: generate an analysis report and chart, with a local SVG fallback

Environment Variables

NameDefaultDescription
SQLBOT_MCP_PROXY_BASE_URLhttp://183.196.108.32:18088SQLBot service base URL
SQLBOT_MCP_PROXY_ACCESS_KEYemptySQLBot API access key
SQLBOT_MCP_PROXY_SECRET_KEYemptySQLBot API secret key
FEISHU_ASK_ACCESS_KEYemptyFallback access key name
FEISHU_ASK_SECRET_KEYemptyFallback secret key name
SQLBOT_MCP_PROXY_DOCKER_CONTAINERsqlbotContainer used for fallback key lookup
SQLBOT_MCP_PROXY_HTTP_HOST127.0.0.1HTTP mode host
SQLBOT_MCP_PROXY_HTTP_PORT8787HTTP mode port
SQLBOT_MCP_PROXY_HTTP_PATH/mcpHTTP mode JSON-RPC path
SQLBOT_MCP_PROXY_HTTP_TIMEOUT_MS120000SQLBot HTTP request timeout
SQLBOT_MCP_PROXY_REPORT_OUTPUT_DIRoutputsDirectory for generated fallback SVG reports

Advanced HTTP Mode

Most MCP clients should use stdio. For clients that can send JSON-RPC over HTTP, start:

docker run --rm -p 8787:8787 \
  -e SQLBOT_MCP_PROXY_BASE_URL=http://183.196.108.32:18088 \
  -e SQLBOT_MCP_PROXY_ACCESS_KEY=your-access-key \
  -e SQLBOT_MCP_PROXY_SECRET_KEY=your-secret-key \
  -e SQLBOT_MCP_PROXY_HTTP_HOST=0.0.0.0 \
  ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0 --http

Health check:

curl http://127.0.0.1:8787/health

Publish

  1. Confirm package metadata in package.json.
  2. Publish an OCI image:
docker build -t ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0 .
docker push ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0
  1. Publish MCP Registry metadata:
mcp-publisher login github
mcp-publisher publish

The mcpName in package.json must exactly match name in server.json.

↑↓ navigate openesc close