---
title: "Schema discovery for databases, tables, columns, and available tools"
method: POST
path: "/api/query/discover"
tags: ["Query Tools"]
---

# Schema discovery for databases, tables, columns, and available tools

`POST /api/query/discover`

## Request

- Base URL: `https://api.cernion.de`
- URL: `https://api.cernion.de/api/query/discover`
- Auth: none declared

Explore available data sources to prevent query errors and build dynamic UIs. Provides schema information about databases, tables, columns, operators, and available MCP tools.

**Scopes**:
- **tools**: List all available MCP tools by category
- **databases**: Available databases (mastr_db, energy_charts_api, etc.)
- **tables**: Tables in a specific database (requires database parameter)
- **columns**: Columns in a table (requires database + table parameters)
- **operators**: Available grid operators and energy suppliers
- **locations**: Available regions, states, and postal codes (optional region filter)
- **examples**: Sample queries for common use cases

**Use Cases**:
- Prevent query errors (validate parameters before execution)
- Build dynamic UIs with available options
- Explore data structure without documentation
- Auto-complete functionality for query builders
- Validate grid operator names before queries

## Query parameters

- `token` string

## Request body

- object
  - `scope` 'tools' | 'databases' | 'tables' | 'columns' | 'operators' | 'locations' | 'examples', required: Discovery scope - what to explore
  - `database` string: Database name (required for tables/columns scope)
  - `table` string: Table name (required for columns scope)
  - `region` string: Optional filter for locations scope
  - `token` string: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.

## Response `200`

Discovery result with requested information

- object
  - `success` boolean
  - `scope` string
  - `data` object: Discovery results (structure depends on scope)
  - `metadata` object

---

[API](https://skmtc.dev/cernion/apis/cernion-energy-tools-api.md) · [All operations](https://skmtc.dev/cernion/apis/cernion-energy-tools-api/llms.txt) · [OpenAPI document](https://skmtc.dev/cernion/apis/cernion-energy-tools-api/revisions/cdb94473b538?raw)