cube-js/cube

📊 Cube Core is open-source semantic layer for AI, BI and embedded analytics

What it solves

Cube Core provides a standalone, open-source semantic layer that decouples business logic (metrics, dimensions, and joins) from the data source and the visualization tool. This prevents the need to re-implement the same metrics and logic across multiple BI tools, custom applications, or AI agents, ensuring a single source of truth for data definitions.

How it works

Cube Core acts as a headless engine that connects to any SQL data source (such as Snowflake, BigQuery, Databricks, Postgres, Presto, or Amazon Athena). It allows users to define their data model in code, and then exposes these definitions through SQL, REST, and GraphQL APIs. To ensure high performance and sub-second latency, it includes a built-in relational caching engine.

Who it’s for

Developers building custom analytics experiences, teams implementing embedded analytics, and developers creating AI agents that require a governed, consistent semantic foundation for querying data.

Highlights

  • Headless Architecture: No built-in UI, allowing developers to build their own custom analytics surfaces.
  • Multi-API Support: Exposes data via SQL, REST, and GraphQL APIs.
  • Cachable: Built-in relational caching engine for high concurrency and low latency.
  • Universal SQL Compatibility: Works with all SQL data sources and cloud data warehouses.
  • AI-Ready: Designed to be consumed by AI agents as a governed semantic layer.

Related

  • Project
    spiculedata/saiku

    An open-source semantic layer for analytics that enables drag-and-drop data exploration and provides a typed API for AI agents to query data cubes without writing MDX.

  • Project
    open-metadata/OpenMetadata

    An open-source context layer and metadata management platform that provides AI agents and users with the governed business semantics, lineage, and organizational memory needed to trust and use enterprise data.

  • Project
    Azure-Samples/AI-Gateway

    An enterprise-grade AI Gateway framework powered by Azure API Management that provides centralized security, cost control, and observability for managing AI models, tools, and agents.

  • Project
    datahub-project/datahub

    An open-source AI data catalog and metadata platform that enables data discovery, governance, and observability across fragmented data ecosystems.

  • Project
    Kaelio/ktx

    A self-improving context layer that teaches AI agents how to query SQL warehouses accurately using approved metric definitions and business knowledge.