Cube.js REST API

Name: Cube.js REST API
Brand: Cube.js REST API
Availability: InStock

✓ Official Vendor SpecAnalyticsBusiness Intelligencebearer2 EndpointsREST

For Agents

Run aggregated analytical queries against a Cube semantic layer and read the data model so an AI agent can answer business questions over a warehouse without writing SQL.

Install Jentic One Beta

Connect the Cube.js REST API to your agent

Jentic One is a self-hosted execution layer for AI agents. It lets your agent call the Cube.js REST API, or any other public or private API you need. You set the rules, the agent never sees your credentials, and every call is logged.

Two steps, two machines. Install the instance in a safe environment, then register your agent from wherever it runs.

Step 1: Jentic One Host machine

# On the machine that will host your Jentic One instance:
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh

Step 2: Agent machine

# On the machine where your agent runs (keep this separate from the instance):
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh
jentic register       # connects your agent to your Jentic One instance

Jentic One is in public beta. The setup above keeps your agent separate from the instance, which is what you want before using real credentials: an agent running as the same OS user as Jentic One can read its stored keys directly. Just evaluating? A single local install is fine to start. See the secure deployment guide for the tiers.

Capabilities

What an agent can do with Cube.js REST API.

Run aggregated analytical queries via POST /v1/load using a Cube JSON query body

Read the available cubes, measures, dimensions, and segments via GET /v1/meta

Filter results by time dimension granularity such as day, week, or month

GET STARTED

Start building with Cube.js REST API

Explore with Jentic

View OpenAPI Document

The Cube.js REST API exposes a deployed Cube semantic layer over a customer's data warehouse, returning analytical query results and metadata about the available data model. The /v1/load endpoint accepts a Cube JSON query describing measures, dimensions, time dimensions, filters, and segments, and returns the aggregated rows along with the SQL that was generated. The /v1/meta endpoint returns the cubes, measures, dimensions, and segments defined in the data model so a client can build query UIs or expose the model to an LLM. Authentication is via a JWT bearer token signed with the Cube deployment's API secret.

Use Cases

Patterns agents use Cube.js REST API for, with concrete tasks.

★ Natural Language Analytics over a Warehouse

An analytics chatbot can use the /v1/meta endpoint to learn the customer's Cube data model and then construct a Cube JSON query and call /v1/load to answer business questions. Because Cube enforces measures, dimensions, and security context server-side, the agent cannot accidentally write a join that returns ungoverned data. Build it once and the same agent works across BigQuery, Snowflake, Postgres, and other warehouses behind Cube.

Call GET /v1/meta to fetch measures and dimensions, then POST /v1/load with a Cube JSON query for measures Orders.count grouped by Orders.status for the last 30 days.

Embedded Analytics Dashboards

A SaaS product can fetch the Cube data model with /v1/meta to render an interactive query builder and submit user-built queries via /v1/load. Cube's row-level security uses the JWT security context, so dashboards can be embedded per tenant without exposing other customers' data. Suitable for B2B products that want self-serve charts without building a SQL editor.

Sign a JWT with the tenant ID claim, call GET /v1/meta, render a chart configuration, then POST /v1/load with the user-selected measures and dimensions.

Scheduled Metric Reporting

A reporting agent can run a fixed set of Cube queries on a schedule and post results to Slack or email. Each metric is a single POST /v1/load call against a stable measure such as Revenue.total, so the agent only needs the Cube secret to sign a JWT and the metric definitions. Useful for executive digests where the metric set rarely changes.

Sign a JWT for a reporting role and POST /v1/load with measures Revenue.total grouped by week for the last quarter, then post the result to Slack.

AI Agent Integration via Jentic

An AI agent that needs to answer warehouse questions can discover the Cube REST API through Jentic and run /v1/meta and /v1/load without hand-writing the integration. Jentic stores the Cube API secret and the host of the deployment so the agent works across environments without touching credentials directly.

Use Jentic search for 'run an analytics query on a Cube semantic layer', load the /v1/load schema, and execute it with a Cube JSON query.

Key Endpoints

2 endpoints — the cube.

METHOD

PATH

DESCRIPTION

POST

/v1/load

Run a Cube JSON query and return aggregated rows

GET

/v1/meta

Return the data model metadata

POST

/v1/load

Run a Cube JSON query and return aggregated rows

GET

/v1/meta

Return the data model metadata

Why Jentic?

Three things that make agents converge on Jentic-routed access.

Credential isolation

Cube's API secret is stored encrypted in the Jentic MAXsystem vault. Jentic mints a short-lived JWT per call with the agent's security context, so the raw secret never appears in prompts, logs, or tool outputs.

Intent-based discovery

Agents search Jentic by intent (for example 'run an analytics query on a Cube semantic layer') and Jentic returns the /v1/load and /v1/meta operations with their input schemas, so the agent can construct Cube JSON queries without reading the Cube docs.

Time to first call

Direct integration takes one to two days to handle JWT signing, security context, and Cube JSON query construction. Through Jentic the integration is under 30 minutes because Jentic owns the JWT and exposes the operations as tools.

FAQs

Specific to using Cube.js REST API through Jentic.

What authentication does the Cube.js REST API use?

Cube uses a JWT bearer token signed with the deployment's API secret, sent in the Authorization header as Bearer <jwt>. Through Jentic the secret is stored encrypted in MAXsystem and Jentic mints a short-lived JWT per call so the raw secret never enters the agent's prompt.

Can I run a SQL query directly with the Cube.js REST API?

Not directly. The Cube REST API takes a Cube JSON query that references measures and dimensions defined in the semantic layer, and Cube generates and runs the SQL. Use POST /v1/load with measures, dimensions, timeDimensions, and filters in the body.

What are the rate limits for the Cube.js REST API?

Rate limits depend on the Cube Cloud plan or the resources of the self-hosted deployment, not on a fixed limit in the spec. Cube returns 429 if the deployment is overloaded, and you can use the security context to throttle per tenant.

How do I run an analytical query with the Cube.js REST API through Jentic?

Run pip install jentic, search Jentic for 'run an analytics query on a Cube semantic layer', load the schema for /v1/load, and execute it with a Cube JSON query body. Jentic signs the JWT against your stored Cube secret so the agent does not handle the secret directly.

How do I list available measures and dimensions?

Call GET /v1/meta. It returns each cube along with its measures, dimensions, segments, and time dimensions, which is what an AI agent needs to construct a valid /v1/load query body without inspecting the data model files.

Is the Cube.js REST API free?

Cube Core is open source and free to self-host, so the REST API is free in that deployment. Cube Cloud has paid tiers based on data volume and concurrency, with a free developer tier for evaluation.