MCP servers · clickhouse

ClickHouse MCP Server for querying clusters

An MCP server for running SQL queries and exploring databases and tables on ClickHouse clusters and chDB.

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

The server exposes ClickHouse to MCP-compatible clients through three tools. run_query executes SQL on a cluster and accepts optional named parameters for ClickHouse {name:Type} placeholders. list_databases lists the databases on a cluster, and list_tables lists tables in a database with pagination, LIKE filters and optional column metadata. Tool responses are JSON-encoded, and integers outside JavaScript's safe range are returned as strings so values stay exact.

A client would reach for it to explore an unfamiliar cluster, draft analytical SQL, or check a query before running it. run_query also accepts DESCRIBE to see a query's output columns and types, and EXPLAIN ESTIMATE to see the parts, rows and marks a SELECT would read, which helps before running an expensive query. Parameterised queries keep values separate from the SQL text.

To run it, point the server at a ClickHouse cluster. Queries run in read-only mode by default, and writes must be enabled explicitly through the CLICKHOUSE_ALLOW_WRITE_ACCESS setting. The server implements MCP protocol version 2026-07-28 and also accepts legacy handshakes from 2024-11-05 through 2025-11-25. Modern clients should send the MCP-Protocol-Version header on every POST request.

Limitations and requirements

Queries are read-only unless CLICKHOUSE_ALLOW_WRITE_ACCESS is set to enable writes. Existing ClickHouse permissions still apply to every query and to reading AGENTS.ROOT. Parameter values stay in MCP tool arguments and can appear in backend errors. ClickHouse 26.3.20.7 substitutes them into query text in system.query_log, system.processes and system.text_log, and parameter binding is not a privacy feature. Null values inside arrays depend on the driver: they work with clickhouse-connect 1.8.0 but fail with the supported minimum 1.0.0. JSON lists and objects cannot bind to Tuple or Map types. With non-empty params, queries containing many unterminated {name: placeholder starts are rejected, including such text in comments or string literals. Python-style %s formatting and $name$ raw binary parameters are not supported.

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
    ClickHouse

    Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.

    v0.7.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