{"id":"37330776-a0d2-4eda-aaad-03c440ab8688","slug":"sqlbot-mcp-proxy","kind":"mcp","name":"sqlbot-mcp-proxy","summary":"MCP server proxy for SQLBot natural-language data querying and report generation.","owner":"wenRou21","repoUrl":"https://github.com/wenRou21/sqlbot-mcp-proxy","license":"MIT","licenseTier":"permissive","trust":"community","stars":0,"match":null,"fewStars":true,"format":"mcp","createdAt":"2026-06-29T12:33:53.000Z","addedAt":"2026-10-14T06:09:02.736Z","logoUrl":"https://avatars.githubusercontent.com/u/157787123?v=4","linkOnly":false,"collection":null,"skillPath":null,"categories":["cloud-infra","data-analytics"],"tags":[],"runtime":"docker","local":true,"cloudCapable":false,"cloudCapability":"unknown","cloudReadyOnPlatform":false,"needsApiKey":false,"reviewed":false,"syncedAt":"2026-10-17T19:28:54.733Z","sample":false,"url":"https://conduits.dev/tools/sqlbot-mcp-proxy","language":"JavaScript","transports":["stdio"],"install":{"docker":"ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0"},"requirements":{"env":[{"name":"SQLBOT_MCP_PROXY_BASE_URL","secret":false,"required":false,"description":"Base URL of the SQLBot service, for example http://127.0.0.1:8000."},{"name":"SQLBOT_MCP_PROXY_ACCESS_KEY","secret":true,"required":false,"description":"SQLBot API access key. If omitted, the proxy can try FEISHU_ASK_ACCESS_KEY or read from the configured Docker container."},{"name":"SQLBOT_MCP_PROXY_SECRET_KEY","secret":true,"required":false,"description":"SQLBot API secret key. If omitted, the proxy can try FEISHU_ASK_SECRET_KEY or read from the configured Docker container."},{"name":"SQLBOT_MCP_PROXY_DOCKER_CONTAINER","secret":false,"required":false,"description":"Optional Docker container name used when reading FEISHU_ASK_ACCESS_KEY and FEISHU_ASK_SECRET_KEY from a running SQLBot container."}],"upstreamMayCharge":false},"tools":null,"readme":"# SQLBot MCP Proxy\n\nMCP 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.\n\n<!-- mcp-name: io.github.wenRou21/sqlbot-mcp-proxy -->\n\n## Requirements\n\n- Docker\n- A running SQLBot service\n- SQLBot API keys\n\n## Recommended Codex Config\n\nUsers do not need to download this repository manually. Add this single MCP server to Codex config and replace the SQLBot URL and keys:\n\n```toml\n[mcp_servers.sqlbot]\ncommand = \"docker\"\nargs = [\n  \"run\",\n  \"--rm\",\n  \"-i\",\n  \"-e\",\n  \"SQLBOT_MCP_PROXY_BASE_URL\",\n  \"-e\",\n  \"SQLBOT_MCP_PROXY_ACCESS_KEY\",\n  \"-e\",\n  \"SQLBOT_MCP_PROXY_SECRET_KEY\",\n  \"ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0\"\n]\nenabled = true\nstartup_timeout_sec = 120\n\n[mcp_servers.sqlbot.env]\nSQLBOT_MCP_PROXY_BASE_URL = \"http://183.196.108.32:18088\"\nSQLBOT_MCP_PROXY_ACCESS_KEY = \"<YOUR_SQLBOT_ACCESS_KEY>\"\nSQLBOT_MCP_PROXY_SECRET_KEY = \"<YOUR_SQLBOT_SECRET_KEY>\"\n```\n\nThen restart Codex completely.\n\nIf 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`.\n\n## Prompt Template\n\n```text\nPlease configure SQLBot MCP for Codex.\n\nMCP image:\nghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0\n\nMy SQLBot URL:\nhttp://183.196.108.32:18088\n\nMy SQLBot access key:\n<YOUR_SQLBOT_ACCESS_KEY>\n\nMy SQLBot secret key:\n<YOUR_SQLBOT_SECRET_KEY>\n\nAdd this MCP to Codex config:\n- MCP name: sqlbot\n- command: docker\n- 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\"]\n- startup_timeout_sec: 120\n- SQLBOT_MCP_PROXY_BASE_URL: use the SQLBot URL above\n- SQLBOT_MCP_PROXY_ACCESS_KEY: use the access key above\n- SQLBOT_MCP_PROXY_SECRET_KEY: use the secret key above\n\nAfter configuration, remind me to fully restart Codex.\n\nAfter restart:\n- Check available datasources with sqlbot_list_datasources.\n- Use sqlbot_list_tables and sqlbot_describe_table before asking data questions.\n- Use sqlbot_ask_data for Text-to-SQL questions.\n- Use sqlbot_generate_report when I ask for an analysis report or chart.\n```\n\n## Quick Docker Test\n\nYou can test the image outside Codex:\n\n```bash\ndocker run --rm -i \\\n  -e SQLBOT_MCP_PROXY_BASE_URL=http://183.196.108.32:18088 \\\n  -e SQLBOT_MCP_PROXY_ACCESS_KEY=your-access-key \\\n  -e SQLBOT_MCP_PROXY_SECRET_KEY=your-secret-key \\\n  ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0\n```\n\n## Tools\n\n- `sqlbot_list_datasources`: list SQLBot datasources visible to the configured API key\n- `sqlbot_list_tables`: list checked SQLBot metadata tables for a datasource\n- `sqlbot_describe_table`: describe checked fields for a SQLBot metadata table\n- `sqlbot_ask_data`: ask SQLBot a natural-language data question\n- `sqlbot_generate_report`: generate an analysis report and chart, with a local SVG fallback\n\n## Environment Variables\n\n| Name | Default | Description |\n| --- | --- | --- |\n| `SQLBOT_MCP_PROXY_BASE_URL` | `http://183.196.108.32:18088` | SQLBot service base URL |\n| `SQLBOT_MCP_PROXY_ACCESS_KEY` | empty | SQLBot API access key |\n| `SQLBOT_MCP_PROXY_SECRET_KEY` | empty | SQLBot API secret key |\n| `FEISHU_ASK_ACCESS_KEY` | empty | Fallback access key name |\n| `FEISHU_ASK_SECRET_KEY` | empty | Fallback secret key name |\n| `SQLBOT_MCP_PROXY_DOCKER_CONTAINER` | `sqlbot` | Container used for fallback key lookup |\n| `SQLBOT_MCP_PROXY_HTTP_HOST` | `127.0.0.1` | HTTP mode host |\n| `SQLBOT_MCP_PROXY_HTTP_PORT` | `8787` | HTTP mode port |\n| `SQLBOT_MCP_PROXY_HTTP_PATH` | `/mcp` | HTTP mode JSON-RPC path |\n| `SQLBOT_MCP_PROXY_HTTP_TIMEOUT_MS` | `120000` | SQLBot HTTP request timeout |\n| `SQLBOT_MCP_PROXY_REPORT_OUTPUT_DIR` | `outputs` | Directory for generated fallback SVG reports |\n\n## Advanced HTTP Mode\n\nMost MCP clients should use stdio. For clients that can send JSON-RPC over HTTP, start:\n\n```bash\ndocker run --rm -p 8787:8787 \\\n  -e SQLBOT_MCP_PROXY_BASE_URL=http://183.196.108.32:18088 \\\n  -e SQLBOT_MCP_PROXY_ACCESS_KEY=your-access-key \\\n  -e SQLBOT_MCP_PROXY_SECRET_KEY=your-secret-key \\\n  -e SQLBOT_MCP_PROXY_HTTP_HOST=0.0.0.0 \\\n  ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0 --http\n```\n\nHealth check:\n\n```bash\ncurl http://127.0.0.1:8787/health\n```\n\n## Publish\n\n1. Confirm package metadata in `package.json`.\n2. Publish an OCI image:\n\n```bash\ndocker build -t ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0 .\ndocker push ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0\n```\n\n3. Publish MCP Registry metadata:\n\n```bash\nmcp-publisher login github\nmcp-publisher publish\n```\n\nThe `mcpName` in `package.json` must exactly match `name` in `server.json`.\n"}