ClickHouse Reference, 6 actions

01. Operations

Act on ClickHouse from a workflow

Operations are the actions a workflow can take in ClickHouse, grouped by category. Each lists its method, parameters, and a template you can drop it into.

Databases

1 operation

Access and enumerate the databases available in your ClickHouse instance within a workflow. Use these operations when you need to discover which databases exist or dynamically reference them for queries and data operations.

Action

List ClickHouse Databases

CLICKHOUSE_LIST_DATABASES

Retrieve all databases available in your ClickHouse instance to understand your data structure and identify which database contains the tables you need to query.

2 input

Interface

1 operation

Retrieve connection details and metadata for the ClickHouse Play interface to integrate with web-based interactions or monitoring dashboards. This is useful when you need programmatic access to interface information for testing or development purposes.

Action

Get ClickHouse Play Interface

CLICKHOUSE_GET_PLAY_INTERFACE

Access an interactive web interface to write and test ClickHouse queries without leaving your browser, complete with a code editor and result visualization.

Queries

1 operation

Run custom SQL queries directly against your ClickHouse database as part of an automated workflow. Leverage this to execute analytics, perform data transformations, or extract specific results from your tables.

Action★ Featured

Execute ClickHouse Query

CLICKHOUSE_EXECUTE_QUERY

Run SQL queries directly against your ClickHouse database to retrieve, analyze, or aggregate data in real-time. This enables you to access insights from large datasets without needing separate analytics tools.

5 input

Schema

2 operations

Inspect the structure and metadata of your ClickHouse tables and databases, including column definitions and data types. These operations are essential when you need to validate table structures, dynamically build queries, or document your data model.

Action

Get Database Schema

CLICKHOUSE_GET_DATABASE_SCHEMA

Retrieve the complete structure of your ClickHouse database including all tables and their columns in one call, helping you understand what data you have available.

2 input

Action

Get Table Schema

CLICKHOUSE_GET_TABLE_SCHEMA

Retrieve detailed column definitions and data types for any ClickHouse table to understand its structure before querying or analyzing data.

4 input

Tables

1 operation

Discover and list all tables within a ClickHouse database to support dynamic workflows and data exploration. Use these operations when you need to programmatically identify available tables or iterate over your dataset inventory.

Action★ Featured

List ClickHouse Tables

CLICKHOUSE_LIST_TABLES

Retrieve a complete inventory of all tables in your ClickHouse databases, including their storage engine, size, and row count to understand your data structure and storage footprint.

5 input

What now

Use ClickHouse in a workflow

Drop a trigger and an action into a template; approve from your phone; the workflow runs.

Browse workflow templates