MCP Servers

ClickHouse/mcp-clickhouse

Connect ClickHouse to your AI assistants.

Our verdict

Not reviewed yet

We have not reviewed ClickHouse/mcp-clickhouse yet

No one at Enterprise DNA has checked this listing against its sources. The description comes from public listings gathered automatically. Any fact below shows where it came from and when it was last checked.

How we review records

From the listing

About ClickHouse/mcp-clickhouse

MCP server that connects ClickHouse databases to AI assistants via the Model Context Protocol. It exposes ClickHouse tables as resources and allows SQL queries through tools, enabling natural language interaction with ClickHouse data.

Best for

Developers who want to query ClickHouse data through AI assistants or build natural language interfaces on top of ClickHouse.

Use cases

Query ClickHouse databases from AI chat interfaces
Browse ClickHouse table schemas and sample data
Integrate ClickHouse analytics into AI agent workflows

Notes

793 stars on GitHub. Last updated 2026-05-27. Licensed Apache-2.0.

Pros

Simple setup with standard MCP configuration
Direct access to ClickHouse's columnar engine for fast queries
Active open-source project with 793 stars

Cons

Requires running a separate MCP server process
Limited to SQL queries, no built-in visualization or reporting
Depends on ClickHouse network accessibility from the server

Key facts

What we have checked

Not checked yet. Dated facts such as prices, releases and repository activity appear here once we have confirmed them from a source.

How to use

How to set it up

As the listing publishes it. We have not run this install.

Tools exposed

run_query
list_databases
list_tables
run_chdb_select_query

Clients the listing names (not checked here)

Claude Desktop, Continue

Example client config

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uv",
      "args": [
        "run",
        "--with",
        "mcp-clickhouse",
        "--python",
        "3.10",
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<clickhouse-host>",
        "CLICKHOUSE_PORT": "<clickhouse-port>",
        "CLICKHOUSE_USER": "<clickhouse-user>",
        "CLICKHOUSE_PASSWORD": "<clickhouse-password>",
        "CLICKHOUSE_ROLE": "<clickhouse-role>",
        "CLICKHOUSE_SECURE": "true",
        "CLICKHOUSE_VERIFY": "true",
        "CLICKHOUSE_CONNECT_TIMEOUT": "30",
        "CLICKHOUSE_SEND_RECEIVE_TIMEOUT": "30"
      }
    }
  }
}

Install

Add ClickHouse/mcp-clickhouse to your client

Not verified yet

Our lab has not run this server yet. "Config checked" on a client means the recipe matches that client's documented config format; it does not mean we ran it.

Claude Code

Config checked

Run in your terminal (runs on your computer)

claude mcp add --env CLICKHOUSE_HOST=YOUR_CLICKHOUSE_HOST --env CLICKHOUSE_USER=YOUR_CLICKHOUSE_USER --transport stdio clickhouse-mcp-clickhouse -- uvx mcp-clickhouse@0.7.0

Needs CLICKHOUSE_HOST and CLICKHOUSE_USER: replace each YOUR_ value with your own.

Version 0.7.0 · From the Official MCP registry, read 24 Oct 2026 · Format checked against Claude Code's config docs

Claude Desktop

Config checked

Add to claude_desktop_config.json (runs on your computer)

{
  "mcpServers": {
    "clickhouse-mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse@0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "YOUR_CLICKHOUSE_HOST",
        "CLICKHOUSE_USER": "YOUR_CLICKHOUSE_USER"
      }
    }
  }
}

Needs CLICKHOUSE_HOST and CLICKHOUSE_USER: replace each YOUR_ value with your own.

Version 0.7.0 · From the Official MCP registry, read 24 Oct 2026 · Format checked against Claude Desktop's config docs

Cursor

Config checked

Add to .cursor/mcp.json (runs on your computer)

{
  "mcpServers": {
    "clickhouse-mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse@0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "YOUR_CLICKHOUSE_HOST",
        "CLICKHOUSE_USER": "YOUR_CLICKHOUSE_USER"
      }
    }
  }
}

Needs CLICKHOUSE_HOST and CLICKHOUSE_USER: replace each YOUR_ value with your own.

