open source

Open Source Headless BI

Consume data from any data source, organize it into consistent metrics, and use it with every app.

Coupang logo
Cota logo
Cyndx logo
Jobber logo
IBM logo
Intuit logo
Telstra logo
Walmart logo
With over 13,000 stars on GitHub, Cube is trusted by Fortune 500 companies and startupsRead all user stories →

Cube: API-First Business Intelligence

Cube is an API‑first business intelligence platform for data engineers and application developers to make data accessible and consistent across every application.

What is Headless BI?

Define a data model, manage security and multitenancy, accelerate your queries, and expose data to your applications via SQL, REST, and GraphQL APIs.

Data Model
cube(`ActiveUsers`, {
  sql: `SELECT user_id, timestamp from events`,

  measures: {
    weeklyActive: {
      sql: `user_id`,
      type: `countDistinct`,
      rollingWindow: {
        trailing: `7 day`,
        offset: `start`,
      },
    },
  },

  dimensions: {
    time: {
      sql: `timestamp`,
      type: `time`,
    },
  },
});

Data Modeling

Centrally‑managed definitions ensure every user gets uniform insights instead of inconsistent signals.

Learn about defining a data model.

Access Control

Cube coordinates access control upstream of data applications, so that the right people have access to the right metrics.

Learn about implementing access control.

Caching

Store query results to prevent identical queries from increasing the load on your data warehouse, and implement aggregate awareness to find the smallest, most efficient table to serve every query.

Learn about pre-aggregations.

Instant APIs

Integrate with data visualization tools and business intelligence dashboards, and bind to popular front‑end frameworks to power custom interfaces.

Learn about supported REST, GraphQL, and SQL APIs.

SELECT
  date_trunc('day', time) as day,
  MEASURE(weeklyActive)
FROM ActiveUsers
WHERE time >= '2021-01-01' AND time < '2021-01-07'
GROUP BY day

Ship faster

Save time, complexity, and development costs.

Performance
Build new data apps in hours instead of weeks
Infrastructure
Automate API development work
Organization
Leverage optimized infrastructure
Jobber

Cube really stood out as a great fit for our use case. We were able to level‑up our data infrastructure without needing to build a full‑blown and expensive data pipeline.

Photo of Jc Weinrich

Jc Weinrich

Architect

NearSt

Cube helped us reduce response times 100x and increase the amount of information we could display on our customer facing dashboards.

Photo of Thomas Ankcorn

Thomas Ankcorn

Technical Lead

Premise

Cube is an API that's built already. We’re not starting from scratch. Otherwise we’d be building an HTTP layer and abstraction over SQL.

Photo of Craig Beck

Craig Beck

Software Engineer

Simon

We can develop and ship analytics products without dealing with any net new infrastructure development going forward. Our efforts are focused on what matters: the data and the UI.

Photo of Louis Zuckerman

Louis Zuckerman

Staff Software Engineer & Team Lead

ShopBack

Cube provides us with the framework and tools to build our custom data visualization platform with minimal effort. Our full‑stack developers are able to get productive quickly, optimizing performance wherever possible.

Photo of David Chua

David Chua

Senior Engineering Manager

Gadsme

Cube was the perfect tool to ease iterations around how insights can be exposed to our clients. Now all our dashboards and reporting use Cube.

Photo of Luc Vauvillier

Luc Vauvillier

Chief Operating Officer

Join the Cube community

Open source

200+ contributors and 13.0k stars on GitHub

Vibrant community

4,000+ members on Slack

Get Cube updates to your inbox

Stay up to date with the latest features and changes to Cube

Start using Cube

Fully managed hosting of your Cube apps

Get Started

Open‑source analytics API

Run Locally