[New Node] ClickHouse — query, insert, and manage ClickHouse from n8n

Built with n8n
1

Hi all! I’ve published a community node for ClickHouse: n8n-nodes-clickhouse-db

Features:

  • Parameterized queries with typed parameters (String, UInt32, Float64, etc.)

  • Bulk insert from workflow data

  • Raw SQL execution for DDL/DML

  • AI agent tool compatibility — let AI agents query your ClickHouse database

  • Supports both JSON and TabSeparated output formats

Installation:
Go to Settings → Community Nodes → Install, and enter: n8n-nodes-clickhouse-db

Links:

Would love to hear your feedback or feature requests!

2

Just a quick update on top of the existing node i have made some new changes in the latest version

Hey n8n community!

I’m excited to share n8n-nodes-clickhouse-db - a feature-complete ClickHouse integration that I’ve been building to make working with ClickHouse in n8n as seamless as possible.

Why I Built This

While n8n’s HTTP Request node can communicate with ClickHouse, I found myself repeatedly:

  • Manually constructing URLs and auth headers
  • Parsing JSON responses
  • Handling errors inconsistently
  • Missing out on ClickHouse-specific features

This node wraps all of that into a clean, purpose-built interface.

What’s Included

10 Operations:

  • Execute Query (with parameterized queries!)
  • Insert (batch support up to 100k rows)
  • NEW: Upsert (auto-detects ReplacingMergeTree)
  • Update Rows
  • Delete Rows
  • Create Table (auto-infer schema from input)
  • List Tables / List Databases
  • Get Table Info
  • Execute Raw DDL/DML

Trigger Node:

  • Poll for new rows or run custom queries
  • Tracks cursor across workflow restarts

AI Agent Ready:

  • usableAsTool: true - let LLMs query your ClickHouse data

Security Hardened (v1.4.0):

  • SQL injection protection with strict validation
  • 138 tests including 40+ penetration tests
  • Control character and subquery blocking

Installation

n8n-nodes-clickhouse-db

Go to Settings → Community Nodes → Install and paste the above.

Links

ClickHouse Cloud Support

Works great with ClickHouse Cloud - just set protocol to HTTPS and port to 8443. JWT Bearer auth is supported for SSO environments.

Feedback Welcome!

I’d love to hear what features you’d find useful. Check out the ROADMAP for planned features including:

  • Materialized View management
  • Pagination support
  • EXPLAIN mode
  • AI agent schema descriptions

Thanks for checking it out!