shield_lock
金大哥
← 返回 Skill 列表
extension
分类: 其它无需 API Key

ClickHouse

使用 ClickHouse HTTP API 检查数据库、审查表结构并执行 SQL 分析查询。适用于用户需要查询分析数据的场景。

person作者: hith3shhubclawhub
open_in_new仓库download下载资源包

ClickHouse

ClickHouse

Work with ClickHouse from chat — inspect databases, review schemas, and run read-only SQL analytics queries via the ClickHouse HTTP API with API key authentication.

This skill uses ClawLink for hosted connection flows and credentials so you do not need to configure ClickHouse API access yourself.

Setup in 3 Steps

| Step 1: Install | Step 2: Pair Account | Step 3: Connect ClickHouse | |:---:|:---:|:---:| | Install | Pair | App-specific connection GIF coming soon | | Run the install command in OpenClaw | Sign in and approve the device | Open the dashboard and connect ClickHouse |

How It Works

┌─────────────────┐     ┌──────────────┐     ┌──────────────────┐
│   OpenClaw      │────▶│   ClawLink   │────▶│ ClickHouse HTTP API│
│   (User Chat)   │     │   (API Key)  │     │ (SQL Queries)    │
└─────────────────┘     └──────────────┘     └──────────────────┘
         │                       │                       │
         │  1. Install Plugin    │                       │
         │  2. Pair Device       │                       │
         │  3. Connect ClickHouse│                       │
         │                       │  4. Secure Key │
         │                       │  5. Proxy Requests    │
         │                       │                       │
         ▼                       ▼                       ▼
   ┌──────────┐           ┌──────────┐           ┌──────────┐
   │  SKILL   │           │ Dashboard│           │ ClickHouse│
   │  File    │           │ Auth     │           │ Queries  │
   └──────────┘           └──────────┘           └──────────┘

Install

Install the verified ClawLink plugin from ClawHub. After the user confirms, complete the full setup so ClawLink tools are visible in the next OpenClaw chat.

openclaw plugins install clawhub:clawlink-plugin
openclaw config set tools.alsoAllow '["clawlink-plugin"]' --strict-json
openclaw gateway restart

Then tell the user: "OpenClaw has been restarted. Send /new as a standalone message to start a fresh chat, then ask for ClickHouse again."

Quick Start

# List databases
clawlink_call_tool --tool "clickhouse_list_databases" --params '{}'

# List tables in a database
clawlink_call_tool --tool "clickhouse_list_tables" --params '{"database": "default"}'

# Get database schema overview
clawlink_call_tool --tool "clickhouse_get_database_schema" --params '{"database": "default"}'

Authentication

All ClickHouse tool calls are authenticated automatically by ClawLink using the user's connected ClickHouse account.

No credentials are required in chat. ClawLink stores the connection details securely and injects them into every ClickHouse request on the user's behalf.

Getting Connected

  1. Install the ClawLink plugin (see Install above).
  2. Pair the plugin with clawlink_begin_pairing if it is not configured yet.
  3. Open https://claw-link.dev/dashboard?add=clickhouse and connect ClickHouse.
  4. Call clawlink_list_integrations to verify the connection is active.

Connection Management

List Connections

clawlink_list_integrations

Response: Returns all connected integrations. Look for clickhouse in the list.

Verify Connection

clawlink_list_tools --integration clickhouse

Response: Returns the live tool catalog for ClickHouse.

Reconnect

If ClickHouse tools are missing or the connection shows an error:

  1. Direct the user to https://claw-link.dev/dashboard?add=clickhouse
  2. After they confirm, call clawlink_list_integrations to verify
  3. Then call clawlink_list_tools --integration clickhouse

Security & Permissions

  • ClickHouse queries are read-only by design in ClawLink — no INSERT, ALTER, DROP, or TRUNCATE operations are exposed.
  • Query operations require user confirmation for large result sets or expensive queries (full table scans, GROUP BY without limits).
  • Avoid running queries that could lock tables or consume excessive resources.

Tool Reference

Schema Discovery

| Tool | Description | Mode | |------|-------------|------| | clickhouse_list_databases | List all databases in the ClickHouse instance | Read | | clickhouse_list_tables | List tables in a database with engine, size, and row count | Read | | clickhouse_get_database_schema | Get full schema overview including all tables and columns | Read | | clickhouse_get_table_schema | Get detailed schema for a specific table including columns and types | Read |

Query Execution

| Tool | Description | Mode | |------|-------------|------| | clickhouse_execute_query | Execute a read-only SQL query and return results | Read |

