ClickHouse MCP Server

Databasestdiov0.4.0

Provides AI agents with access to ClickHouse analytical databases through the Model Context Protocol. Enables running analytical queries, exploring table schemas, inspecting materialized views, and monitoring query performance. Designed for OLAP workloads with support for large result sets and query profiling.

clickhouse database analytics olap sql data-warehouse

连接

将此配置添加到 .claude/mcp.json

{
  "mcpServers": {
    "clickhouse": {
      "command": "npx",
      "args": [
        "-y",
        "@clickhouse/mcp-server"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_PORT": "<YOUR_CLICKHOUSE_PORT>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

工具 (4)

run_query

Execute a ClickHouse SQL query and return results. Supports SELECT, SHOW, DESCRIBE, and EXPLAIN statements.

{
  "type": "object",
  "required": [
    "query"
  ],
  "properties": {
    "query": {
      "type": "string",
      "description": "ClickHouse SQL query to execute"
    },
    "format": {
      "type": "string",
      "description": "Output format (JSON, TabSeparated, CSV, Pretty)"
    },
    "max_rows": {
      "type": "integer",
      "description": "Maximum rows to return"
    }
  }
}

list_databases

List all databases in the ClickHouse instance.

{
  "type": "object",
  "properties": {}
}

describe_table

Show the schema of a ClickHouse table including column types, codecs, and TTL rules.

{
  "type": "object",
  "required": [
    "database",
    "table"
  ],
  "properties": {
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "database": {
      "type": "string",
      "description": "Database name"
    }
  }
}

query_profile

Analyze query execution plan and performance metrics for optimization.

{
  "type": "object",
  "required": [
    "query"
  ],
  "properties": {
    "query": {
      "type": "string",
      "description": "Query to analyze"
    }
  }
}

资源

此服务器未提供任何资源。

提示词

此服务器未提供任何提示词。

服务器信息

作者: ClickHouse (@ClickHouse)
代码仓库: https://github.com/ClickHouse/clickhouse-mcp-server
许可证: Apache-2.0
版本: 0.4.0
星标: 1,560
最后更新: 2026年5月15日