What it does
analyticbase lets an agent, or a person at a terminal, inspect a ClickHouse server and ask it questions without changing its data. It lists the databases on a server, lists the tables in one database with each table's engine, comment, row count and column count, and runs single read-only SELECT queries. It talks to ClickHouse over the plain HTTP interface, so it bundles no client library and needs no native port tunnel.
It suits exploring an unfamiliar ClickHouse schema or querying data from an MCP-capable agent. The tools are list_databases, list_tables (with optional like and not_like filters) and run_select_query, which returns rows as a JSON array. Before a query runs, a guard checks that the first keyword is SELECT or WITH, that it is a single statement, and that no write or DDL keyword such as INSERT, DROP or GRANT appears outside a string literal. The guard is strict, so a column named update is refused. If ClickHouse is unreachable, the MCP server still starts and lists its tools, and failures are returned as errors, not as invented rows.
Configuration uses environment variables: CLICKHOUSE_URL, or CLICKHOUSE_HOST and CLICKHOUSE_PORT (default 8123), plus CLICKHOUSE_USER (default default) and CLICKHOUSE_PASSWORD. The mcp subcommand runs a stdio MCP server, and the same binary works as a CLI with exit codes 0, 1 and 2. A container image is also available and starts the MCP server by default.
Limitations and requirements
Requires a reachable ClickHouse server with its HTTP interface enabled, and credentials supplied through environment variables. Only one SELECT or WITH statement is accepted per query, and the keyword guard refuses some ordinary identifiers, such as a column named update.
Safety
Our team has not reviewed this resource. Only automated rules checked it; resources with high-risk signals are not published. These are signals, not a guarantee that installing it is safe. Try it in a sandbox project first.
- Runs code or changes an assistant's behaviour
Sources
- Official MCP Registry first seen 13 Nov 2026 · last seen 13 Nov 2026 · its page on the source
io.github.CloudCorpRecords/analyticbase
Query ClickHouse over HTTP: list databases and tables, run SELECT.
v0.1.0As shown on registry.modelcontextprotocol.io when we last read it