Connectors

Databases & Data Warehouses

ClickHouse

Columnar analytics database: run SQL queries and insert rows at high volume
ClickHouse documentationAPI checked August 18, 2026
Signs in with
Connection details
Runs on
Cloud or On-Prem Worker
Operations
8
Ready-made triggers
0

Connect ClickHouse

  1. In Neblex open Connect › Connections and click New Connection.
  2. Search for ClickHouse and give the connection a clear name.
  3. Fill in the fields. Secret values are encrypted and never shown again.
  4. Click Test, then Create Connection.
If the system is only reachable inside your network, choose an On-Prem Worker under Test from and run the flow on that Worker. See On-Prem Workers.
FieldWhat to enter
Connection setupRequired
HostRequired
PortOptionalOptional HTTP-interface port. If omitted, standard HTTP/HTTPS port selection applies; ClickHouse Cloud commonly requires 8443.Example: 8443
DatabaseOptionalOptional default database, transported as X-ClickHouse-Database after percent-decoding.
UserOptionalOptional ClickHouse user. The runtime uses `default` when omitted.
PasswordOptionalSecretOptional sealed ClickHouse key/password. An empty password is supported.
Use TLSOptionalTurning this off sends traffic and credentials without transport encryption. Use plaintext only for a customer-controlled endpoint that explicitly requires it.
Connection stringRequiredSecretPaste an http:// or https:// ClickHouse HTTP-interface URL with at most one database path segment. URL query options and fragments are rejected; native clickhouse:// is not supported.

Use it in a flow

  1. Open a flow, open the node library and search for ClickHouse.
  2. Drag it onto the canvas and choose an Operation and your connection.
  3. Map the operation's fields from earlier steps, or click Map with Matt.
  4. Use Test this step to see what it returns, then save.

To start a flow from ClickHouse without a ready-made trigger: a Poll for changes trigger on ClickHouse with your own query passes on new or changed records.

Operations

8 operations in 1 groups. Each one is a step you can add to a flow.

SQL8
Execute commandcommandExecute one INSERT, DDL, mutation, or other ClickHouse statement from the statement editor.
Execute SQLqueryExecute one ClickHouse SQL statement with native typed :name parameters.
Get server timeserverTimeReturn the ClickHouse server time and timezone.
Get server versionserverVersionReturn the ClickHouse server version.
Get table sizetableRowCountReturn catalog row and byte estimates for every visible table matching a name.
List table columnslistColumnsList visible columns matching a table name with database and table identity.
List tableslistTablesList visible non-system tables with database identity, engine, and size estimates.
Test ClickHousepingRun a minimal query and return ok=1.