<--- Back to all connectors
DuckDB
Stream data to DuckDB for fast in-process analytics. Real-time CDC to DuckDB files for local analysis and development.
Stream Data to DuckDB
Key Features
- Fast Analytics - Columnar storage optimized for OLAP queries
- Zero Dependencies - Embedded database with no server required
- SQL Compatible - Full SQL support with extensions
- Exactly-once Delivery - Guaranteed data consistency
How It Works
Streamkap streams CDC events directly to DuckDB:
- Changes are captured from your source database
- Events are transformed and written to DuckDB
- Data is immediately available for querying
- Schema changes are handled automatically
Getting Started
- Configure your DuckDB database file location
- Set up authentication if using MotherDuck
- Select the tables you want to sync
- Start streaming data to DuckDB
Supported Features
- DuckDB 0.8+
- Local DuckDB files
- MotherDuck cloud
- Parquet export
- S3, GCS integration
Why Streamkap?
Reliable
Serverless platform providing enterprise reliability and scale.
Affordable
Only pay for GB into Streamkap.
Longterm
Retain data for as long as you need.
Flexible
Read once, write to many destinations.
