Airbyte solved a tedious problem well: a large catalog of connectors that pull from SaaS apps and databases and land the data in your warehouse, with the extract-and-load plumbing handled for you. For getting sources flowing quickly it is a strong default. The reasons people look further tend to be weight and reach - the platform is a substantial stack to operate, and the cloud offering meters what you sync, so a pipeline that should be simple infrastructure starts feeling like its own product to run and pay for.
The lighter open source alternatives below move the same source-to-warehouse data without the heavy footprint. They define syncs as code or config you keep, run as a single process or job rather than a sprawling deployment, and put no volume meter between your sources and your destination. The connectors stay yours to extend, and the whole pipeline runs on infrastructure you already manage.
Prefect is a workflow orchestration framework for building resilient data pipelines in Python. With a few lines of code it turns ordinary scripts into production workflows, giving data teams scheduling, caching, retries, and event-based automations.
Dagster is a cloud-native data pipeline orchestrator for developing and maintaining data assets such as tables, data sets, machine learning models, and reports. It helps teams define what data should exist, run it at the right time, and keep it up to date across local development through production.
Mage OSS is a self-hosted development environment for building and running data pipelines locally. It is aimed at ETL, data flow design, and transformation work, with a fast, modular notebook-style interface for teams that want production-grade pipelines on their own machine.
CloudQuery is a cloud asset inventory for platform teams. It syncs cloud infrastructure metadata into your data warehouse, unifying configuration data across AWS, Azure, GCP, and 70+ cloud and SaaS sources such as Wiz, Finout, and GitHub. From there you can build asset inventory, CSPM, and FinOps workflows in one place.
dlt is an open-source Python library for loading data from messy sources into structured datasets. It fits into notebooks, AWS Lambda, Airflow DAGs, local laptops, and other Python environments, so you can build data pipelines where you already work.
Meltano is a declarative, code-first data integration engine for building data platforms and running data workflows across multiple tools. It is aimed at teams that want to stop writing, maintaining, and scaling custom API integrations by hand.
Sling is a free, open-source CLI for moving data with the Extract and Load (EL) approach. It is built for small to medium volume pipelines and handles database to database, file system to database, database to file system, and API based movement in either direction.
