Cubes
Cubes: An open-source Python toolkit for embedding multidimensional OLAP in applications. Ranked #31 of 33 in OLAP Software by our editors (6.2/10); pricing: Free plan; best for developers building a lightweight relational OLAP API.
At a glance
- Editor score6.2 / 10
- PricingFree plan
- Best forDevelopers building a lightweight relational OLAP API
- Free planYes
- Paid fromFree
- DeploymentSelf_hosted
- Facts checked24 Sep 2026

Where it wins
- Multidimensional cubes support hierarchies, slicing, dicing and drill-down
- SQLAlchemy backend supports multiple relational database backends
- Built-in WSGI server exposes OLAP functions through a JSON API
Where it doesn't
- Self-hosted deployment puts operation and integration work on your team
- Designed for embedded applications rather than standalone end-user BI
- No built-in AI features are included
Our verdict on Cubes
Cubes is an open-source Python framework and toolkit for developers building reporting and analytical applications. It models data as cubes containing facts, measures, dimensions and hierarchies, making it suited to teams that want to add relational OLAP capabilities inside their own software rather than deploy a standalone business-intelligence product. The framework supports small, mid-market and enterprise use cases, with self-hosted deployment and an API-oriented platform.
Its core strength is the depth of its multidimensional model. Hierarchical dimensions can contain multiple hierarchies, while aggregation browsing, slicing and dicing, and drill-down support common analytical navigation patterns. The built-in relational OLAP backend uses SQLAlchemy and supports multiple database backends and data sources in a workspace. Supported relational systems include Drizzle, Firebird, Informix, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite and Sybase. A WSGI HTTP OLAP server provides a JSON API, and localization, formatters and command-line tools extend the application toolkit.
Cubes also includes configurable authentication and authorization, including cube-level and cell-based restrictions, which can help developers define access within embedded analytical experiences. The trade-off is operational and product scope: deployment is self-hosted, so the implementing team owns integration and runtime management, while support is centered on documentation. Because Cubes is intended to be integrated into applications, organizations seeking a ready-to-use end-user BI environment or broader platform ecosystem should consider a different category fit. Choose Cubes when a Python-based, relational OLAP API is the priority; avoid it when turnkey analytics or built-in AI capabilities are requirements.
Your product? Our editors can test Cubes in depth and publish a review, labelled as paid · from $149/mo →
Cubes pricing
Cubes fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Deployment | Self_hosted |
| Query language | Sql |
| Real-time ingestion | Not verified |
| Row-level security | Not verified |
| Embedded analytics | Not verified |
| Included users | Not verified |
| Data source coverage | Relational databases supported by SQLAlchemy: Drizzle, Firebird, Informix, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, Sybase |
| Deployment | Self-hosted |
| Support | Docs |
| Built for | Small business, Mid-market, Enterprise (editorial estimate) |
| Pricing | Free plan |
| Website | cubes.readthedocs.io |
| Facts checked | 24 Sep 2026 |
Alternatives to Cubes
- Google BigQueryA serverless warehouse with separate storage and compute, streaming, ML, and governance.9.4
- Amazon RedshiftA broad AWS-native warehouse for teams balancing SQL analytics, lakes, streaming, and ML.9.3
- Databricks SQL WarehouseA usage-based SQL warehouse for lakehouse analytics, BI, governance, and incremental ETL.9.2
Used Cubes? 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 Cubes 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
Cubes is listed in our OLAP Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/cubes/"><img src="https://www.itechguides.com/best/badge/cubes.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


