SQLBot MCP Proxy

Registre officiel Données et bases de données

MCP server proxy for SQLBot Text-to-SQL queries and report generation.

Que pouvez-vous faire avec SQLBot MCP Proxy ?

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

Installation

Ajoutez ceci à la configuration MCP de votre client (Claude Desktop : claude_desktop_config.json ; Cursor : .cursor/mcp.json ; VS Code et les autres utilisent la même forme « mcpServers »).

OCI package ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0

Claude Code

claude mcp add sqlbot-mcp-proxy -e 'SQLBOT_MCP_PROXY_BASE_URL=<SQLBOT_MCP_PROXY_BASE_URL>' -e 'SQLBOT_MCP_PROXY_ACCESS_KEY=<your sqlbot_mcp_proxy_access_key>' -e 'SQLBOT_MCP_PROXY_SECRET_KEY=<your sqlbot_mcp_proxy_secret_key>' -e 'SQLBOT_MCP_PROXY_DOCKER_CONTAINER=<SQLBOT_MCP_PROXY_DOCKER_CONTAINER>' -- docker run -i --rm ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0

Configuration JSON (Claude Desktop, Cursor, VS Code)

{
    "mcpServers": {
        "sqlbot-mcp-proxy": {
            "command": "docker",
            "args": [
                "run",
                "-i",
                "--rm",
                "ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0"
            ],
            "env": {
                "SQLBOT_MCP_PROXY_BASE_URL": "<SQLBOT_MCP_PROXY_BASE_URL>",
                "SQLBOT_MCP_PROXY_ACCESS_KEY": "<your sqlbot_mcp_proxy_access_key>",
                "SQLBOT_MCP_PROXY_SECRET_KEY": "<your sqlbot_mcp_proxy_secret_key>",
                "SQLBOT_MCP_PROXY_DOCKER_CONTAINER": "<SQLBOT_MCP_PROXY_DOCKER_CONTAINER>"
            }
        }
    }
}

Variables d'environnement

SQLBOT_MCP_PROXY_BASE_URL Base URL of the SQLBot service, for example http://127.0.0.1:8000.
SQLBOT_MCP_PROXY_ACCESS_KEY secret SQLBot API access key. If omitted, the proxy can try FEISHU_ASK_ACCESS_KEY or read from the configured Docker container.
SQLBOT_MCP_PROXY_SECRET_KEY secret SQLBot API secret key. If omitted, the proxy can try FEISHU_ASK_SECRET_KEY or read from the configured Docker container.
SQLBOT_MCP_PROXY_DOCKER_CONTAINER Optional Docker container name used when reading FEISHU_ASK_ACCESS_KEY and FEISHU_ASK_SECRET_KEY from a running SQLBot container.

Documentation

Tirée du README du projet sur GitHub, actualisée chaque semaine. Les liens ouvrent GitHub.

Sommaire

SQLBot MCP Proxy
Requirements
Recommended Codex Config
Prompt Template
Quick Docker Test
Tools
Environment Variables
Advanced HTTP Mode
Publish

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

Name	Default	Description
`SQLBOT_MCP_PROXY_BASE_URL`	`http://183.196.108.32:18088`	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 \
  -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

Confirm package metadata in package.json.
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

Publish MCP Registry metadata:

mcp-publisher login github
mcp-publisher publish

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

Questions fréquentes

Qu'est-ce que SQLBot MCP Proxy ?

MCP server proxy for SQLBot Text-to-SQL queries and report generation.

Comment installer SQLBot MCP Proxy ?

Il s'exécute sur votre machine. Dans Claude Code : claude mcp add sqlbot-mcp-proxy -e 'SQLBOT_MCP_PROXY_BASE_URL=<SQLBOT_MCP_PROXY_BASE_URL>' -e 'SQLBOT_MCP_PROXY_ACCESS_KEY=<your sqlbot_mcp_proxy_access_key>' -e 'SQLBOT_MCP_PROXY_SECRET_KEY=<your sqlbot_mcp_proxy_secret_key>' -e 'SQLBOT_MCP_PROXY_DOCKER_CONTAINER=<SQLBOT_MCP_PROXY_DOCKER_CONTAINER>' -- docker run -i --rm ghcr.io/wenrou21/sqlbot-mcp-proxy:0.1.0. Pour les autres clients, collez la configuration JSON de cette page dans leurs réglages MCP.

Faut-il une clé API pour SQLBot MCP Proxy ?

Oui. Il attend SQLBOT_MCP_PROXY_ACCESS_KEY, SQLBOT_MCP_PROXY_SECRET_KEY, à renseigner dans sa configuration.

SQLBot MCP Proxy est-il open source ?

Oui. Son code est sur GitHub sous licence MIT.

Qui maintient SQLBot MCP Proxy ?

Il est publié par wenRou21. AI.tn le référence sans le maintenir ni le recommander.

Issu du registre MCP officiel. Être listé n'est pas une recommandation : vérifiez le code et les permissions d'un serveur avant de lui donner accès à vos données.

Détails du serveur

Référencé dans: Registre MCP officiel
Éditeur: wenRou21
Catégorie: Données et bases de données
Exécution: Local
Étoiles GitHub: ★ 0
Licence: MIT
Langage: JavaScript
Dernier commit: 30 juin 2026
Tickets ouverts: 0
Version: 0.1.0
Publié le: 29 juin 2026

io.github.wenRou21/sqlbot-mcp-proxy

Serveurs similaires

RowAttest Runs an eight-stage isolation test against your staging Supabase and issues a signed at...
codeDB Lens Read-only health checks and data questions for SQL Server and PostgreSQL, with your sav...
FastrMemory Local-first cognitive agent memory with bi-temporal SQLite, replayable history, hybrid ...
Sezzlee Excel Read spreadsheets; build immutable reports with bulk preparation, calculation, charts a...
TeamOnly Deploy AI-built internal apps behind your company login, with a database, files and sec...
WaveHouse Cloud Browse, query, and administer your managed WaveHouse + ClickHouse projects (schema, pip...
Open data: clinical trials, EU tenders, companies, fuel prices Official open data as JSON: clinical trials, EU tenders, papers, apps, French firms, fu...
frugal-memory Memory for AI assistants in one SQLite file: full-text search, no vectors, no embeddings.

Données et bases de données