A CLI tool to copy data between any databases and platforms with a single command, no code required.
ingestr is a command-line tool that enables seamless data copying between any databases and platforms without writing any code. It solves the problem of complex data ingestion by providing a simple, unified interface to move data from sources like Postgres, BigQuery, or Notion to destinations such as data warehouses or other databases. The tool abstracts away backend management and scripting, making data transfers quick and accessible.
Data engineers, analysts, and developers who need to move data between systems without building custom pipelines or managing infrastructure. It's ideal for teams looking for a lightweight, no-code solution for data integration tasks.
Developers choose ingestr for its simplicity and broad compatibility—it supports numerous sources and destinations out-of-the-box with a single command. Unlike complex ETL tools, it requires no configuration or coding, reducing setup time and operational overhead while leveraging reliable underlying libraries like SQLAlchemy and dlt.
ingestr is a CLI tool to copy data between any databases with a single command seamlessly.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Supports over 30 sources including databases like Postgres and BigQuery, and SaaS platforms like Stripe and Notion, with many also usable as destinations, as shown in the detailed compatibility table.
Executes data transfers with a single CLI command, eliminating the need for scripting or infrastructure management, as emphasized in the README's 'no code necessary' philosophy.
Offers append, merge, or delete+insert methods for efficient data updates, allowing partial syncs without full reloads, which is highlighted in the key features.
Quick setup via uv or pip, with the README recommending uv for faster installation and noting that vanilla pip is slower but still possible.
Key sources like MySQL, Oracle, and SQLite are only supported as sources, not destinations, restricting use cases that require writing data back to these systems.
As an opinionated wrapper around SQLAlchemy and dlt, it prioritizes simplicity over flexibility, offering few options for customizing ingestion logic or handling edge cases.
Relies heavily on SQLAlchemy and dlt for connectivity, so updates or bugs in these dependencies could impact stability and require workarounds for specific integrations.