Version 0.7.0 · From the Official MCP registry, read 24 Oct 2026 · Format checked against Cursor's config docs

VS Code

Config checked

Add to .vscode/mcp.json (runs on your computer)

{
  "inputs": [
    {
      "type": "promptString",
      "id": "clickhouse-host",
      "description": "Hostname of the ClickHouse server",
      "password": true
    },
    {
      "type": "promptString",
      "id": "clickhouse-user",
      "description": "Username for ClickHouse authentication",
      "password": true
    }
  ],
  "servers": {
    "clickhouse-mcp-clickhouse": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-clickhouse@0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "${input:clickhouse-host}",
        "CLICKHOUSE_USER": "${input:clickhouse-user}"
      }
    }
  }
}

Needs CLICKHOUSE_HOST and CLICKHOUSE_USER: replace each YOUR_ value with your own.

Version 0.7.0 · From the Official MCP registry, read 24 Oct 2026 · Format checked against VS Code's config docs

Codex

Config checked

Add to ~/.codex/config.toml (runs on your computer)

[mcp_servers.clickhouse-mcp-clickhouse]
command = "uvx"
args = ["mcp-clickhouse@0.7.0"]
env_vars = ["CLICKHOUSE_HOST", "CLICKHOUSE_USER"]

Needs CLICKHOUSE_HOST and CLICKHOUSE_USER: replace each YOUR_ value with your own.

Version 0.7.0 · From the Official MCP registry, read 24 Oct 2026 · Format checked against Codex's config docs

ChatGPT: ChatGPT connects only to remote servers that need no API key.

Recipes come from the server's entry in the official MCP registry. Check the package name before you run it, and keep keys out of shared files.

Works with

What ClickHouse/mcp-clickhouse connects to

5 clients, each with how we know and when we checked.

Works with	Type	How we know	Checked
Claude Code	Client	Install recipe matches the client's documented formatRuns locally, version 0.7.0Config checked	24 Oct 2026Claude Code docs
Claude Desktop	Client	Install recipe matches the client's documented formatRuns locally, version 0.7.0Config checked	24 Oct 2026Claude Desktop docs
Cursor	Client	Install recipe matches the client's documented formatRuns locally, version 0.7.0Config checked	24 Oct 2026Cursor docs
VS Code	Client	Install recipe matches the client's documented formatRuns locally, version 0.7.0Config checked	24 Oct 2026VS Code docs
Codex	Client	Install recipe matches the client's documented formatRuns locally, version 0.7.0Config checked	24 Oct 2026Codex docs

Alternatives

Alternatives to ClickHouse/mcp-clickhouse

Record	Type	How we know	Checked
bram2w/baserowThis is an alternative to it	MCP server	Named in the listing	Not dated
mindsdb/mindsdbThis is an alternative to it	MCP server	Named in the listing	Not dated

Compare

Compare ClickHouse/mcp-clickhouse side by side

Sources

Where this comes from

No sources recorded yet. Each source we check is listed here with the date we checked it.

A source shows what was published when we checked it. It does not certify security, performance or a working installation. Read our method.

Changelog

What changed

No changes recorded yet. Releases, price changes and deprecations appear here, with their dates, once we track them for this record.

Open-source & AI alternatives

Swap-in tools that solve the same job. Weigh the trade-offs before you commit.

Alternative to2 entries

MMCPlowCatalogue

bram2w/baserow

Various

Build databases, automations, apps & agents with AI — no code. Open source platform available on cloud and self-hosted. GDPR, HIPAA, SOC 2 compliant. Best Airtable alternative.

MMCPlowCatalogue

mindsdb/mindsdb

Various

Platform dedicated to building an open foundation for applied Artificial Intelligence, designed for people seeking production-ready AI systems they can truly control, extend and de

Free 27-page guide

Get the free Developer’s Field Guide

A 27-page field guide to the AI coding workflow with Claude. Claude Code, MCP servers, the prompt patterns that work, and what to delegate. Free.

Enter your work email. We send it straight over, plus a few short notes worth knowing. Unsubscribe any time.

← Back to MCP Servers Submit your own entry →