Interface

| Tool | Description | Mode | |------|-------------|------| | clickhouse_get_play_interface | Get the ClickHouse Play web interface URL for interactive queries | Read |

Code Examples

List all databases

clawlink_call_tool --tool "clickhouse_list_databases" \
  --params '{}'

Get database schema

clawlink_call_tool --tool "clickhouse_get_database_schema" \
  --params '{
    "database": "analytics"
  }'

Execute a simple query

clawlink_call_tool --tool "clickhouse_execute_query" \
  --params '{
    "query": "SELECT * FROM events WHERE date >= today() - 7 LIMIT 100"
  }'

Get table schema

clawlink_call_tool --tool "clickhouse_get_table_schema" \
  --params '{
    "database": "analytics",
    "table": "events"
  }'

Discovery Workflow

  1. Call clawlink_list_integrations to confirm ClickHouse is connected.
  2. Call clawlink_list_tools --integration clickhouse to see the live catalog.
  3. Treat the returned list as the source of truth. Do not guess or assume what tools exist.
  4. If the user describes a capability but the exact tool is unclear, call clawlink_search_tools with a short query and integration clickhouse.
  5. If no ClickHouse tools appear, direct the user to https://claw-link.dev/dashboard?add=clickhouse.

Execution Workflow

┌─────────────────────────────────────────────────────────────┐
│  SCHEMA DISCOVERY (Always first)                           │
│  list_databases → list_tables → get_table_schema          │
│                                                             │
│  Example: Discover tables → Understand schema → Then query   │
└─────────────────────────────────────────────────────────────┘
                              │
                              ▼
┌─────────────────────────────────────────────────────────────┐
│  QUERY EXECUTION (Read-only)                                │
│  describe → preview → confirm → execute                     │
│                                                             │
│  Example: Describe query → Preview results → User approves   │
│           → Execute read-only query                          │
└─────────────────────────────────────────────────────────────┘
  1. Always explore the schema first with clickhouse_list_databases and clickhouse_get_database_schema before running queries.
  2. For unfamiliar tables, call clickhouse_get_table_schema to understand column names and types.
  3. Keep queries targeted with WHERE clauses and LIMIT — avoid full table scans when possible.
  4. For large or complex queries, confirm the expected result size with the user before executing.
  5. If the tool call fails, report the real error. Do not invent results.

Notes

  • ClickHouse SQL syntax differs from standard SQL — use ClickHouse-specific functions and syntax.
  • All queries are read-only — no data modification is possible through ClawLink tools.
  • Use LIMIT to prevent accidentally large result sets.
  • Sample data can be included in table schema responses — use it to understand data types.
  • The Play interface provides an interactive HTML UI with Monaco Editor for manual query writing.

Error Handling

| Status / Error | Meaning | |----------------|---------| | Tool not found | The tool name does not exist in the current catalog. Verify with clawlink_list_tools --integration clickhouse. | | Missing connection | ClickHouse is not connected. Direct the user to https://claw-link.dev/dashboard?add=clickhouse. | | SyntaxError | SQL syntax error in query. Check ClickHouse SQL syntax. | | TableNotFound | Table or database does not exist. Verify names with schema tools first. | | Query error | Query failed. Check query logic and table structure. |

Troubleshooting: Tools Not Visible

  1. Check that the ClawLink plugin is installed: 
    openclaw plugins list
  2. If the plugin is installed but tools are missing, tell the user to send /new as a standalone message to reload the catalog.
  3. If a fresh chat does not help, run: 
    openclaw config set tools.alsoAllow '["clawlink-plugin"]' --strict-json
openclaw gateway restart
  4. After restart, tell the user to send /new again and retry.

Troubleshooting: Query Errors

  1. Always use schema tools first to verify table and column names.
  2. Verify the database name with clickhouse_list_databases.
  3. Use LIMIT to test queries with small result sets first.

Resources

  • ClickHouse Documentation
  • ClickHouse SQL Reference
  • ClawLink: https://claw-link.dev/?utm_source=clawhub&utm_medium=referral&utm_content=clickhouse-analytics
  • ClawLink Docs: https://docs.claw-link.dev/openclaw
  • ClawLink Verification: https://claw-link.dev/verify

Related Skills

  • Datadog — For Datadog observability and metrics
  • Snowflake — For Snowflake data warehouse queries
  • PostgreSQL — For PostgreSQL database operations

Powered by ClawLink — an integration hub for OpenClaw

ClawLink Logo