ClickHouse icon

ClickHouse

Query, insert, update, delete, and manage ClickHouse tables. Supports AI agent tool use with schema discovery, auto-pagination for large results, and parameterized queries.

Actions11

Execute Raw

AI-generated

Summary

Execute a raw DDL or DML statement against ClickHouse

Inputs

  • query (required) — The DDL or DML statement to execute (e.g., CREATE TABLE, ALTER TABLE, INSERT, DELETE, etc.)
  • options — Additional execution settings, including an optional JSON string of ClickHouse session settings

Output shape

a JSON object indicating success and optionally the raw response or error details

On success the response body is returned as a string; errors are raised as node errors unless continueOnFail is enabled

Examples

Example 1: Create a new table

Query: CREATE TABLE IF NOT EXISTS my_table (id UInt64, name String) ENGINE = MergeTree() ORDER BY id; Options: {"max_execution_time": 60}

Example 2: Insert data via raw INSERT

Query: INSERT INTO my_table VALUES (1, 'Alice'); Options: {"chunkSize": 1000}

Example 3: Delete rows

Query: DELETE FROM my_table WHERE id = 42; Options: {"allow_experimental_lightweight_delete": 1}

Links

Discussion