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 from the data source and the visualization tool. It prevents the need to re-implement metrics and dimensions across multiple BI tools, custom applications, or AI agents, ensuring a single source of truth for data definitions.

How it works

Users define metrics, dimensions, joins, and access rules in code. Cube Core then exposes these definitions through SQL, REST, and GraphQL APIs. It connects to various SQL data sources (such as Snowflake, BigQuery, Databricks, and Postgres) and includes a built-in relational caching engine to ensure sub-second latency and high concurrency for API requests.

Who it’s for

Developers building custom BI experiences, teams implementing deeply integrated embedded analytics, or those creating AI agents that require a governed semantic foundation for data access.

Highlights

  • Headless Architecture: No built-in UI, allowing developers to build their own analytics experience.
  • Broad Compatibility: Works with all SQL data sources and cloud data warehouses.
  • Broad API Support: Exposes data via SQL, REST, and GraphQL.
  • Caching Engine: Built-in relational caching for high-performance API requests.

Related

  • Project
    Canner/WrenAI

    An open-source generative BI engine that provides a governed semantic layer for AI agents to turn business questions into correct SQL and deployable dashboards.

  • Project
    spiculedata/saiku

    An open-source semantic layer for analytics that provides a drag-and-drop UI and a typed AI Query API for LLM agents to interact with data cubes.

  • 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 understand and trust enterprise data.

  • Project
    alibaba/UnifiedModel

    UModel (Unified Model) is an open‑source, vendor‑neutral runtime that lets enterprises describe data, services, and infrastructure as a semantic graph. It provides model packs, a workspace‑scoped graph, unified query APIs, a web UI, CLI, and SDKs, and includes AgentGateway/MCP so LLM agents can discover, query, and act on the graph for tasks like root‑cause analysis.

  • Project
    pipeshub-ai/pipeshub-ai

    PipesHub is an open‑source, self‑hostable platform that connects enterprise data sources (Slack, Google Drive, GitHub, etc.) to AI applications. It builds a permission‑aware knowledge graph, stores vector embeddings, and lets any LLM generate explainable answers with citations. The project includes Docker‑Compose deployment, a no‑code agent builder, MCP support, and SDKs for Python, TypeScript, and Go.