A secure, read-only analytical tool integration that lets OpenClaw agents explore ClickHouse database schemas and run SQL queries.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install clickhouse-analytics
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install clickhouse-analytics using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is ClickHouse Analytics?
The ClickHouse Analytics integration is a highly optimized skill designed to empower your AI assistant to directly query database schemas and execute high-performance analytical queries. Built on top of ClawLink's secure connection layers, this capability allows engineers, developers, and data analysts to run read-only SQL directly from their workspace.
By leveraging Openclaw Skills, developers can drastically simplify database inspection. Instead of switching back and forth between a separate SQL IDE and your chat interface, you can discover databases, list active tables, inspect column data types, and fetch analytical results safely using secure API key authentication managed securely on your behalf.
ClickHouse Analytics Use Cases
- Database Schema Discovery: Easily map out complex ClickHouse deployments by listing all databases, tables, engines, sizes, and row counts directly within your terminal.
- Read-Only Business Intelligence: Safely perform high-performance analytical queries to extract trends, aggregates, or specific logs without risking accidental data modifications.
- Interactive Playgrounds: Quickly generate and open the ClickHouse Play web interface URL for interactive query editing in a fully-equipped Monaco Editor environment.
How ClickHouse Analytics Works
- Discovery Request: The OpenClaw agent lists available database connections and active tools through the ClawLink plugin.
- Schema Mapping: Before running queries, the agent inspects table layouts, database catalogs, and column schemas to formulate correct, database-specific SQL.
- Query Preparation & Safety Check: The agent prepares a read-only SQL query with restrictive parameters (like
LIMIT) to prevent table locks or extreme resource utilization. - Execution via Gateway: The query is securely tunneled through ClawLink to the ClickHouse HTTP API, injecting credentials automatically without leaking keys to the chat.
- Result Render: The query results or table structures are cleanly parsed and returned to the developer interface.
ClickHouse Analytics Setup
Get started immediately by installing the plugin, syncing your account, and linking your database via the command-line interface:
openclaw plugins install clawhub:clawlink-plugin
openclaw config set tools.alsoAllow '["clawlink-plugin"]' --strict-json
openclaw gateway restart
Once restarted, run a fresh session by sending /new and connect your instance at https://claw-link.dev/dashboard?add=clickhouse. Verify your integrations with Openclaw Skills to ensure proper connectivity.
ClickHouse Analytics Data Schema & Taxonomy
The ClickHouse Analytics integration formats and maps database metadata dynamically. This structural taxonomy makes it easier for Openclaw Skills to understand the underlying schema rules:
| Tool Name | Output Format / Data Returned | Access Mode |
|---|---|---|
clickhouse_list_databases |
Array of database names inside the connected ClickHouse instance | Read-Only |
clickhouse_list_tables |
Object containing table list, engine types, storage size, and total row counts | Read-Only |
clickhouse_get_database_schema |
Full catalog index detailing tables, column namespaces, and metadata types | Read-Only |
clickhouse_get_table_schema |
Precise data types (e.g., Nullable, DateTime, String) for a specified target table | Read-Only |
ClickHouse Analytics Advanced Features
- Read-Only Enforced Design: Safety is first-class; write-operations like
INSERT,ALTER,DROP, orTRUNCATEare blocked at the proxy layer to keep production data safe. - Smart Safety Thresholds: Prompt confirmations are triggered automatically for resource-intensive operations or large results sets (e.g., table scans without limits).
- Web Play Interface Access: Generates interactive workspace URLs dynamically with integrated Monaco Editor for quick ad-hoc analysis when chat boundaries are too narrow.
- Credential-Free Session Handling: Automatically handles secure ClickHouse HTTP API key injections invisibly in the background, keeping credentials away from raw chat logs.
SKILL.md
Loading
Related Openclaw Skills
discord-communities
An integration enabling OpenClaw agents to manage Discord guilds, channels, user profiles, roles, and monetization structures via ClawLink.
Dynamics 365 CRM
Interact with and manage your Microsoft Dynamics 365 CRM records directly from your AI agent using the ClawLink integration.
Freshservice IT
An Openclaw Skills integration designed to manage Freshservice IT service operations, including tickets, requesters, agents, assets, and service catalogs directly from your AI agent.
GitHub Triage
An automated GitHub repository management skill that analyzes, groups, and triages issues and pull requests securely through ClawLink integration.
Content Repurpose to LinkedIn
Turn articles, notes, and raw text into polished, high-converting LinkedIn posts and publish them securely after user approval.
Cloudflare Infrastructure
A powerful Cloudflare integration for OpenClaw that lets developers manage DNS records, zones, WAF rules, and tunnels directly from their AI chat environment.
Featured*
