# Connect ClickHouse with Open Flow

Source: https://openflow.run/en/integrations/clickhouse/

[All integrations](https://openflow.run/en/integrations/)

Provide a table for schema exploration or a reviewed SELECT query to execute. AI can explain the result with its filters, aggregation, and execution statistics.

*   [5 actions](https://openflow.run/en/integrations/clickhouse/#integration-actions)
*   Custom credentials
*   Data & analytics
*   Developer tools

[Connect ClickHouse](https://console.openflow.run/connections/clickhouse)

20,000 free app calls per month (paid services billed separately)

## What you can do

ClickHouse table metadata describes the available columns and keys, while query results provide rows and execution statistics. These support analytical explanations tied to an explicit query.

### Explore Databases and Schemas

List databases and tables, inspect table columns and keys, and read a database schema overview.

### Execute SQL Queries

Execute a supplied query with database, time-limit, and settings options and retrieve rows, columns, and statistics.

## All actions

5 actions

### Execute Query

Execute a SQL query against a ClickHouse instance and return JSON rows.

`clickhouse.execute_query`

### List Databases

List databases available in the connected ClickHouse instance.

`clickhouse.list_databases`

### List Tables

List tables or views in ClickHouse databases.

`clickhouse.list_tables`

### Get Table Schema

Get column metadata for one ClickHouse table.

`clickhouse.get_table_schema`

### Get Database Schema

Get an overview of one ClickHouse database with tables and optional column name lists.

`clickhouse.get_database_schema`

No actions match your search.

## Connect ClickHouse with Open Flow

[Connect ClickHouse](https://console.openflow.run/connections/clickhouse)

20,000 free app calls per month (paid services billed separately)
