Ibis
Ibis: A code-first choice for portable Python transformations across SQL systems. Ranked #15 of 36 in Data Transformation Tools by our editors (7.8/10); pricing: Open source; best for python transformations across SQL backends.
At a glance
- Editor score7.8 / 10
- PricingOpen source
- Best forPython transformations across SQL backends
- Paid fromFree
- Deployment modelSelf_hosted
- Facts checked22 Sep 2026
Where it wins
- Lazy Python expressions compile into backend-native SQL.
- Mixes Python dataframe code with SQL in one workflow.
- Supports SQL backends, dataframe objects, and common file formats.
Where it doesn't
- Requires a code-based workflow rather than a visual interface.
- Self-hosted deployment places environment management with the team.
- Portability depends on the connected backend and its capabilities.
Our verdict on Ibis
Ibis is an open-source Python dataframe library for transforming, analyzing, and preparing data across multiple execution backends. It is aimed at data practitioners and library developers who want a common interface for database tables, local files, and dataframe objects. Its lazy table expressions defer execution, while the dataframe-style API covers joins, aggregation, filtering, casting, and deduplication. Ibis can also convert results to pandas, PyArrow, and Python data structures.
The main fit is cross-backend transformation work. Ibis compiles expressions into backend-native SQL or dataframe operations and allows Python and SQL code to be mixed directly. That combination can help teams keep transformation logic in Python while still targeting SQL systems and other dataframe backends. File support includes CSV, TSV, JSON, Parquet, Delta Lake, and Avro, with reading and writing available for CSV, JSON, Parquet, and Delta Lake. The result is a broad interface for table operations rather than a tool centered on one file type or execution environment.
Ibis is self-hosted and code-based, so it suits teams comfortable managing their own runtime and expressing transformations programmatically. It is a practical choice when portability, deferred execution, and backend-native compilation matter more than a visual workflow. Teams looking for a hosted transformation product, a point-and-click interface, or a narrowly focused file conversion utility should choose an alternative. Ibis is most appropriate for Python-led analytics workflows that need to move transformation logic across SQL and dataframe backends while retaining access to familiar table operations.
Your product? Our editors can test Ibis in depth and publish a review, labelled as paid · from $149/mo →
Ibis pricing
Ibis fact sheet
| Free plan | Not verified |
|---|---|
| Paid from | Free |
| Deployment model | Self_hosted |
| Transformation interface | Code |
| Supported data formats | CSV, TSV, JSON, Parquet, Delta Lake, Avro |
| Version control | Not verified |
| Workflow orchestration | Not verified |
| Data quality checks | Not verified |
| Deployment | Self-hosted |
| Support | Community, Docs |
| Built for | Solo, Small business, Mid-market, Enterprise (editorial estimate) |
| Pricing | Open source |
| Website | ibis-project.org |
| Facts checked | 22 Sep 2026 |
Alternatives to Ibis
- DataformA free, managed workflow service for SQL transformation and testing in BigQuery.9.2
- Alteryx DesignerA broad visual toolkit for enterprise analysts working across complex data environments.9.1
- Apache BeamA broad, portable framework for engineering teams building code-driven data pipelines.9.0
Used Ibis? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Ibis for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Ibis is listed in our Data Transformation Tools directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/ibis/"><img src="https://www.itechguides.com/best/badge/ibis.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update