Official ClickHouse

Official ClickHouse MCP Server

Official ClickHouse MCP Server.

MCP Info

Attribute	Details
Docker Image	mcp/clickhouse
Author	ClickHouse
Repository	https://github.com/ClickHouse/mcp-clickhouse

Image Building Info

Attribute	Details
Dockerfile	https://github.com/ClickHouse/mcp-clickhouse/blob/21e6cb2b0758150e8fd0627b699fbfd78e31837b/Dockerfile
Commit	`21e6cb2b0758150e8fd0627b699fbfd78e31837b`
Docker Image built by	Docker Inc.
Docker Scout Health Score	Docker Scout Health Score
Verify Signature	`COSIGN_REPOSITORY=mcp/signatures cosign verify mcp/clickhouse --key https://raw.githubusercontent.com/docker/keyring/refs/heads/main/public/mcp/latest.pub`
Licence	Apache License 2.0

Available Tools (3)

Tools provided by this Server	Short Description
`list_databases`	List available ClickHouse databases
`list_tables`	List available ClickHouse tables in a database, including schema, comment, row count, and column count.
`run_select_query`	Run a SELECT query in a ClickHouse database

Tools Details

Tool: `list_databases`

List available ClickHouse databases

Tool: `list_tables`

List available ClickHouse tables in a database, including schema, comment, row count, and column count.

Parameters	Type	Description
`database`	`string`
`like`	`string` optional
`not_like`	`string` optional

Tool: `run_select_query`

Run a SELECT query in a ClickHouse database

Parameters	Type	Description
`query`	`string`

Use this MCP Server

{
  "mcpServers": {
    "clickhouse": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "CLICKHOUSE_HOST",
        "-e",
        "CLICKHOUSE_PORT",
        "-e",
        "CLICKHOUSE_USER",
        "-e",
        "CLICKHOUSE_SECURE",
        "-e",
        "CLICKHOUSE_VERIFY",
        "-e",
        "CLICKHOUSE_CONNECT_TIMEOUT",
        "-e",
        "CLICKHOUSE_SEND_RECEIVE_TIMEOUT",
        "-e",
        "CLICKHOUSE_PASSWORD",
        "mcp/clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "sql-clickhouse.clickhouse.com",
        "CLICKHOUSE_PORT": "8443",
        "CLICKHOUSE_USER": "demo",
        "CLICKHOUSE_SECURE": "true",
        "CLICKHOUSE_VERIFY": "true",
        "CLICKHOUSE_CONNECT_TIMEOUT": "30",
        "CLICKHOUSE_SEND_RECEIVE_TIMEOUT": "30",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD_HERE>"
      }
    }
  }
}

Why is it safer to run MCP Servers with Docker?