ClickHouse MCP配置与使用教程

{
  "id": "io.github.ClickHouse/mcp-clickhouse",
  "type": "mcp-server",
  "version": "0.6.0",
  "displayName": "ClickHouse",
  "description": "Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.",
  "repository": {
    "url": "https://github.com/ClickHouse/mcp-clickhouse",
    "source": "github"
  },
  "homepage": "https://clickhouse.com",
  "distribution": {
    "packages": [
      {
        "registryType": "pypi",
        "identifier": "mcp-clickhouse",
        "version": "0.6.0",
        "runtimeHint": "uvx",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "CLICKHOUSE_HOST",
            "description": "Hostname of the ClickHouse server",
            "isRequired": true
          },
          {
            "name": "CLICKHOUSE_USER",
            "description": "Username for ClickHouse authentication",
            "isRequired": true
          },
          {
            "name": "CLICKHOUSE_PASSWORD",
            "description": "Password for ClickHouse authentication",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "CLICKHOUSE_PORT",
            "description": "ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise"
          },
          {
            "name": "CLICKHOUSE_SECURE",
            "description": "Use HTTPS to connect to ClickHouse"
          },
          {
            "name": "CLICKHOUSE_VERIFY",
            "description": "Verify SSL certificates"
          },
          {
            "name": "CLICKHOUSE_DATABASE",
            "description": "Default database to use"
          },
          {
            "name": "CLICKHOUSE_ROLE",
            "description": "ClickHouse role to activate for the session"
          },
          {
            "name": "CLICKHOUSE_ALLOW_WRITE_ACCESS",
            "description": "Allow write operations (DDL and DML). Queries run read-only by default"
          },
          {
            "name": "CLICKHOUSE_ALLOW_DROP",
            "description": "Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled"
          },
          {
            "name": "CLICKHOUSE_MCP_QUERY_TIMEOUT",
            "description": "Query tool timeout in seconds"
          },
          {
            "name": "CLICKHOUSE_MCP_MAX_WORKERS",
            "description": "Maximum query worker thread pool size"
          }
        ]
      },
      {
        "registryType": "oci",
        "identifier": "ghcr.io/clickhouse/mcp-clickhouse:0.6.0",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "CLICKHOUSE_HOST",
            "description": "Hostname of the ClickHouse server",
            "isRequired": true
          },
          {
            "name": "CLICKHOUSE_USER",
            "description": "Username for ClickHouse authentication",
            "isRequired": true
          },
          {
            "name": "CLICKHOUSE_PASSWORD",
            "description": "Password for ClickHouse authentication",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "CLICKHOUSE_PORT",
            "description": "ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise"
          },
          {
            "name": "CLICKHOUSE_SECURE",
            "description": "Use HTTPS to connect to ClickHouse"
          },
          {
            "name": "CLICKHOUSE_VERIFY",
            "description": "Verify SSL certificates"
          },
          {
            "name": "CLICKHOUSE_DATABASE",
            "description": "Default database to use"
          },
          {
            "name": "CLICKHOUSE_ROLE",
            "description": "ClickHouse role to activate for the session"
          },
          {
            "name": "CLICKHOUSE_ALLOW_WRITE_ACCESS",
            "description": "Allow write operations (DDL and DML). Queries run read-only by default"
          },
          {
            "name": "CLICKHOUSE_ALLOW_DROP",
            "description": "Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled"
          },
          {
            "name": "CLICKHOUSE_MCP_QUERY_TIMEOUT",
            "description": "Query tool timeout in seconds"
          },
          {
            "name": "CLICKHOUSE_MCP_MAX_WORKERS",
            "description": "Maximum query worker thread pool size"
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode",
    "trae",
    "cherry-studio",
    "lingma",
    "windsurf",
    "cline",
    "workbuddy"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.ClickHouse/mcp-clickhouse",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.ClickHouse%2Fmcp-clickhouse/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}