Back to articles
n8n Integration for ClickHouse - Full CRUD, Triggers & AI Agent Support

n8n Integration for ClickHouse - Full CRUD, Triggers & AI Agent Support

via Dev.toSameer Deshmukh

Hi ClickHouse community! I wanted to share a project I've been working on: n8n-nodes-clickhouse-db - a comprehensive ClickHouse integration for the n8n workflow automation platform. What is n8n? n8n is an open-source workflow automation tool (like Zapier but self-hostable). It lets you connect APIs, databases, and services with a visual workflow builder. Why This Matters for ClickHouse Users This integration lets you: Automate data pipelines - Pull data from any API and insert into ClickHouse Build real-time dashboards - Query ClickHouse and push results to Slack, email, etc. Event-driven workflows - Trigger workflows when new data arrives in ClickHouse AI-powered analytics - Let LLMs query your ClickHouse data via natural language Features Full CRUD + Schema Operations: Parameterized queries ( {param:Type} syntax) Batch inserts (up to 100k rows per batch) Upsert with ReplacingMergeTree auto-detection Update/Delete with WHERE clauses Create tables with schema inference List databases/t

Continue reading on Dev.to

Opens in a new tab

Read Full Article
2 views

Related Articles