ClickHouse - OpenClaw Skill — OpenClaw Tutorials

Install Command

npx clawhub@latest install clickhouse

Installation Guide

Check Environment

Make sure Node.js 22+ and OpenClaw are installed. Run openclaw --version in your terminal to verify.

Run Installation

Run the install command above in your terminal. ClawHub will automatically download and install ClickHouse to the ~/.openclaw/skills/ directory.

Verify Installation

Run openclaw skills list to check your installed skills and confirm ClickHouse appears in the list.

Configure (Optional)

Follow the configuration instructions in the description below to add skill settings to ~/.config/openclaw/openclaw.json5.

Manual Installation: Copy the Skill folder to ~/.openclaw/skills/ or the skills/ directory in your project root. Make sure the folder contains a SKILL.md file.

High-performance columnar queries Table structure and index browsing Query performance analysis and optimization suggestions

Detailed Description

ClickHouse MCP server provides read-only query capabilities for the ClickHouse columnar analytical database, suitable for real-time analysis of large-scale time-series and log data, with query performance reaching billions of rows per second.

Core Features

Read-Only Query (run_select_query): Execute SELECT queries, automatically restricted to read-only operations for data safety, supporting ClickHouse-specific functions and syntax
Schema Browsing: List databases, tables, and column information, view table engine types (MergeTree/ReplacingMergeTree, etc.) and partition settings
Query Analysis: Analyze query execution plans and performance bottlenecks, provide optimization suggestions
System Information: View cluster status, node information, and system metrics

Configuration

{
  "mcpServers": {
    "clickhouse": {
      "command": "npx",
      "args": ["-y", "@clickhouse/mcp-server"],
      "env": {
        "CLICKHOUSE_HOST": "https://your-instance.clickhouse.cloud",
        "CLICKHOUSE_USER": "default",
        "CLICKHOUSE_PASSWORD": "your-password"
      }
    }
  }
}

Use Cases

Log analysis: Query and analyze PB-scale log data to quickly locate issues
Real-time reporting: Perform real-time aggregate analysis on time-series data to generate reports
User behavior analysis: Analyze clickstream and user event data
Performance monitoring: Query application and infrastructure performance metrics

← Back to Skills List