Cernion Tabular Intelligence API
The Tabular Intelligence API from Cernion — 6 operation(s) for tabular intelligence.
Work with this as data
Every API here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for apis
7 MCP tools reach this
find_apisBrowse and filter every API in the catalog.get_api_artifactsOne API's artifacts, grouped by type.get_openapiThe primary OpenAPI for this API.find_similar_apisAPIs that look like this one.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/cernion-de:cernion-de-tabular-intelligence-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.
OpenAPI Specification
openapi: 3.2.0
info:
title: Cernion Energy Tools Tabular Intelligence API
version: 0.99.22
description: 'MicroService Agent System for Energy Markets - REST API with AI integration.
CERNION_TOKEN: request at https://cernion.de/ or by email: dev@stromdao.com.
For the public instance at https://api.cernion.de/, create your token at https://cernion.de/cet-token/.'
servers:
- url: https://api.cernion.de
description: API Server
tags:
- name: Tabular Intelligence
paths:
/api/tabular/profile:
post:
summary: Build a privacy-aware deterministic table profile
tags:
- Tabular Intelligence
operationId: tabular_profile
parameters:
- $ref: '#/components/parameters/TokenQuery'
responses:
'200':
description: Successful response
content:
application/json:
schema:
type: object
requestBody:
content:
application/json:
schema:
type: object
required:
- sourceId
properties:
sourceId:
type: string
example: metering-source-01
maxRows:
type: integer
default: 5000
example: 5000
privacyContext:
type: string
enum:
- ai-agent
- public
default: ai-agent
example: ai-agent
token:
type: string
description: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.
examples:
request:
summary: Tabular intelligence request
value:
sourceId: metering-source-01
maxRows: 5000
privacyContext: ai-agent
/api/tabular/llm-context:
post:
summary: Build bounded LLM-safe context without raw table rows
tags:
- Tabular Intelligence
operationId: tabular_llmContext
parameters:
- $ref: '#/components/parameters/TokenQuery'
responses:
'200':
description: Successful response
content:
application/json:
schema:
type: object
requestBody:
content:
application/json:
schema:
type: object
required:
- sourceIds
properties:
sourceIds:
type: array
items:
type: string
example:
- metering-source-01
maxTokens:
type: integer
default: 2000
example: 2000
privacyContext:
type: string
enum:
- ai-agent
- public
default: ai-agent
example: ai-agent
token:
type: string
description: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.
examples:
request:
summary: Tabular intelligence request
value:
sourceIds:
- metering-source-01
maxTokens: 2000
privacyContext: ai-agent
/api/tabular/query-plan:
post:
summary: Create or validate an allow-listed tabular analysis plan
tags:
- Tabular Intelligence
operationId: tabular_queryPlan
parameters:
- $ref: '#/components/parameters/TokenQuery'
responses:
'200':
description: Successful response
content:
application/json:
schema:
type: object
requestBody:
content:
application/json:
schema:
type: object
required: []
properties:
sourceIds:
type: array
items:
type: string
example:
- metering-source-01
question:
type: string
example: What is the total consumption?
plan:
type: object
default: null
example: {}
useLlm:
type: boolean
default: false
example: false
maxTokens:
type: integer
default: 2000
example: 2000
token:
type: string
description: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.
examples:
request:
summary: Tabular intelligence request
value:
sourceIds:
- metering-source-01
question: What is the total consumption?
useLlm: false
/api/tabular/execute-plan:
post:
summary: Execute a validated tabular plan deterministically
tags:
- Tabular Intelligence
operationId: tabular_executePlan
parameters:
- $ref: '#/components/parameters/TokenQuery'
responses:
'200':
description: Successful response
content:
application/json:
schema:
type: object
requestBody:
content:
application/json:
schema:
type: object
required:
- plan
properties:
plan:
type: object
example:
schemaVersion: '1.0'
sources: []
operations: []
token:
type: string
description: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.
examples:
request:
summary: Tabular intelligence request
value:
plan:
schemaVersion: '1.0'
sources:
- alias: table
sourceId: metering-source-01
operations:
- op: aggregate
groupBy: []
metrics:
- fn: sum
field: value
as: totalValue
/api/tabular/ask:
post:
summary: Answer a table question with deterministic results and evidence
tags:
- Tabular Intelligence
operationId: tabular_ask
parameters:
- $ref: '#/components/parameters/TokenQuery'
responses:
'200':
description: Successful response
content:
application/json:
schema:
type: object
requestBody:
content:
application/json:
schema:
type: object
required:
- question
properties:
question:
type: string
example: What is the total consumption?
sourceIds:
type: array
items:
type: string
example:
- metering-source-01
plan:
type: object
default: null
example: {}
useLlm:
type: boolean
default: false
example: false
token:
type: string
description: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.
examples:
request:
summary: Tabular intelligence request
value:
question: What is the total consumption?
sourceIds:
- metering-source-01
useLlm: false
/api/tabular/quality-report:
post:
summary: Build an evidence-backed table quality report
tags:
- Tabular Intelligence
operationId: tabular_qualityReport
parameters:
- $ref: '#/components/parameters/TokenQuery'
responses:
'200':
description: Successful response
content:
application/json:
schema:
type: object
requestBody:
content:
application/json:
schema:
type: object
required:
- sourceId
properties:
sourceId:
type: string
example: metering-source-01
timestampField:
type: string
default: null
example: timestamp
intervalMinutes:
type: integer
default: 15
example: 15
duplicateFields:
type: array
items:
type: string
example:
- timestamp
outlierField:
type: string
default: null
example: value
outlierThreshold:
type: number
default: 3
example: 3
token:
type: string
description: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.
examples:
request:
summary: Tabular intelligence request
value:
sourceId: metering-source-01
timestampField: timestamp
intervalMinutes: 15
duplicateFields:
- timestamp
outlierField: value
components:
parameters:
TokenQuery:
name: token
in: query
required: false
schema:
type: string
description: Optional Cernion MCP token as URL query parameter. If provided, it overrides CERNION_TOKEN for this request. Prefer Authorization Bearer header in production to reduce token exposure in URLs/logs.
securitySchemes:
ApiKeyAuth:
type: apiKey
in: header
name: X-API-Key
BearerAuth:
type: http
scheme: bearer
bearerFormat: JWT
description: 'Optional Cernion MCP token. If not provided, falls back to CERNION_TOKEN from environment. Request token at https://cernion.de/ or by email: dev@stromdao.com.'