search_columns
Search column documentation by words, in any order and ignoring case, across column names, column descriptions and AEMO table names. Use this when you know what you want to measure but not which table holds it (e.g. 'marginal value', 'loss factor', 'intervention', 'RRP'). Spaces and hyphens also match underscored or run-together names: 'local price adjustment' finds LOCAL_PRICE_ADJUSTMENT and 'marginal value' finds MARGINALVALUE. Hits contain every word, best name matches first; if no column has every word, the closest partial matches come back with matched_all_terms=false. Each hit lists the AEMO source table, the column name + description + units + valid values, and the consolidated.* views that expose the column — pick one of those for your SQL. The docs cover AEMO's whole data model, including tables the warehouse does not hold: those hits carry in_warehouse=false and a not_in_warehouse_reason (participant-private, retired by AEMO, not yet published by AEMO, or not ingested), rank after warehouse hits, and cannot be queried.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"query": "<query>"
},
"name": "search_columns"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of hits to return. Defaults to 25 — enough to compare candidates without blowing the context window. | |
| query | Yes | Words to find in column names, column descriptions and AEMO table names, in any order and ignoring case (e.g. "MARGINALVALUE", "intervention", "loss factor", "local price adjustment"). Spaces and hyphens also match underscored or run-together column names, so "marginal value" finds MARGINALVALUE. | |
| question_id | No | Optional UUID returned by an earlier `start_question` call. When provided, this tool call is attributed to that question. |