Home › Servers › ClickHouse

ClickHouse MCP server

ClickHouse's local server for querying ClickHouse clusters and chDB.

Transport	stdio (local, pypi), stdio (local, oci)
Auth	Local install declares secret environment variables
Registry name	io.github.ClickHouse/mcp-clickhouse · 0.7.0
Source	https://github.com/ClickHouse/mcp-clickhouse
Remote endpoints	None declared
Data source	Official MCP Registry
Date checked	2026-10-17

Install

Configs are generated only from packages and remotes on the registry entry. Empty optional flags are listed instead of inserted. Nothing is added that the entry does not declare.

The registry lists this as an oci package (ghcr.io/clickhouse/mcp-clickhouse:0.7.0) with runtime no runtimeHint, and does not include a run argument. No docker command is invented from that entry.

Local package (pypi)

Claude Desktop · mcpServers

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "[email protected]"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

Cursor · mcpServers

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "[email protected]"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

VS Code · .vscode/mcp.json

{
  "servers": {
    "clickhouse": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "[email protected]"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

Claude Code · .mcp.json

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "[email protected]"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

claude mcp add

claude mcp add clickhouse -- uvx [email protected]

Optional environment variables

Not placed in the snippet. Names declared on the entry:

CLICKHOUSE_PORT
CLICKHOUSE_SECURE
CLICKHOUSE_VERIFY
CLICKHOUSE_CA_CERT
CLICKHOUSE_CLIENT_CERT
CLICKHOUSE_CLIENT_CERT_KEY
CLICKHOUSE_TLS_MODE
CLICKHOUSE_DATABASE
CLICKHOUSE_ROLE
CLICKHOUSE_ALLOW_WRITE_ACCESS
CLICKHOUSE_ALLOW_DROP
CLICKHOUSE_MCP_QUERY_TIMEOUT
and 1 more optional names in the registry entry

Other packages on the entry

oci ghcr.io/clickhouse/mcp-clickhouse:0.7.0

FAQ

What transport does ClickHouse use?

stdio (local, pypi), stdio (local, oci).

What credentials are declared for ClickHouse?

Local install declares secret environment variables.

When was this checked, and what is the source?

These facts were checked on 2026-10-17. Registry name: io.github.ClickHouse/mcp-clickhouse. Source: https://github.com/ClickHouse/mcp-clickhouse.

Similar servers

Appwrite

Databases

Appwrite's server for auth, databases, storage, functions, and hosting. A remote endpoint and a package are both declared.

Streamable HTTP (remote), stdio (local, pypi)

Google Bigtable

Databases

Google's hosted server for administering Bigtable resources with the account you sign in.

Streamable HTTP (remote)

Google Cloud Firestore

Databases

Google's hosted server for working with Cloud Firestore databases in a project.

Streamable HTTP (remote)

Google Cloud Memorystore

Databases

Google's hosted server for Memorystore for Valkey instances and backups.

Streamable HTTP (remote)