{ "markdown": "# 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\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 = \"\"\nSQLBOT_MCP_PROXY_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\n\nMy SQLBot secret key:\n\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", "bytes": 4707, "sha": "96498a0d2f2dd2b7b3dab47c9c683f12f84d3eb6ef2de694ff7190a58ae65a39", "repo_slug": "wenrou21/sqlbot-mcp-proxy", "fonte": "repo", "truncated": false, "api": "https://agentalog.com/api/listings/mcp_io_github_wenrou21_sqlbot_mcp_proxy_d1c1cad1/readme" }