Cumulocity · Capability

Cumulocity DataHub — Queries

Run ad-hoc ANSI SQL queries against the Cumulocity DataHub Parquet data lake via Dremio.

Cumulocity DataHub — Queries is a Naftiko capability published by Cumulocity, one of 31 capabilities the APIs.io network indexes for this provider. It bundles 1 operation.

The capability includes 1 read-only operation. Lead operation: Execute an ANSI SQL query against the Cumulocity DataHub data lake. Can be deployed as a REST endpoint, MCP tool, or Agent Skill via Naftiko.

Tagged areas include Cumulocity, DataHub, SQL, and Analytics.

Run with Naftiko CumulocityDataHubSQLAnalytics

MCP Tools

cumulocity-datahub-sql

Execute an ANSI SQL query against the Cumulocity DataHub data lake.

read-only idempotent

Capability Spec

naftiko: 1.0.0-alpha2
info:
  label: Cumulocity DataHub — Queries
  description: Run ad-hoc ANSI SQL queries against the Cumulocity DataHub Parquet data lake via Dremio.
  tags: [Cumulocity, DataHub, SQL, Analytics]
  created: '2026-05-25'
  modified: '2026-05-25'
binds:
- namespace: env
  keys:
    C8Y_BASE_URL: C8Y_BASE_URL
    C8Y_USER: C8Y_USER
    C8Y_PASSWORD: C8Y_PASSWORD
capability:
  consumes:
  - type: http
    namespace: datahub-queries
    baseUri: '{{env.C8Y_BASE_URL}}'
    resources:
    - name: query
      path: /service/datahub/query
      operations:
      - name: runquery
        method: POST
        description: Run An Ad-Hoc SQL Query
        inputParameters:
        - {name: body, in: body, type: object, required: true}
    authentication:
      type: basic
      username: '{{env.C8Y_USER}}'
      password: '{{env.C8Y_PASSWORD}}'
  exposes:
  - type: mcp
    namespace: datahub-queries-mcp
    port: 9090
    transport: http
    tools:
    - name: cumulocity-datahub-sql
      description: Execute an ANSI SQL query against the Cumulocity DataHub data lake.
      hints: {readOnly: true, destructive: false, idempotent: true}
      call: datahub-queries.runquery
      with: {body: tools.body}