n8n-nodes-clickhouse

This is an n8n community node. It lets you use ClickHouse in your n8n workflows.

ClickHouse is a fast open-source column-oriented database management system that allows generating analytical data reports in real-time using SQL queries.

n8n is a fair-code licensed workflow automation platform.

Installation
Operations
Credentials Compatibility
Resources

Installation

Follow the installation guide in the n8n community nodes documentation.

Operations

Query

Query SQL has to be provided. Rows are return as items.

Insert

Items are insert batch into user-specified table.

Credentials

In order to connect to ClickHouse, you have to configure credentials with HTTP URL (only HTTP protocol is supported) and user credentials.

Compatibility

Tested with 0.219.x.

Resources

• n8n community nodes documentation
• ClickHouse
• ClickHouse HTTP interface

TODOs

• ClickHouse settings (it's possible to set settings for SELECT query)
• query parameters