How do I install the Clickhouse skill?

Run npx skillmds@latest add robomotionio/clickhouse in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Clickhouse safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Clickhouse?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Clickhouse free to use?

Yes. Installing skills from SkillMD is free. This skill is licensed under Apache-2.

Who published Clickhouse?

robomotionio (@robomotionio) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Clickhouse by robomotionio — Agent Skill

Name: Clickhouse
Author: robomotionio

Clickhouse

ClickHouse columnar database — execute analytical SQL queries and batch inserts on ClickHouse. Supports query execution, batch transactions, and non-query operations via `robomotion clickhouse`. Do NOT use for PostgreSQL, MySQL, MongoDB, or other databases.

robomotionio d69ac7a 2 files · 4.3 KB Updated Sep 17, 2026

File contents

ClickHouse

The robomotion clickhouse CLI connects to ClickHouse for analytical SQL workloads. It supports executing SELECT queries, running INSERT/UPDATE/DELETE statements, and batch transactions for atomically executing multiple SQL commands.

When to use

Run analytical SQL queries on ClickHouse columnar tables
Insert data using batch transactions for atomicity
Execute DDL or non-query SQL statements

Prerequisites

robomotion CLI installed
Package installed: robomotion install clickhouse
ClickHouse connection credentials configured via Robomotion vault

IMPORTANT: Session Mode Required for Multi-Step Operations

Each CLI command runs as a separate process — connection IDs from connect do NOT persist across calls. You MUST use --session on connect and pass --session-id to all subsequent commands.

Workflow

Install (once): robomotion install clickhouse

Connect with session:

robomotion clickhouse connect --session --output json
# → {"outConnectionId":"<conn-id>","session_id":"<session-id>"}

Use the returned conn-id and session-id in all subsequent commands:

robomotion clickhouse execute_query --conn-id "<conn-id>" --session-id "<session-id>" --output json

Disconnect when done:

robomotion clickhouse disconnect --conn-id "<conn-id>" --session-id "<session-id>" --output json

Always append --output json to get structured JSON results.

Commands Reference

robomotion clickhouse connect --session --output json Connect to a ClickHouse database server using credentials
robomotion clickhouse create_batch --conn-id --session-id "<session-id>" --output json Create a new batch transaction for executing multiple SQL commands atomically
robomotion clickhouse disconnect --conn-id --session-id "<session-id>" --output json Disconnect from a ClickHouse database server and release the connection
robomotion clickhouse execute_non_query --conn-id --batch-id --session-id "<session-id>" --output json Execute a SQL command (INSERT٫ UPDATE٫ DELETE٫ etc.) that does not return results
robomotion clickhouse execute_query --conn-id --batch-id --session-id "<session-id>" --output json Execute a SQL SELECT query on ClickHouse and return the results
robomotion clickhouse send_batch --batch-id --output json Commit a batch transaction and execute all queued SQL commands

Environment

ROBOMOTION_API_TOKEN (if vault credentials are needed)

---name: clickhousedescription: ClickHouse columnar database — execute analytical SQL queries and batch inserts on ClickHouse. Supports query execution, batch transactions, and non-query operations via `robomotion clickhouse`. Do NOT use for PostgreSQL, MySQL, MongoDB, or other databases.license: Apache-2.0---# ClickHouseThe `robomotion clickhouse` CLI connects to ClickHouse for analytical SQL workloads. It supports executing SELECT queries, running INSERT/UPDATE/DELETE statements, and batch transactions for atomically executing multiple SQL commands.## When to use- Run analytical SQL queries on ClickHouse columnar tables- Insert data using batch transactions for atomicity- Execute DDL or non-query SQL statements## Prerequisites- `robomotion` CLI installed- Package installed: `robomotion install clickhouse`- ClickHouse connection credentials configured via Robomotion vault## IMPORTANT: Session Mode Required for Multi-Step OperationsEach CLI command runs as a **separate process** — connection IDs from `connect` do NOT persist across calls.You MUST use `--session` on `connect` and pass `--session-id` to all subsequent commands.## Workflow1. Install (once): `robomotion install clickhouse`2. Connect with session: ``` robomotion clickhouse connect --session --output json # → {"outConnectionId":"<conn-id>","session_id":"<session-id>"} ```3. Use the returned `conn-id` and `session-id` in all subsequent commands: ``` robomotion clickhouse execute_query --conn-id "<conn-id>" --session-id "<session-id>" --output json ```4. Disconnect when done: ``` robomotion clickhouse disconnect --conn-id "<conn-id>" --session-id "<session-id>" --output json ```**Always** append `--output json` to get structured JSON results.## Commands Reference- `robomotion clickhouse connect --session --output json` Connect to a ClickHouse database server using credentials- `robomotion clickhouse create_batch --conn-id --session-id "<session-id>" --output json` Create a new batch transaction for executing multiple SQL commands atomically- `robomotion clickhouse disconnect --conn-id --session-id "<session-id>" --output json` Disconnect from a ClickHouse database server and release the connection- `robomotion clickhouse execute_non_query --conn-id --batch-id --session-id "<session-id>" --output json` Execute a SQL command (INSERT٫ UPDATE٫ DELETE٫ etc.) that does not return results- `robomotion clickhouse execute_query --conn-id --batch-id --session-id "<session-id>" --output json` Execute a SQL SELECT query on ClickHouse and return the results- `robomotion clickhouse send_batch --batch-id --output json` Commit a batch transaction and execute all queued SQL commands## Environment- ROBOMOTION_API_TOKEN (if vault credentials are needed)

Frequently asked questions