mcp/clickhouse

Verified Publisher

By mcp

Updated 9 months ago

Official ClickHouse MCP Server

Image
Machine learning & AI
3

100K+

mcp/clickhouse repository overview

Official ClickHouse MCP Server

Official ClickHouse MCP Server.

What is an MCP Server?

MCP Info

Image Building Info

AttributeDetails
Dockerfilehttps://github.com/ClickHouse/mcp-clickhouse/blob/21e6cb2b0758150e8fd0627b699fbfd78e31837b/Dockerfile
Commit21e6cb2b0758150e8fd0627b699fbfd78e31837b
Docker Image built byDocker Inc.
Docker Scout Health ScoreDocker Scout Health Score
Verify SignatureCOSIGN_REPOSITORY=mcp/signatures cosign verify mcp/clickhouse --key https://raw.githubusercontent.com/docker/keyring/refs/heads/main/public/mcp/latest.pub
LicenceApache License 2.0

Available Tools (3)

Tools provided by this ServerShort Description
list_databasesList available ClickHouse databases
list_tablesList available ClickHouse tables in a database, including schema, comment, row count, and column count.
run_select_queryRun 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.

ParametersTypeDescription
databasestring
likestring optional
not_likestring optional

Tool: run_select_query

Run a SELECT query in a ClickHouse database

ParametersTypeDescription
querystring

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?

Install from MCP:Hub

Tag summary

Content type

Image

Digest

sha256:51bcd33e1

Size

332.3 MB

Last updated

9 months ago

docker pull mcp/clickhouse

This week's pulls

Pulls:

12,602

Last week