Cernion OEP (Open Energy Platform) API

Read-only access to Open Energy Platform research and scenario datasets. No authentication required for public tables. Supports schema/table discovery, column metadata, row queries, and full-text search. API: https://openenergyplatform.org/api/v0

Operations 7

GET /api/oep/schemas List OEP database schemas #
GET /api/oep/schemas/:schema/tables List tables within an OEP schema #
GET /api/oep/tables/:schema/:table/meta Get OEP table metadata (columns, types, OEO annotations) #
GET /api/oep/tables/:schema/:table/rows Query rows from an OEP table #
GET /api/oep/energy-tables List pre-configured Cernion-relevant OEP tables #
POST /api/oep/compare-mastr Compare OEP research data with MaStR installations for a grid operator #

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.
All 92 tools →

Call it yourself

curl for this page
This API
curl "https://apis.io/api/v1/apis/cernion-de:cernion-de-oep-open-energy-platform-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

cernion-de-oep-open-energy-platform-api-openapi.yml Raw ↑
openapi: 3.2.0
info:
  title: Cernion Energy Tools OEP (Open Energy Platform) 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: OEP (Open Energy Platform)
  description: 'Read-only access to Open Energy Platform research and scenario datasets. No authentication required for public tables. Supports schema/table discovery, column metadata, row queries, and full-text search. API: https://openenergyplatform.org/api/v0'
