How it works
How Renovara works
Renovara connects Claude or ChatGPT to Australian electricity and gas market data from AEMO, with an analyst guide that tells the model how to query it correctly. This page sets out the service in full, what data it holds, how current it is, how to connect, and what it can't answer.
What Renovara is
Renovara is a data service for people who work with the National Electricity Market (NEM) and the east coast gas market: analysts, traders, engineers and advisers. It is not a dashboard. You keep using the AI assistant you already use, Claude or ChatGPT, and Renovara gives it two things it doesn't have on its own:
- The data. AEMO's published market data, cleaned and loaded into tables the assistant can query with SQL.
- An analyst guide. Instructions the assistant reads before it queries: which table answers which question, the traps in each one (intervention pricing, run numbers, market time) and worked examples.
You ask in plain English, for example "What was the average Queensland price during last week's heatwave?". The assistant writes the SQL, runs it against Renovara and shows its working. Nobody on your side needs to write SQL or Python, or maintain a data pipeline.
How you connect
- Start a 30-day free trial at renovara.co/signup. No card is needed. The email you use becomes your Renovara sign-in.
- Open the welcome email. It links to the setup guide at renovara.co/connect-ai.
- Add the connector in Claude or ChatGPT with one address:
https://mcp.renovara.co/mcp. There is no client ID or API key to copy. - Sign in with a one-time code emailed to you. There is no password. A sign-in lasts seven days.
- Check it works by asking "Who am I on Renovara?". The assistant replies with your email and whether your access is active.
Setup takes about five minutes, with no one to wait for.
How the data stays current
Renovara refreshes its tables daily from AEMO's published reports. Electricity dispatch data is held at AEMO's five-minute interval; demand and rooftop solar at the half hour; gas data by gas day. Market timestamps are AEST (UTC+10, no daylight saving), as AEMO publishes them.
When Renovara adds a dataset, it appears in the analyst guide the assistant reads and in the catalogue below. Nothing changes on your side: the next question can use it.
Data available
Every table Renovara serves, grouped by what it covers. The assistant sees the same list, with each table's columns and their meaning. Table names are in external_data.nemweb.
Electricity: prices, demand and dispatch
| Dataset | What it answers | Rows | From |
|---|---|---|---|
Dispatch pricessilver_dispatchis_reports_dispatch_price | Regional energy and frequency control (FCAS) prices for every five-minute interval. | 4.2 million | Jan 2019 |
Regional dispatch summarysilver_dispatchis_reports_dispatch_regionsum | Demand, generation, interchange and frequency control requirements per region, every five minutes. | 4.2 million | Jan 2019 |
Price settersilver_pricesetter_price_setter | Which unit set each region's price in each five-minute interval. | 86.1 million | Jan 2019 |
Unit output (SCADA)silver_dispatch_scada_dispatch_unit_scada | Measured output in MW of each dispatchable unit at the start of every interval. | 341.8 million | Jan 2019 |
Unit dispatch targetssilver_next_day_dispatch_dispatch_unit_solution | Each unit's dispatch target and frequency control enablement, every five minutes. | 352.7 million | Jan 2019 |
Bid trackingsilver_next_day_dispatch_dispatch_offertrk | Which bid or offer each unit was dispatched against, every five minutes. | 1.2 billion | Jan 2019 |
Interconnector flowssilver_dispatchis_reports_dispatch_interconnectorres | Flow, losses and limits on each interconnector, every five minutes. | 5.0 million | Jan 2019 |
Inter-regional flowssilver_dispatchis_reports_dispatch_interconnection | Flows and losses between regions, every five minutes. | 680,766 | Sep 2024 |
Local price adjustmentssilver_dispatchis_reports_dispatch_local_price | Local pricing offsets at each unit's connection point, every five minutes. | 9.6 million | Aug 2024 |
Dispatch run summarysilver_dispatchis_reports_dispatch_case_solution | One row per dispatch run, including interventions and solution status. | 217,938 | Sep 2024 |
Operational demandsilver_operational_demand_actual_operational_demand_actual | Measured operational demand per region, every half hour. | 190,010 | Aug 2024 |
Rooftop solar (estimated actual)silver_rooftop_pv_actual_rooftop_actual | AEMO's estimate of rooftop solar output per region, every half hour. | 2.6 million | Jan 2019 |
Electricity: forecasts
| Dataset | What it answers | Rows | From |
|---|---|---|---|
Rooftop solar forecastsilver_rooftop_pv_forecast_rooftop_forecast | AEMO's half-hourly rooftop solar forecast per region, up to eight days ahead. | 249.6 million | Jan 2019 |
Five-minute predispatch, regionssilver_p5_reports_p5min_regionsolution | Projected regional prices and demand for the next hour, in five-minute steps. | 5.5 million | Nov 2025 |
Five-minute predispatch, interconnectorssilver_p5_reports_p5min_interconnectorsoln | Projected interconnector flows for the next hour. | 6.6 million | Nov 2025 |
Five-minute predispatch, local pricessilver_p5_reports_p5min_local_price | Projected local price adjustments for the next hour. | 53.4 million | Nov 2025 |
Predispatch pricessilver_predispatchis_reports_predispatch_region_prices | Projected regional prices by half hour from each predispatch run. | 4.2 million | Nov 2025 |
Predispatch regional solutionsilver_predispatchis_reports_predispatch_region_solution | Projected regional demand, generation and reserves from each predispatch run. | 4.2 million | Nov 2025 |
Predispatch interconnectorssilver_predispatchis_reports_predispatch_interconnector_soln | Projected interconnector flows and losses from each predispatch run. | 5.1 million | Nov 2025 |
Predispatch local pricessilver_predispatchis_reports_predispatch_local_price | Projected local price adjustments from each predispatch run. | 39.2 million | Nov 2025 |
Electricity: constraints and losses
| Dataset | What it answers | Rows | From |
|---|---|---|---|
Binding constraintssilver_dispatchis_reports_dispatch_constraint | Binding and inter-regional constraints in each dispatch run, with their marginal values. | 206.5 million | Sep 2024 |
Constraint cataloguesilver___gencondata | The generic constraints AEMO uses, with their descriptions. | 92,006 | Jan 2025 |
Constraint setssilver___genconset | Which constraints belong to each constraint set. | 139,105 | Jan 2025 |
Constraint factors, connection pointssilver___spdcpc | The factor each constraint applies to each connection point. | 2.2 million | Jan 2025 |
Constraint factors, regionssilver___spdrc | The factor each constraint applies to regional generation and load. | 5,937 | Jan 2025 |
Marginal loss factorssilver_marginal_loss_factors_daily_mlf | Marginal loss factors by connection point, by effective date and version. | 926,201 | Jul 2011 |
Electricity: registration and reference
| Dataset | What it answers | Rows | From |
|---|---|---|---|
Unit detailssilver___participant_registration_dudetailsummary | Each dispatchable unit's region, connection point, type and loss factors over time. | 410,554 | Jun 2007 |
Units to gensetssilver___participant_registration_dualloc | Which gensets make up each dispatchable unit, over time. | 3,067 | Oct 1998 |
Gensetssilver___participant_registration_genunits | Every genset AEMO has registered, retired units included. | 981 | Nov 2005 |
Market participantssilver___participant_registration_participant | Participant IDs, names and classes. | 22,873 | Jun 1998 |
Registration and exemption listsilver_nem_registration_exemption_list | Registered units with capacity, fuel source and technology type. | 545 | Current list |
Production units and scheduled loadssilver_nem_participant_and_scheduled_loads | Registered production units and scheduled loads with their classifications. | 1,134 | Current list |
Unit fuel (AEMO)v_duid_fuel_aemo | Fuel type for each unit, in AEMO's classification. | 1,018 | Current list |
Unit fuel (AER)v_duid_fuel_aer | Fuel type for each unit, in the Australian Energy Regulator's classification. | 569 | Current list |
Facilities (OpenElectricity)silver_openelectricity_facilities | Facility details from openelectricity.org.au. | 627 | Current list |
Units (OpenElectricity)silver_openelectricity_units | Unit details from openelectricity.org.au. | 1,133 | Current list |
Gas: AEMO Gas Bulletin Board
| Dataset | What it answers | Rows | From |
|---|---|---|---|
Actual flows and storagesilver_gbb_actual_flow_storage | Daily production, flows and storage by facility. | 446,069 | Daily |
Pipeline connection flowssilver_gbb_pipeline_connection_flow | Daily flows at pipeline connection points. | 1.6 million | Daily |
Nominations and forecastssilver_gbb_nomination_forecast | Facility nominations and forecasts for coming gas days. | 4,604 | Daily |
Short-term capacity outlooksilver_gbb_short_term_capacity_outlook | Facility capacity for the coming days. | 5,960 | Daily |
Medium-term capacity outlooksilver_gbb_medium_term_capacity_outlook | Planned capacity changes over the coming months. | 30,471 | Daily |
Linepack capacity adequacysilver_gbb_linepack_capacity_adequacy | Daily linepack and capacity adequacy status by pipeline. | 1,782 | Daily |
Linepack zonessilver_gbb_linepack_zones | The pipeline segments linepack is reported for. | 56 | Daily |
Facilitiessilver_gbb_facilities | The Bulletin Board's register of facilities. | 159 | Daily |
Participantssilver_gbb_participants | Bulletin Board participants. | 259 | Daily |
Basinssilver_gbb_basins | Gas basins. | 15 | Daily |
Locationssilver_gbb_locations | Bulletin Board locations. | 25 | Daily |
Nodes and connection pointssilver_gbb_nodes_connection_points | Pipeline nodes and connection points. | 772 | Daily |
What it can and can't answer
It answers questions the tables above can answer: prices and their drivers, demand, generation by unit or fuel, interconnector flows, binding constraints, forecasts against actuals, rooftop solar, unit registration details and east coast gas flows, storage and capacity. Much of the electricity history runs back to January 2019.
It can't answer:
- Questions that need a dataset not listed above. If you need one, tell us at info@renovara.co.
- Questions about the Western Australian electricity or gas markets, which AEMO runs separately from the NEM and the east coast Gas Bulletin Board.
- Questions about today's intervals before the daily refresh has loaded them.
- Your own private data, such as meter reads, contracts or settlement statements.
Answers come from an AI model querying the data. The SQL is shown so you can check it; check figures before relying on them for a trading or investment decision. Renovara does not give financial advice.
Example questions
- What was the average spot price in each region last month, and how did it compare with the same month last year?
- Which units set the South Australian price most often in the last quarter, and on what fuel?
- How much did rooftop solar reduce operational demand in Victoria at midday last week?
- Which constraints bound most often between Queensland and New South Wales this year?
- How accurate was AEMO's rooftop solar forecast for New South Wales yesterday?
- What was the daily revenue of a given battery over the last 30 days?
- How much gas flowed through the major east coast pipelines each day last month?
- Which gas facilities have capacity reductions planned in the coming months?
Access and pricing
- The trial lasts 30 days. When it ends, access pauses. To continue, add a card in the billing portal (Manage at the top of this site) and choose Start subscription.
- Prices are on renovara.co/pricing. For a team, or to query the data directly from your own Databricks workspace, see NEMWeb for enterprise.
- Terms are at renovara.co/terms-of-service; privacy at renovara.co/renovara-privacy-policy.
Start
Connected in about five minutes.
30-day free trial, no card. Add a card only if you want to continue.