Databases - official ClickHouse server
ClickHouse MCP server
Open-source MCP server from ClickHouse that lets AI assistants list databases and tables and run SQL against any ClickHouse instance, self-hosted or Cloud. It also has an optional chDB embedded engine. It runs locally over stdio by default, and can also serve Streamable HTTP. It runs locally from mcp-clickhouse (pypi); the notes below cover how it authenticates.
Last verified 4 tools7 sources
Install
Claude Code
About Claude Codeclaude mcp add \
--transport stdio \
--env CLICKHOUSE_HOST=your-clickhouse-host \
--env CLICKHOUSE_USER=your-clickhouse-user \
--env CLICKHOUSE_PASSWORD=your-clickhouse-password \
--scope user \
mcp-clickhouse -- \
uv run --with mcp-clickhouse --python 3.10 mcp-clickhouseCodex
About Codexcodex mcp add mcp-clickhouse \
--env CLICKHOUSE_HOST=your-clickhouse-host \
--env CLICKHOUSE_USER=your-clickhouse-user \
--env CLICKHOUSE_PASSWORD=your-clickhouse-password \
-- uv run --with mcp-clickhouse --python 3.10 mcp-clickhouseCursor
About Cursor{
"mcpServers": {
"mcp-clickhouse": {
"command": "uv",
"args": [
"run",
"--with",
"mcp-clickhouse",
"--python",
"3.10",
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "your-clickhouse-host",
"CLICKHOUSE_USER": "your-clickhouse-user",
"CLICKHOUSE_PASSWORD": "your-clickhouse-password"
}
}
}
}Generic
{
"mcpServers": {
"mcp-clickhouse": {
"command": "uv",
"args": [
"run",
"--with",
"mcp-clickhouse",
"--python",
"3.10",
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "your-clickhouse-host",
"CLICKHOUSE_USER": "your-clickhouse-user",
"CLICKHOUSE_PASSWORD": "your-clickhouse-password"
}
}
}
}Tools
run_query- Execute SQL on the ClickHouse cluster; read-only by default, with optional named query parameters.
list_databases- List all databases on the ClickHouse cluster.
list_tables- List tables in a database with pagination, LIKE filters and optional column metadata.
run_chdb_select_query- Execute SQL using chDB's embedded ClickHouse engine (requires the optional chdb extra).
As documented on October 17, 2026. A running server reports its current list through tools/list.
Notes and caveats
- Latest release v0.7.0 (2026-09-21).
- Version numbers are pre-1.0, and the docs give no ga/beta label.
- Connects with ClickHouse credentials in environment variables.
- HTTP/SSE transports require auth by default: a static bearer token (CLICKHOUSE_MCP_AUTH_TOKEN), OAuth/OIDC via FastMCP, or auth explicitly disabled for local development.
- The standalone SSE transport is deprecated in favor of Streamable HTTP.
- Writes are off by default (CLICKHOUSE_ALLOW_WRITE_ACCESS=false).
- The generic snippet is the Claude Desktop config from the docs.
- ClickHouse's Cloud docs list the open-source tools as run_select_query, list_databases and list_tables, but the current README names the query tool run_query.
More MCP servers for databases
- ClickHouseStatus: Beta
ClickHouse Cloud remote MCP server
A fully managed remote MCP endpoint for ClickHouse Cloud services that lets agents list databases and tables, run read-only SELECT queries, and inspect organizations, services, backups, ClickPipes and billing. All 13 tools are read-only.
Transport: Streamable HTTPAuth: OAuth or API key - AirtableStatus: GA
Airtable MCP server
Airtable's official hosted MCP server lets AI tools list and create bases, change table and field schema, read and write records, build interfaces, submit forms and draft automations, all within the user's existing permissions.
Transport: Streamable HTTPAuth: OAuth or API key - Chroma
Chroma MCP server
Self-hosted MCP server that lets agents create and manage Chroma collections and add, query, update and delete documents. It supports vector search, full-text search and metadata filtering against ephemeral, persistent, self-hosted HTTP or Chroma Cloud clients.
Transport: stdioAuth: Other - CockroachDBStatus: GA
CockroachDB Cloud MCP server
Managed MCP server built into CockroachDB Cloud that lets AI tools list clusters, explore live schemas and run SQL against clusters in a CockroachDB Cloud organization. Connections can cover every cluster the user or service account can access, or be scoped to one cluster with an mcp-cluster-id header.
Transport: Streamable HTTPAuth: OAuth or API key - Convex
Convex MCP server
Local MCP server built into the Convex CLI that lets agents inspect and act on a Convex deployment: list tables and schemas, page through data, run read-only one-off queries, call deployed functions, read logs and health insights, and manage environment variables.
Transport: stdioAuth: Other - CouchbaseStatus: GA
Couchbase MCP server
Self-hosted MCP server that connects AI agents to Couchbase clusters on Capella or self-managed, with tools for cluster health, schema discovery, key-value operations, SQL++ queries, indexing, full-text and vector search, and query performance analysis.
Transport: stdio, Streamable HTTP, SSEAuth: Other
Related reading
- What's New in Mastra (Late 2026): Harness, AgentController GA, Eval Gates and MCP 2.xMastra in late 2026: goals, schedules, signals, AgentController GA, eval gates and MCP 2.x, with type-checked TypeScript examples and honest tradeoffs.
- MCP vs A2A vs Function Calling: Which Layer Does What in 2026MCP vs A2A vs function calling compared on the 2026-07-28 MCP spec and A2A 1.0: what each protocol does, where they overlap, and how to stack them.
- Pydantic AI V2 in Late 2026: Capabilities, Graphs, Evals and MCPPydantic AI V2 explained through v2.57.0: capabilities, typed output, Conversation storage, caching, graphs, evals, MCP Apps and Logfire, with checked code.
- Reverse Engineer Anything (REA): What the MCP Server Does and Where the Line IsREA (Reverse Engineer Anything) is an MIT-licensed MCP server that lets Claude Code, Codex or Cursor inspect binaries, Electron apps and APKs. How to try it.
- Claude Opus 5.5 Built a Browser 3D World: The Higgsfield MCP WorkflowClaude Opus 5.5 and Higgsfield MCP built an interactive 3D Library of Alexandria in the browser. The verified connector setup and where the workflow holds up.
- Pi 1.0 Release Guide: MCP, Codemode and Pi DurablePi 1.0 adds built-in MCP through Codemode, a fullscreen TUI by default and Pi Durable. What changed, how to install it, and what breaks on upgrade.
FAQ
What does the ClickHouse MCP server do?
Open-source MCP server from ClickHouse that lets AI assistants list databases and tables and run SQL against any ClickHouse instance, self-hosted or Cloud. It also has an optional chDB embedded engine. It runs locally over stdio by default, and can also serve Streamable HTTP. The vendor documents 4 tools, including run_query, list_databases, list_tables and run_chdb_select_query.
How do I add the ClickHouse MCP server to Claude Code?
ClickHouse documents a Claude Code config; copy it from the Claude Code section of this page. Snippets for Codex, Cursor and Generic are there too.
Does the ClickHouse MCP server need authentication?
It uses a scheme other than OAuth or an API key, such as the session of the app or instance it runs in; the notes on this page describe it. Transport: stdio, Streamable HTTP, SSE. Status: Unlabelled, last checked October 17, 2026.
Sources
Last verified against 7 ClickHouse pages, then re-checked independently.
- github.comhttps://github.com/ClickHouse/mcp-clickhouse
- raw.githubusercontent.comhttps://raw.githubusercontent.com/ClickHouse/mcp-clickhouse/HEAD/README.md
- raw.githubusercontent.comhttps://raw.githubusercontent.com/ClickHouse/mcp-clickhouse/HEAD/LICENSE
- github.comhttps://github.com/ClickHouse/mcp-clickhouse/releases
- clickhouse.comhttps://clickhouse.com/docs/guides/use-cases/ai-ml/MCP/claude-desktop.md
- clickhouse.comhttps://clickhouse.com/docs/concepts/features/interfaces/mcp.md
- clickhouse.comhttps://clickhouse.com/docs/use-cases/AI/MCP
Newsletter
New MCP servers, the week they ship
One email per week. New official MCP servers, the coding tools that support them and how developers wire them up.