
duckle
Open-source ETL/ELT you deploy on your own servers or cloud. Built on DuckDB: no-code/low-code visual pipelines or SQL, 385 components, dbt, CDC, data quality, reverse ETL, lineage, MCP for AI agents. No vendor cloud, no per-row billing.
The Lens
By Erik Loyd, SaaS CEO and former COO/CFO of an AWS Premier Partner.
Updated Sep 2026
Duckle moves data between systems and does it on hardware you control. Pull from Postgres, land it in Parquet, transform it with SQL or Python, push it to a warehouse: the same job people currently pay Fivetran or Airbyte per row to run. It compiles to SQL on DuckDB and uses every core on the box, so a bigger instance is a faster pipeline. The project reports 96 million rows out of Postgres to Parquet in 39.9 seconds. Dual licensed MIT or Apache 2.0, and there is no vendor cloud at all.
Every pipeline is one file in git, which is the design decision that matters most. Author it on a visual canvas, in SQL, or in Python, then ship that file to your own server. `duckle-runner serve` runs it headless on a schedule in Docker or on a plain box, with a web console, roles, and an audit trail. Around 385 components cover the usual sources and destinations, plus dbt, CDC, data quality, reverse ETL, and lineage.
Nothing is paywalled. No per-row billing, no per-connector fee, no seat count, no account, no telemetry. Solo and small teams get the whole thing. Larger teams get it too, and pay only for the compute they were going to buy anyway. Compare against Airbyte (airbytehq/airbyte) if you want a bigger connector catalog, or dlt (dlt-hub/dlt) if you would rather write pipelines as plain Python.
The catch is that it is still labelled beta and it is young. A single-file-in-git pipeline is a great story right up until you need a connector that is not in the 385, and then you are writing it yourself against a project whose API has not settled.
Free vs Self-Hosted vs Paid
fully freeFree (Open Source)
- Dual licensed MIT OR Apache 2.0, the entire platform
- Visual canvas, SQL and Python authoring, roughly 385 source and destination components
- dbt integration, CDC, data quality checks, reverse ETL, column lineage, MCP endpoint for AI agents
duckle-runner servefor headless scheduled execution in Docker or on a VM- Web console, role-based access, audit trail
- No account, no telemetry, no registration
Paid
None. There is no cloud tier, no enterprise SKU, and no per-row, per-connector or per-seat billing. The project explicitly rules all of it out.
Self-Hosted Costs
Your only bill is the machine. Because it compiles to SQL on DuckDB and saturates every available core, cost scales with instance size rather than row count: a $40 to $150 per month VM handles workloads that would run into four figures monthly on usage-priced managed ETL. Add object storage for landed Parquet. Budget engineer time for upgrades and for writing any connector outside the bundled set.
When to Pay
There is nothing to buy. The trade you are making is money for ownership: you take on patching, monitoring and connector gaps in exchange for a bill that does not move when your row count triples.
Completely free and open source under MIT or Apache 2.0. No cloud tier, no per-row billing, no seats. You pay only for the box it runs on.
What to do by team size
- Solo
- free; a laptop or a small VM runs real pipelines
- Small team
- free; one VM plus object storage covers most workloads
- Medium team
- free, but budget engineer time for connector gaps and upgrades
- Large team
- free; the cost moves to compute and on-call, not licensing
Get tools like this every Wednesday
One featured tool, three on the radar. No fluff.
Similar Tools

Orchestration platform for data assets

Data transformation using software engineering practices

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.

data load tool (dlt) is an open source Python library that makes data loading easy 🛠️

Build data pipelines with SQL and Python, ingest data from different sources, add quality checks, and build end-to-end flows.
A low score is not a verdict on quality. Young and niche tools start low by design. How we calculate scores
Trust Signals
License: Apache License 2.0
Use freely. Patent grant included.
Commercial use: ✓ Yes
About
- Owner
- SlothFlowLabs (Organization)
- Stars
- 1,254
- Forks
- 94
Explore Further
More tools in the directory
everything-claude-code
The agent harness performance optimization system. Skills, instincts, memory, security, and research-first development for Claude Code, Codex, Opencode, Cursor and beyond.
245.9k ★dify
Production-ready platform for agentic workflow development.
154.1k ★cc-switch
A cross-platform desktop All-in-One assistant tool for Claude Code, Codex, OpenCode, openclaw & Gemini CLI.
130.6k ★