MCP servers · cloudcorprecords

analyticbase: read-only ClickHouse inspection over MCP and CLI

A read-only MCP server and CLI for listing databases and tables and running single SELECT queries against ClickHouse over its HTTP interface.

This text was machine-translated from the publisher's own information and has not been checked by a human editor. The publisher's original text is the reference.

This resource was imported automatically from the sources listed below and has not been reviewed by the AI Gate team yet. The description is the publisher's own, as published. Check the repository before installing.

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.0
    As shown on registry.modelcontextprotocol.io when we last read it
MCP servers
cloudflare

Cloudflare MCP servers

Cloudflare's hosted MCP servers for its products: documentation search, sandbox containers, browser rendering, Radar internet data, logs and analytics, Workers and more.

4.5K GitHub starsCloud & DevOpsSoftware development
Updated 17 Nov 2026
MCP servers
redis

Redis MCP Server

Redis's official MCP server that lets an AI assistant store, read and search data in a Redis database, including streams, JSON documents and vector indexes.

642 GitHub starsData & databasesSoftware development
Updated 17 Nov 2026
MCP servers
microsoft

Playwright MCP (browser automation)

Microsoft's MCP server that lets an AI assistant open web pages, click, type and read them through a real browser, using the page structure instead of screenshots.

39.6K GitHub starsTesting & QAWeb, search & browser
Updated 17 Nov 2026
MCP servers
hashicorp

Terraform MCP Server (HashiCorp)

HashiCorp's MCP server that gives an assistant current Terraform Registry information on providers, modules and policies, and can manage HCP Terraform workspaces.

1.6K GitHub starsCloud & DevOpsSoftware development
Updated 17 Nov 2026