Duckle is a local-first, open-source desktop ETL/ELT studio that runs pipelines on DuckDB with an on-device AI assistant. It ships a single-file ~65 MB binary and claims 370+ components, on-device AI, and no cloud dependency.
Collecting history — the radar snapshots this repo daily. The trend line appears after 3 days of data (2 so far).
What it is
Duckle is an open-source desktop ETL / ELT studio. It runs pipelines locally on the user’s machine, compiling the graph to SQL and executing via DuckDB. It provides a built-in AI assistant (Duckie) that operates entirely on-device to generate pipeline definitions from plain English. The project claims 370+ components and a self-contained binary delivery.
How it works
Pipelines are built by dragging sources, transforms, validators, and sinks onto a canvas. The AI assistant describes the desired pipeline in English, generates a JSON pipeline, and inserts it into the canvas for execution. The core execution is performed through DuckDB, with live previews and generated SQL per node. The app is described as a single-file binary (~65 MB) that downloads DuckDB on first launch and stores workspaces as plain files in a user-chosen folder. The UI and components support local-first operation with no cloud telemetry.
Getting started
- The README presents a Quick Start section and mentions build/run steps, install, and build-from-source workflows. It also notes Duckie runs locally with an on-device model and supports bringing-your-own-model for Duckie via an OpenAI-compatible HTTP interface. Exact install/run commands are to be taken from the repository, including the Quick Start guidance and build instructions in the README and docs.
Recent releases
Latest release: v0.5.6 (2026-07-20). Highlights include real-time WebSocket connectors, geospatial projection toolkit, streaming XML at multi-GB scale, and a local-time cron scheduler. Notable items in prior releases include Salesforce write-back sink, in-database SQL pushdown, geometry data-quality tools, SAP connectivity, and various reliability fixes across v0.5.2–v0.5.5.
Traction
- Stars: 833
- Forks: 58
- Open issues: 55
Behind the repo
Duckle is an independent open-source project by SlothFlowLabs. It builds on the DuckDB engine but is not part of, affiliated with, or endorsed by DuckDB Labs or MotherDuck.
Caveats
- License: MIT OR Apache-2.0.
- Created: 2026-05-21; Last push: 2026-07-20.
- Status: public beta with a catalog described as 363 nodes (356 available today, 3 preview, 15 planned).
- Platform support includes Windows, macOS, and Linux.
- Development language: Rust; UI stack includes Tauri, React, TypeScript; engine: DuckDB embedded.