Sign inSign up

mcp/clickhouse

Verified Publisher

By mcp

•Updated 12 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

12 months ago

docker pull mcp/clickhouse

This week's pulls

Pulls:

18,094

Last week