Connect to a ClickHouse database
ClickHouse is a Sim integration in the Databases category. Sim is the AI workspace where teams build and deploy AI agents. Sim's ClickHouse integration provides 26 tools that AI agents can use inside Sim's visual workflow builder. ClickHouse requires no authentication. Free to start at sim.ai.
Last updated
Integrate ClickHouse into the workflow. Query and insert data, manage databases and tables, inspect schemas, monitor mutations and running queries, manage partitions, and execute raw SQL over the ClickHouse HTTP interface.
Sign up at sim.ai in seconds. No credit card required. Your workspace is ready immediately.
Open your workspace, drag a ClickHouse block onto the workflow builder. No authentication is needed.
Pick the tool you need, wire in an AI agent for reasoning or data transformation, and run. Your ClickHouse automation is live.
Ready-to-use templates featuring ClickHouse. Click any to build it instantly.
26 ClickHouse tools available to Sim agents.
Execute a SELECT query on a ClickHouse database
Execute raw SQL (DDL, mutations, or queries) on a ClickHouse database
Insert a row into a ClickHouse table
Insert multiple rows into a ClickHouse table
Update rows in a ClickHouse table via an ALTER TABLE ... UPDATE mutation
Delete rows from a ClickHouse table via an ALTER TABLE ... DELETE mutation
List all databases on a ClickHouse server
List tables in the connected ClickHouse database
Describe the columns of a ClickHouse table
Get the CREATE TABLE statement (DDL) for a ClickHouse table
Count rows in a ClickHouse table, optionally filtered
Introspect a ClickHouse database to retrieve table structures, columns, and engines
Create a new database on a ClickHouse server
Drop a database from a ClickHouse server
Create a new MergeTree-family table in ClickHouse
Drop a table from a ClickHouse database
Remove all rows from a ClickHouse table
Rename a ClickHouse table
Trigger a merge of table parts via OPTIMIZE TABLE
List active partitions for a ClickHouse table
Drop a partition from a ClickHouse table
List mutations (async ALTER UPDATE/DELETE) for the connected database
List currently running queries on a ClickHouse server
Kill a running query by its query ID
Get row counts and on-disk size for tables in the connected database
List configured clusters, shards, and replicas
Sim's ClickHouse integration adds 26 tools to the AI agents you build in Sim's visual workflow builder. Connect to a ClickHouse database.
