Choosing the Right API
- To connect to Microsoft Excel, use Cube Cloud for Excel
- To connect to Google Sheets, use Cube Cloud for Sheets
- To connect to AI assistants, use the Model Context Protocol (MCP) server
- For internal or self-serve business intelligence, connect via the SQL API
- For embedded analytics and real-time analytics, use REST (JSON) API or GraphQL API. When using the REST (JSON) API, the JavaScript SDK can simplify integration with your front-end code
See this GitHub issue
for an unofficial, community-maintained client library for Python.
Data modeling
Support for data modeling features differ across APIs, integrations, and visualization tools. Some of the features with partial support are listed below:Personal Core Data API Token
Cube users can generate a personal token to authenticate SQL API and REST (JSON) API connections from external tools like BI dashboards, notebooks, and SQL clients. Navigate to Preferences → Personal Core Data API Token and click Generate Token. The token authenticates as that user, so all groups, user attributes, and data access policies are applied to queries made with this token. The page also provides connection instructions for your deployment: host, port, and database name for the SQL API, and a samplecurl request using the token as a bearer token for the
REST (JSON) API: