CLICKHOUSE INTEGRATION

Real-Time CDC to ClickHouse

Stream database changes to ClickHouse with native ReplacingMergeTree support. Automatic deduplication, no duplicate rows, and sub-second analytical queries out of the box.

Stream to ClickHouse Free

Read ClickHouse Docs

Native ClickHouse Integration

Purpose-built for ClickHouse's columnar analytics engine

ReplacingMergeTree Support

Native support for ClickHouse's ReplacingMergeTree engine—efficient upserts without duplicate rows.

Sub-Second Ingestion

High-throughput streaming optimized for ClickHouse's columnar storage.

Automatic Schema Management

Schema changes handled automatically with DDL synchronization.

Insert & Upsert Modes

Choose append-only for event logs or upsert for maintaining current state.

ClickHouse Cloud Ready

Works with ClickHouse Cloud and self-hosted clusters.

Materialized Views

Automatic materialized view creation for faster analytical queries.

What You Can Build

Real-time e-commerce analytics

Fraud detection and risk scoring

Customer behavior analysis

IoT and time-series analytics

Log and event analytics

How It Works

Streamkap captures changes from your source databases using CDC and streams them directly to ClickHouse with optimized batch inserts for maximum analytical performance.

1. Capture: CDC captures changes from PostgreSQL, MySQL, MongoDB, and more
2. Transform: Apply SQL transforms, filtering, and masking in-flight
3. Load: ReplacingMergeTree upserts for efficient CDC synchronization

Source DB PostgreSQL, MySQL, etc.

→

Streamkap CDC + Transform

→

ClickHouse ReplacingMergeTree