Skip to main content
Glama
wenRou21

io.github.wenRou21/sqlbot-mcp-proxy

by wenRou21
OverviewSchemaRelated ServersScoreDiscussions
JavaScript
Remote

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

Related MCP server: TalkDB

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",
  "--add-host",
  "host.docker.internal:host-gateway",
  "-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://host.docker.internal:8000"
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 a 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:8000.

Prompt Template

Please configure SQLBot MCP for Codex.

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

My SQLBot URL:
http://host.docker.internal:8000

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", "--add-host", "host.docker.internal:host-gateway", "-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 \
  --add-host host.docker.internal:host-gateway \
  -e SQLBOT_MCP_PROXY_BASE_URL=http://host.docker.internal:8000 \
  -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

Name

Default

Description

SQLBOT_MCP_PROXY_BASE_URL

http://127.0.0.1:8000

SQLBot service base URL

SQLBOT_MCP_PROXY_ACCESS_KEY

empty

SQLBot API access key

SQLBOT_MCP_PROXY_SECRET_KEY

empty

SQLBot API secret key

FEISHU_ASK_ACCESS_KEY

empty

Fallback access key name

FEISHU_ASK_SECRET_KEY

empty

Fallback secret key name

SQLBOT_MCP_PROXY_DOCKER_CONTAINER

sqlbot

Container used for fallback key lookup

SQLBOT_MCP_PROXY_HTTP_HOST

127.0.0.1

HTTP mode host

SQLBOT_MCP_PROXY_HTTP_PORT

8787

HTTP mode port

SQLBOT_MCP_PROXY_HTTP_PATH

/mcp

HTTP mode JSON-RPC path

SQLBOT_MCP_PROXY_HTTP_TIMEOUT_MS

120000

SQLBot HTTP request timeout

SQLBOT_MCP_PROXY_REPORT_OUTPUT_DIR

outputs

Directory 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 \
  --add-host host.docker.internal:host-gateway \
  -e SQLBOT_MCP_PROXY_BASE_URL=http://host.docker.internal:8000 \
  -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.

This server cannot be installed

A
license - permissive license
-
quality - not tested
C
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/wenRou21/sqlbot-mcp-proxy'

If you have feedback or need assistance with the MCP directory API, please join our Discord server