Back to the index

ClickHouse/mcp-clickhouse

ClickHouse/mcp-clickhouse
Setup guide

What it does

ClickHouse database integration with schema inspection and query capabilities.

Local connectionPricing not confirmedv0.7.0

Connection manifest

Public connection metadata from the source. Follow the provider’s setup guide for authentication, permissions, and required variables.

{
  "name": "io.github.ClickHouse/mcp-clickhouse",
  "version": "0.7.0",
  "repository": {
    "url": "https://github.com/ClickHouse/mcp-clickhouse"
  },
  "remotes": [],
  "packages": [
    {
      "registryType": "pypi",
      "identifier": "mcp-clickhouse",
      "version": "0.7.0",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "name": "CLICKHOUSE_HOST",
          "isRequired": true
        },
        {
          "name": "CLICKHOUSE_USER",
          "isRequired": true
        },
        {
          "name": "CLICKHOUSE_PASSWORD",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_PORT",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_SECURE",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_VERIFY",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_CA_CERT",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_CLIENT_CERT",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_CLIENT_CERT_KEY",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_TLS_MODE",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_DATABASE",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_ROLE",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_ALLOW_WRITE_ACCESS",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_ALLOW_DROP",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_MCP_QUERY_TIMEOUT",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_MCP_MAX_WORKERS",
          "isRequired": false
        }
      ]
    },
    {
      "registryType": "oci",
      "identifier": "ghcr.io/clickhouse/mcp-clickhouse:0.7.0",
      "version": "",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "name": "CLICKHOUSE_HOST",
          "isRequired": true
        },
        {
          "name": "CLICKHOUSE_USER",
          "isRequired": true
        },
        {
          "name": "CLICKHOUSE_PASSWORD",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_PORT",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_SECURE",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_VERIFY",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_CA_CERT",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_CLIENT_CERT",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_CLIENT_CERT_KEY",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_TLS_MODE",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_DATABASE",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_ROLE",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_ALLOW_WRITE_ACCESS",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_ALLOW_DROP",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_MCP_QUERY_TIMEOUT",
          "isRequired": false
        },
        {
          "name": "CLICKHOUSE_MCP_MAX_WORKERS",
          "isRequired": false
        }
      ]
    }
  ]
}
Metadata reviewed for listing. Server code, permissions, and runtime behavior have not been security-audited. Directory access is free; individual providers may charge.