ClickHouse
ClickHouse database integration for querying, inserting, and deleting analytical data
The ClickHouse integration lets your agents query, insert, and delete data in ClickHouse, a column-oriented database built for fast analytics over large datasets.
Prerequisites
You need:
- ClickHouse connection string — The connection details for your ClickHouse instance in key-value format (e.g.,
Host=myhost.clickhouse.cloud;Port=8443;Username=default;Password=pass;Database=default;Protocol=https). ClickHouse Cloud uses HTTPS on port 8443; self-hosted instances use HTTP on port 8123 by default. This includes authentication credentials.
Setup
- Open Integrations from the sidebar
- Select ClickHouse from the catalog
- Click Add Integration Config
- Give the config a display name (e.g., "ClickHouse - Analytics")
- Enter your Connection String (stored encrypted)
- Save the config
No separate authentication setup is needed — credentials are embedded in the connection string.
Using in Your Agent
- Open your agent in Agent Studio and select an Agent Step
- Under Attached Integration Configurations, click Attach configuration and choose your config
- Attach ClickHouse tools from the tools panel
- Tools are referenced as
clickhouse.query,clickhouse.insert, etc.
Available Tools
| Tool | Description | Action Type |
|---|---|---|
list_tables | List all tables in the database | ReadOnly |
describe_table | Get the schema of a table | ReadOnly |
query | Execute a SELECT query | ReadOnly |
insert | Insert rows into a table | Reversible |
delete | Delete rows with a lightweight DELETE FROM statement | Irreversible |
ClickHouse is analytics-oriented and has no standalone UPDATE statement, so there is no update tool. The delete tool issues a lightweight delete that runs as an asynchronous mutation — rows stop being returned by queries immediately, while physical removal happens in the background.