A professional toolset for querying, optimizing, and administering ClickHouse OLAP databases for real-time analytics on billions of rows.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install clickhouse
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 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?
The ClickHouse integration for Openclaw Skills empowers developers to manage high-performance analytical workloads directly through their AI agent. It focuses on sub-second query execution and efficient columnar storage management without the need for traditional indexes. By utilizing this skill, users can leverage the full power of the MergeTree engine family to handle everything from simple log analysis to complex time-series data processing.
This skill is built to handle the technical nuances of ClickHouse, including specialized data types like LowCardinality strings and specialized engines for aggregated metrics. It ensures that your database interactions follow best practices for batching and data layout, making it an essential addition to your Openclaw Skills library for any data-intensive application.
ClickHouse Use Cases
- Designing high-performance schemas for real-time dashboards and log analysis.
- Optimizing analytical queries to achieve sub-second response times on massive datasets.
- Automating batch data ingestion workflows to prevent part fragmentation.
- Implementing data retention policies using TTL to manage storage costs.
- Monitoring cluster health and query performance using internal system tables.
How ClickHouse Works
- The agent verifies the local environment for the required clickhouse-client binary.
- Connection profiles and query patterns are initialized within the local memory directory.
- The agent analyzes user requests to determine the most efficient table engine and ordering keys.
- Commands are executed via the native TCP or HTTP interfaces to interact with ClickHouse instances.
- The skill applies performance optimizations like PREWHERE and sampling to minimize resource usage.
- Results and schema definitions are persisted in the local file system for contextual continuity.
ClickHouse Setup
To enable this skill, you must first install the ClickHouse client. On macOS, you can use Homebrew:
brew install clickhouse
Once installed, initialize your connection settings by editing the configuration files located in your local directory. The agent will look for connection profiles in ~/clickhouse/setup.md to establish communication with your database instances as part of your Openclaw Skills environment.
ClickHouse Data Schema & Taxonomy
The skill maintains a structured memory system in ~/clickhouse/ to ensure persistence and performance. Data is organized as follows:
| File/Directory | Purpose |
|---|---|
memory.md |
Persists connection profiles and reusable query patterns. |
schemas/ |
Stores table definitions and schema evolution history. |
queries/ |
A repository of saved analytical and administrative SQL scripts. |
performance.md |
Contains specific tuning strategies tailored to the user's data. |
ClickHouse Advanced Features
- Intelligent Engine Selection: Automatically suggests appropriate engines like SummingMergeTree or ReplacingMergeTree based on the use case.
- Materialized View Automation: Simplifies the creation of views for pre-aggregating expensive computations.
- Advanced Indexing: Optimizes ORDER BY clauses to match common query patterns and filtering requirements.
- System Table Integration: Provides deep insights into running processes, disk usage, and query logs.
- Multi-Agent Compatibility: Works seamlessly with other Openclaw Skills such as SQL and general data-analysis tools.
SKILL.md
Loading
Related Openclaw Skills
Clawic
Clawic is a premier directory providing a curated collection of high-quality tools and Openclaw Skills for AI agents.
Chief Information Security Officer
A strategic virtual CISO that automates security operations, compliance frameworks, and infrastructure auditing for development teams.
Chief Information Officer (CIO)
A comprehensive strategic framework for AI agents to drive digital transformation, manage vendor relations, and govern enterprise technology architecture.
CI-CD Automation Skill
A comprehensive automation skill for managing continuous integration and continuous deployment pipelines across web, mobile, and backend stacks.
CLO / Chief Legal Officer
An AI agent skill providing executive-level legal strategy, contract management, and regulatory compliance guidance.
Cloud Storage
A comprehensive framework for managing file operations across multiple cloud providers with cost awareness and reliability.
Featured*
