Duckle docs
Duckle is an open-source, local-first ETL / ELT studio. Build pipelines visually, run them at native speed on DuckDB, and ship them as plain files. This is everything you need to go from download to a scheduled production pipeline.
Explore
Getting started
Download, install the DuckDB engine on first launch, and build + run your first source → transform → sink pipeline.
Component reference
All 329 components: 104 sources, 128 transforms, 59 sinks, 12 quality validators, 19 control-flow nodes, 7 code runners.
Integrations directory
Every connector by category - files, databases, warehouses, object stores, streaming, SaaS, NoSQL and vector DBs.
Duckie AI
The on-device assistant, the six AI transforms, and how to clean data before it reaches your models.
Scheduling, MCP & deploy
Cron / interval / file-watch schedules, the MCP server for Claude and other LLMs, connections, contexts, and headless server deployment.
Learn hub
Concepts and guides: ETL vs ELT, change data capture, local-first architecture, RAG, and migration from other tools.
What is Duckle?
A visual data pipeline studio that runs on your laptop. Drag sources, transforms, validators and sinks onto a canvas, wire them, and press Run. Duckle compiles the graph to SQL and executes it through DuckDB - a real columnar engine - with live previews, generated SQL on every node, and zero hidden state.
- An AI assistant in the box. Describe a pipeline in English; Duckie writes the JSON and drops it on the canvas. The model runs locally - no API key, no telemetry.
- 329 components at install time. Files, lakehouses, SQL databases, warehouses, NoSQL, vector DBs, streaming brokers, SaaS APIs, FTP and IMAP - working today.
- A self-contained binary you can audit. ~65 MB download; engines install on first launch; workspaces are plain files in a folder you choose.
Built on DuckDB
Every pipeline runs through DuckDB - vectorized, columnar, local. Duckle reads the wider DuckDB family natively: DuckLake tables, MotherDuck, the Quack remote protocol, and the community extensions (httpfs, postgres, iceberg, delta, vss, fts, and more). Duckle is an independent, open-source project by SlothFlowLabs and is not part of, affiliated with, or endorsed by DuckDB Labs or MotherDuck.