Integrations & openness

Ten databases and file upload, plus a native JSON API, MCP, a PG port and YAML.

PostgreSQLDatabases
MySQLDatabases
OracleDatabases
SQL ServerDatabases
ClickHouseDatabases
TiDBDatabases
DorisDatabases
StarRocksDatabases
KingbaseESDatabases
DuckDBDatabases
CSV · XLSXFiles & APIs
REST APIFiles & APIs
JSON APIOpen outputs
MCPOpen outputs
PGOpen outputs
YAMLOpen outputs

Database connections support SSH jump hosts and mutual TLS. Availability depends on the drivers installed at deployment.

06 · Openness

Easy to bring data in.
Easy to take it out.

A native JSON API, MCP, a PG-protocol port, and charts and dashboards as YAML. Your data and definitions are not locked inside an interface.

Sources

PostgreSQL
MySQL
Oracle
SQL Server
ClickHouse
Doris · StarRocks
Files · APIs

Cube Core

Data modelingDimensions, measures, joins and views, defined once
Access controlOne enforcement point for row access; views only
Pinned snapshotsEvery query reads an immutable data version
Open APIsJSON API · MCP · PG port

semantic layer

Consumers

Dashboards & data appsIn the workspace
AI agentsMCP
Other systemsJSON API
BI tools & ExcelPG port · Power Query

Illustration. The PG port is exposed by an administrator at deployment, internal networks only; Excel goes through Power Query calling the JSON API or a CSV import, since Cube Core has no direct Excel connector.

POST /api/v1/query
Authorization: Bearer <token>

{
  "model_id": "valuation",
  "view": "asset_view",
  "query": {
    "measures": ["asset_view.revenue"],
    "dimensions": ["asset_view.region"],
    "order": [["asset_view.revenue", "desc"]],
    "limit": 100
  }
}

// → { "data": [ … ], "release_id": "…", "snapshot_set_id": "…" }

Native JSON queries, with the release and snapshot identifiers attached to every result.

Supported databases

PostgreSQL
MySQL
Oracle
SQL Server
ClickHouse
TiDB
Doris
StarRocks
KingbaseES
DuckDB

Plus CSV / XLSX upload and API pulls.

Database connections support SSH jump hosts and mutual TLS

Take your datafrom tangled to clear.

Try it on sample data first, then bring your own.

Try the demo Request a demo Open the app

Integrations & opennessIntegrations & openness

Take your datafrom tangled to clear.

Integrations & openness