Skip to content
Agentmart
Submit a tool

ClickHouse

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

Connector by ClickHouseOfficial · GitHub account verified by the MCP Registry

IndexedApache-2.0Local (stdio)★ 892
Write a review

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/clickhouse-mcp-clickhouse

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

We use your email only for this newsletter. Privacy

About

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

Use cases: database-access, data-analysis

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list and install config. Checked Oct 25, 2026.

Tools
5 read · 0 write · 0 delete · 4 not yet classified
Secrets
2 (API keys, tokens or passwords)
Install scripts
None found
Runs as
Python package

Tools by what they do 9

Read from the source code; the running server may list different tools.

Read 5 · Look things up without changing anything.

  • list_databases
  • list_databases_async
  • list_tables
  • list_tables_async
  • run_query

Not yet classified 4 · We could not tell from the name and description.

  • chdb_initial_prompt
  • run_chdb_select_query
  • run_chdb_select_query_async
  • run_query_async

Secrets and settings it asks for

Secrets: values you paste in that let it act as you.

  • CLICKHOUSE_CLIENT_CERT_KEY
  • CLICKHOUSE_PASSWORD

Other settings (environment variables or headers).

  • CLICKHOUSE_ALLOW_DROP
  • CLICKHOUSE_ALLOW_WRITE_ACCESS
  • CLICKHOUSE_CA_CERT
  • CLICKHOUSE_CLIENT_CERT
  • CLICKHOUSE_DATABASE
  • CLICKHOUSE_HOST
  • CLICKHOUSE_MCP_MAX_WORKERS
  • CLICKHOUSE_MCP_QUERY_TIMEOUT
  • CLICKHOUSE_PORT
  • CLICKHOUSE_ROLE
  • CLICKHOUSE_SECURE
  • CLICKHOUSE_TLS_MODE
Show 2 more settings
  • CLICKHOUSE_USER
  • CLICKHOUSE_VERIFY

Tools (9)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

  • chdb_initial_prompt

    This prompt helps users understand how to interact and perform common operations in chDB

  • list_databases
  • list_databases_async
  • list_tables
  • list_tables_async
  • run_chdb_select_query

    Run SQL in chDB, an in-process ClickHouse engine. Integers outside [-9007199254740991, 9007199254740991] are returned as decimal strings.

  • run_chdb_select_query_async

    Async MCP-facing wrapper for chDB queries.

  • run_query

    Execute SQL queries in ClickHouse. Queries run in read-only mode by default. Bind optional params by name with {name:Type} placeholders, such as {name:String} or {vector:Array(Float32)}. Values may be JSON scalars, nulls, or arrays. Pass exact large integers as decimal strings. JSON lists and objects cannot bind to Tuple and Map types. Python percent formatting and $name$ raw binary parameters are not supported. Parameter values stay out of the MCP server's normal SQL log lines, but may appear in errors and backend logs. Set CLICKHOUSE_ALLOW_WRITE_ACCESS=true to allow DDL and DML operations. S…

  • run_query_async

    Async MCP-facing wrapper for ClickHouse queries. Awaits the worker-pool future asynchronously so concurrent tool calls are served while a slow query is in flight. Bind params by name with {name:Type} placeholders. Values may be JSON scalars, nulls, or arrays. JSON lists and objects cannot bind to Tuple and Map types. Python percent formatting and $name$ raw binary parameters are not supported.

Compare and alternatives

Signals

Stars
892
Forks
210
Open issues
4
Weekly downloads
71,407
Last commit
Oct 21, 2026 (7 days ago)
Last release
Sep 21, 2026 (1 month ago)
Last package publish
Sep 21, 2026 (1 month ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name
io.github.ClickHouse/mcp-clickhouse
Version
0.7.0
Auth
API key
Packages
pypi mcp-clickhouseoci ghcr.io/clickhouse/mcp-clickhouse:0.7.0
License
Apache-2.0
Repository
github.com/ClickHouse/mcp-clickhouse
Website
clickhouse.com
First seen
Oct 24, 2026
Last checked
Oct 25, 2026
Source
Official MCP Registrygithub-graphql

Same server elsewhere

Copies of this server published by others; search shows only one of them.

More from ClickHouse

Cite this page

ClickHouse MCP server. Agent Mart. https://agentmart.dev/connectors/clickhouse-mcp-clickhouse (last updated 2026-10-25)