paths:
  /api/oep/schemas:
    get:
      summary: List OEP database schemas
      tags:
      - OEP (Open Energy Platform)
      operationId: oep_listSchemas
      parameters:
      - $ref: '#/components/parameters/TokenQuery'
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
      description: Returns the list of available database schemas on the Open Energy Platform. Schemas group related research datasets (e.g. model_draft, scenario, supply). Results are cached for 24 hours.
  /api/oep/schemas/:schema/tables:
    get:
      summary: List tables within an OEP schema
      tags:
      - OEP (Open Energy Platform)
      operationId: oep_listTables
      parameters:
      - name: schema
        in: path
        required: true
        schema:
          type: string
          example: model_draft
      - $ref: '#/components/parameters/TokenQuery'
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
      description: Returns all tables available in the given OEP schema. Includes table name and description where provided. Results are cached for 24 hours.
  /api/oep/tables/:schema/:table/meta:
    get:
      summary: Get OEP table metadata (columns, types, OEO annotations)
      tags:
      - OEP (Open Energy Platform)
      operationId: oep_getTableMeta
      parameters:
      - name: schema
        in: path
        required: true
        schema:
          type: string
          example: model_draft
      - name: table
        in: path
        required: true
        schema:
          type: string
          example: oed_scenario_bundle
      - $ref: '#/components/parameters/TokenQuery'
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
      description: Returns the column schema (name, data type, description) for an OEP table, including OEMetadata v2.0 annotations where available. Results are cached for 24 hours.
  /api/oep/tables/:schema/:table/rows:
    get:
      summary: Query rows from an OEP table
      tags:
      - OEP (Open Energy Platform)
      operationId: oep_query
      parameters:
      - name: schema
        in: path
        required: true
        schema:
          type: string
          example: model_draft
      - name: table
        in: path
        required: true
        schema:
          type: string
          example: oed_scenario_bundle
      - name: limit
        in: query
        required: false
        schema:
          type: integer
          default: 100
          minimum: 1
          maximum: 1000
      - name: offset
        in: query
        required: false
        schema:
          type: integer
          default: 0
          minimum: 0
      - name: where
        in: query
        required: false
        schema:
          type: string
          example: year=2030
        description: OEP server-side filter expression (passed directly to the OEP API).
      - name: orderby
        in: query
        required: false
        schema:
          type: string
          example: year
      - $ref: '#/components/parameters/TokenQuery'
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
      description: Returns up to 1000 rows from the specified OEP table. Supports optional server-side filtering via the `where` parameter (OEP filter syntax, e.g. `year=2030`) and result ordering. Row data is NOT cached — each call fetches live from OEP.
  /api/oep/energy-tables:
    get:
      summary: List pre-configured Cernion-relevant OEP tables
      tags:
      - OEP (Open Energy Platform)
      operationId: oep_energyTables
      parameters:
      - $ref: '#/components/parameters/TokenQuery'
      responses:
        '200':
          description: List of pre-configured OEP tables with Cernion use cases
          content:
            application/json:
              schema:
                type: object
                properties:
                  tables:
                    type: array
                    items:
                      type: object
                      properties:
                        schema:
                          type: string
                          example: supply
                        table:
                          type: string
                          example: ego_dp_res_powerplant
                        description:
                          type: string
                        cernionUseCase:
                          type: string
                        oeoClass:
                          type: string
                          example: oeo:PowerPlant
                  count:
                    type: integer
                    example: 5
      description: 'Returns the curated list of OEP tables that are directly relevant for the Cernion/VNB context — EU AI Act Art. 12 data provenance, MaStR comparison, residual load validation, and energy scenario planning. No free-text search needed; tables are immediately usable. TRL5→6: demonstrated in relevant energy domain environment.'
  /api/oep/compare-mastr:
    post:
      summary: Compare OEP research data with MaStR installations for a grid operator
      tags:
      - OEP (Open Energy Platform)
      operationId: oep_compareWithMastr
      parameters:
      - $ref: '#/components/parameters/TokenQuery'
      responses:
        '200':
          description: OEP and MaStR counts with semantic delta output
          content:
            application/json:
              schema:
                type: object
                properties:
                  oep:
                    type: object
                    properties:
                      available:
                        type: boolean
                      count:
                        type: integer
                      source:
                        type: string
                  mastr:
                    type: object
                    properties:
                      available:
                        type: boolean
                      count:
                        type: integer
                      source:
                        type: string
                  delta:
                    type:
                    - object
                    - 'null'
                    properties:
                      matchedPairs:
                        type: integer
                      mastrOnly:
                        type: integer
                      oepOnly:
                        type: integer
                      totalUnmatched:
                        type: integer
                      capacityDeltaMW:
                        type: number
                      fieldDeltas:
                        type: object
                      topMismatches:
                        type: array
                        items:
                          type: object
                  oeoMappingNote:
                    type: string
                  _evidence:
                    type: array
                    items:
                      type: object
        '202':
          description: Job accepted for large comparison request
          content:
            application/json:
              schema:
                type: object
                properties:
                  success:
                    type: boolean
                  jobId:
                    type: string
                  status:
                    type: string
                  message:
                    type: string
                  statusUrl:
                    type: string
                  resultUrl:
                    type: string
      description: 'Loads OEP table rows and MaStR installations in parallel (Promise.allSettled) and returns a side-by-side semantic delta comparison. Graceful when OEP is offline — oep.available will be false but the MaStR data is still returned. Large requested portfolios (>5000 rows or `limit: "all"`) use the standard async job pattern for REST callers.'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              required:
              - gridOperatorId
              properties:
                gridOperatorId:
                  type: string
                  description: MaStR grid operator ID (SNB…)
                  example: SNB924510006275
                oepSchema:
                  type: string
                  default: supply
                  example: supply
                oepTable:
                  type: string
                  default: ego_dp_res_powerplant
                  example: ego_dp_res_powerplant
                installationType:
                  type: string
                  default: solar
                  enum:
                  - solar
                  - wind
                  - storage
                  - biomass
                  - hydro
                  - combustion
                  - all
                  description: Installation type for MaStR query. Use "all" for an aggregated portfolio comparison.
                limit:
                  oneOf:
                  - type: integer
                    minimum: 1
                  - type: string
                    enum:
                    - all
                  default: 100
                token:
                  type: string
                  description: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.
            examples:
              stromdaoNetze:
                summary: Compare OEP renewable plants with STROMDAO Netze MaStR data
                value:
                  gridOperatorId: SNB924510006275
                  oepSchema: supply
                  oepTable: ego_dp_res_powerplant
                  installationType: solar
                  limit: 100
              windComparison:
                summary: Compare wind installations for a grid operator
                value:
                  gridOperatorId: SNB900599182315
                  installationType: wind
                  limit: 200
              allPortfolio:
                summary: Compare all installation types asynchronously for large portfolios
                value:
                  gridOperatorId: SNB924510006275
                  installationType: all
                  limit: all
  /api/oep/search:
    get:
      summary: Search OEP tables by name or description
      tags:
      - OEP (Open Energy Platform)
      operationId: oep_search
      parameters:
      - name: q
        in: query
        required: true
        schema:
          type: string
          example: NEP 2023
        description: Search term (minimum 2 characters, case-insensitive).
      - name: schema
        in: query
        required: false
        schema:
          type: string
          example: model_draft
        description: Restrict search to this OEP schema (optional).
      - name: limit
        in: query
        required: false
        schema:
          type: integer
          default: 20
          minimum: 1
          maximum: 100
      - $ref: '#/components/parameters/TokenQuery'
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
      description: Case-insensitive substring search over the curated, Cernion-relevant OEP table catalog (src/oep-tables.js) — not a live full-catalog search against OEP. OEP's own schema/table discovery REST endpoints were removed upstream and no longer respond with JSON, so free-text discovery across the entire platform is not available; use oep.query directly if you already know an exact schema/table pair that is not in the curated list. Optionally scoped to a specific schema.
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.'