
AppSheet
Build apps without code.

The Universal Semantic Layer for AI and Data Applications.

Cube is the industry-leading universal semantic layer designed to bridge the gap between complex data sources and downstream applications, including BI tools, customer-facing dashboards, and Large Language Models (LLMs). Technically, Cube centralizes data modeling, access control, and caching into a unified middleware layer. Its core architecture consists of the Cube Store—a purpose-built, high-performance columnar storage engine—and a multi-protocol API (SQL, REST, GraphQL) that ensures consistency across all consumers. In the 2026 landscape, Cube has pivoted heavily toward 'Semantic Layer for AI,' providing the deterministic context necessary for LLMs to query structured data without hallucinations. By defining metrics, dimensions, and joins in a code-first environment (YAML or JavaScript), organizations can ensure that an AI agent and a human-led dashboard retrieve the exact same revenue or churn figures. Cube’s ability to handle complex pre-aggregations and multi-tenant security at scale makes it the standard for enterprises building RAG-based data agents and real-time analytical products. It supports all major cloud data warehouses including Snowflake, BigQuery, Databricks, and Athena.
Cube is the industry-leading universal semantic layer designed to bridge the gap between complex data sources and downstream applications, including BI tools, customer-facing dashboards, and Large Language Models (LLMs).
Explore all tools that specialize in data modeling. This domain focus ensures Cube delivers optimized results for this specific requirement.
Explore all tools that specialize in integrate data sources. This domain focus ensures Cube delivers optimized results for this specific requirement.
A purpose-built columnar storage layer for caching and pre-aggregations, using Rust and Arrow.
Exposes metadata and schema definitions as context for LLMs to generate accurate SQL.
Provides SQL, REST, and GraphQL endpoints simultaneously for the same data model.
Automatic background refreshing of data summaries based on defined intervals or triggers.
Allows generating data models dynamically based on the security context or tenant ID of the user.
Version control for data models with support for branching and PR-based deployments.
Row-level and column-level security defined at the semantic level.
Install the Cube CLI globally via npm: npm install -g cubejs-cli.
Initialize a new project: cube create <project-name> -d <database-type>.
Configure environment variables in the .env file for database connectivity (Host, Port, User, Password).
Generate initial data schema files automatically from database tables: cube generate-schema.
Define measures (e.g., sum of sales) and dimensions (e.g., product category) within the YAML/JS files.
Implement Join logic between disparate tables within the semantic layer to avoid complex SQL in the frontend.
Configure Pre-aggregations in the Cube Store to optimize query performance for massive datasets.
Start the Cube development server locally to test queries via the Playground UI.
Deploy the Cube instance to Cube Cloud or a self-hosted Docker/Kubernetes environment.
Connect downstream consumers (React/Vue app, Tableau, or LLM agents) via the SQL or REST API.
All Set
Ready to go
Verified feedback from other users.
"Users praise Cube for its ability to turn slow data warehouses into high-performance APIs, though some find the learning curve for data modeling slightly steep."
Post questions, share tips, and help other users.

Build apps without code.

dbt empowers data teams to deliver reliable, governed data faster and at scale.

Connect spreadsheets to live data sources to build data apps and automate reporting without code.

Build mission-critical internal tools with the power of high-code and the speed of low-code.

The unified MQTT platform for software-defined vehicles, AI, and IoT data streaming.

End-to-end ELT platform with built-in transformations for analytics-ready data.

The spreadsheet agent for GTM, connecting directly to your data sources for real-time revenue insights and GTM clarity.