The latest articles on DEV Community by Sameer Deshmukh (@sameer_deshmukh_d353043fd). https://dev.to/sameer_deshmukh_d353043fd https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3344631%2Faff8bbc0-1257-43a7-8763-a62269ef0439.png https://dev.to/sameer_deshmukh_d353043fd en Sameer Deshmukh Thu, 19 Mar 2026 10:39:32 +0000 https://dev.to/sameer_deshmukh_d353043fd/n8n-integration-for-clickhouse-full-crud-triggers-ai-agent-support-3b0b https://dev.to/sameer_deshmukh_d353043fd/n8n-integration-for-clickhouse-full-crud-triggers-ai-agent-support-3b0b <p>Hi ClickHouse community!</p> <p>I wanted to share a project I've been working on: <strong>n8n-nodes-clickhouse-db</strong> - a comprehensive ClickHouse integration for the <a href="https://n8n.io" rel="noopener noreferrer">n8n</a> workflow automation platform.</p> <h2> What is n8n? </h2> <p>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.</p> <h2> Why This Matters for ClickHouse Users </h2> <p>This integration lets you:</p> <ol> <li> <strong>Automate data pipelines</strong> - Pull data from any API and insert into ClickHouse</li> <li> <strong>Build real-time dashboards</strong> - Query ClickHouse and push results to Slack, email, etc.</li> <li> <strong>Event-driven workflows</strong> - Trigger workflows when new data arrives in ClickHouse</li> <li> <strong>AI-powered analytics</strong> - Let LLMs query your ClickHouse data via natural language</li> </ol> <h2> Features </h2> <p><strong>Full CRUD + Schema Operations:</strong></p> <ul> <li>Parameterized queries (<code>{param:Type}</code> syntax)</li> <li>Batch inserts (up to 100k rows per batch)</li> <li>Upsert with ReplacingMergeTree auto-detection</li> <li>Update/Delete with WHERE clauses</li> <li>Create tables with schema inference</li> <li>List databases/tables, get table info</li> </ul> <p><strong>ClickHouse Cloud Native:</strong></p> <ul> <li>HTTPS + port 8443 support</li> <li>JWT Bearer token auth for SSO</li> <li>Tested on ClickHouse 22.x - 26.x</li> </ul> <p><strong>Polling Trigger:</strong></p> <ul> <li>Monitor tables for new rows</li> <li>Track cursor via monotonically increasing columns</li> <li>Custom query mode for complex triggers</li> </ul> <p><strong>Security Hardened:</strong></p> <ul> <li>SQL injection protection with strict validation</li> <li>138 tests including penetration test suite</li> <li>Settings allowlist (53 approved settings)</li> </ul> <h2> Example Use Cases </h2> <ol> <li> <strong>Webhook → ClickHouse</strong>: Receive webhooks and insert events directly</li> <li> <strong>ClickHouse → Slack</strong>: Alert when metrics exceed thresholds</li> <li> <strong>API → Transform → ClickHouse</strong>: ETL from REST APIs</li> <li> <strong>AI Agent</strong>: "Show me the top 10 customers by revenue last month"</li> </ol> <h2> Installation </h2> <p>If you use n8n, install via:<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>Settings → Community Nodes → Install → n8n-nodes-clickhouse-db </code></pre> </div> <h2> Links </h2> <ul> <li> <strong>npm:</strong> <a href="https://www.npmjs.com/package/n8n-nodes-clickhouse-db" rel="noopener noreferrer">https://www.npmjs.com/package/n8n-nodes-clickhouse-db</a> </li> <li> <strong>GitHub:</strong> <a href="https://github.com/sameerdeshmukh/n8n-nodes-clickhouse" rel="noopener noreferrer">https://github.com/sameerdeshmukh/n8n-nodes-clickhouse</a> </li> <li> <strong>n8n:</strong> <a href="https://n8n.io" rel="noopener noreferrer">https://n8n.io</a> </li> </ul> <h2> Roadmap </h2> <p>Planning to add:</p> <ul> <li>Materialized View management</li> <li>Mutations monitoring</li> <li>Part &amp; partition management</li> <li>Dynamic column schema loading</li> </ul> <p>Would love feedback from the ClickHouse community on what features would be most useful!</p> <h1> clickhouse #n8n #automation #etl #analytics </h1> clickhouse