MCP server

ClickHouse

Query ClickHouse clusters and chDB from AI assistants

.mdConnect

Official ClickHouse MCP server for running SQL queries and listing databases and tables on a ClickHouse cluster, read-only by default. Optionally exposes chDB for querying local files and URLs with the embedded ClickHouse engine.

Also available as

ClickHouseExplore ClickHouse Cloudapp · by ClickHouse Inc

Connect

  1. 1Add the server to Codex
    codex mcp add clickhouse --env CLICKHOUSE_HOST=YOUR_CLICKHOUSE_HOST --env CLICKHOUSE_PORT=YOUR_CLICKHOUSE_PORT --env CLICKHOUSE_USER=YOUR_CLICKHOUSE_USER --env CLICKHOUSE_PASSWORD=YOUR_CLICKHOUSE_PASSWORD --env CLICKHOUSE_SECURE=YOUR_CLICKHOUSE_SECURE -- uv run --with mcp-clickhouse --python 3.12 mcp-clickhouse

Configs are generated from the publisher's documented endpoint. Check their docs for plan requirements and scopes. New to this? Read the step-by-step tutorial.

Tools 4

run_querylist_databaseslist_tablesrun_chdb_select_query

Things to ask

  • “List the databases on my ClickHouse cluster”
  • “What are the top 10 events by count yesterday?”
  • “Describe the tables in the analytics database”

Related

SupabaseManage Supabase databases, migrations, edge functions and logsMCP server · by Supabase · 2.9k stars · RemoteGraphiti MCPTemporal knowledge graph memory for agents, by ZepMCP server · by Zep · 31k starsMCP Toolbox for DatabasesGoogle's open-source MCP server for 20+ databasesMCP server · by Google · 17k starsPostHogQuery product analytics, feature flags, experiments and errors in PostHogMCP server · by PostHog · RemoteApifyRun thousands of Apify Actors for scraping and automation from your agentMCP server · by Apify · 9.2k stars · RemoteFirecrawlScrape, search, crawl and interact with live web pages for LLMsMCP server · by Firecrawl · 7.5k stars · Remote