AEMO market data, queried from your own code.
Run read-only SQL over Renovara's electricity and gas market tables from your own software, services and AI agents. Built for organisations that serve many clients and systems, with nothing to host and no pipeline to maintain.
One source of market data for everything you build.
The SQL API is for organisations whose own systems need the market data, rather than one analyst asking questions in a chat window.
Software that serves clients
Client reports, portals and data products that query the market for many customers from one organisation account.
Jobs, models and notebooks
Pipelines and models that pull prices, demand and dispatch on a schedule, with results as rows or a Parquet file.
AI agents
Agents that read the API's own description, the analyst guide and each table's columns before they write SQL, with no person to explain the API.
Credentials per system
Several sets of credentials per organisation, one for each system, each of which can be revoked on its own.
Plain SQL over HTTPS.
You send one DuckDB SELECT. A quick query answers in the same call; a slower one returns a statement ID to poll. Results come back as rows, and every result is also a Parquet file. Renovara handles the AEMO ingestion, cleaning and daily refresh.
Read the documentationDuckDB SQL
One read-only SELECT per statement. The analyst guide lists the differences from Databricks SQL.
OAuth client credentials
A client ID and secret for each system, exchanged for an access token that lasts an hour.
Rows or Parquet
Up to 10,000 rows inline, and every result as a Parquet file. A statement stops at 300 seconds.
Describes itself
An OpenAPI description, the analyst guide and every table's columns are public, with no credentials needed to read them.
Five-minute intervals
Electricity dispatch at AEMO's five-minute interval, much of it since January 2019, and east coast gas by gas day. Refreshed daily.
renovara-sql on PyPI
A Python client that keeps the token for its hour, polls slow queries, retries safely and returns pandas data frames.
How it differs from the MCP subscription
Renovara's MCP subscription connects Claude or ChatGPT to the data through an MCP server, for people who ask their questions in plain English. The SQL API is an enterprise plan for your organisation's own software.
| MCP subscription | Renovara SQL API | |
|---|---|---|
| Who uses it | People, in Claude or ChatGPT | Your organisation's software, services and agents |
| How | Ask in plain English; the assistant writes and runs the SQL | Your code sends SQL over HTTPS |
| SQL | Databricks SQL, written by the assistant | DuckDB SQL, written by you or your agent |
| Sign-in | A one-time code emailed to each person | A client ID and secret for each system; tokens last an hour |
| Built for | People who ask the questions themselves | Organisations serving many clients and systems |
| Trial | 30 days, no card | 30 days, no card, 10 hours of query time |
Both read the same tables and the same analyst guide, so a table means the same thing in each. For a team that works inside Databricks, NEMWeb for enterprise shares the data straight into your own workspace.
The trial
- 30 days, no card. Sign up with your work email at checkout. That person manages the organisation's credentials.
- 10 hours of query time in total, measured as the time your statements spend running rather than as a count of queries, because one query can take a hundred times as long as another. For scale, that is roughly 3,600 queries of ten seconds, or many more light ones.
- 2,000 statements a day and 5 running at once, for the whole organisation, across all its credentials. Days are counted on Brisbane time (AEST).
- After the trial, the plan is AUD 467.50 a month or AUD 4,990 a year, including GST; the annual price applies if you choose annual billing. If no card has been added by the end of the trial, the subscription pauses and the API stops accepting statements; add one in the billing portal (Manage, at the top of this site) to carry on. All plans are on renovara.co/pricing.
Already started a trial? Manage your API credentials. The full limits, error codes and examples are in How Renovara SQL works. Use of the API is covered by the terms of service.
The market data comes from the Australian Energy Market Operator (AEMO) and is used under AEMO's copyright permissions; some reference data comes from the Australian Energy Regulator. Where you show it to others, credit AEMO as its source, and the Australian Energy Regulator for its data.
Start with a 30-day trial.
No card, and 10 hours of query time to try it against your own work. The guide and the table schemas are open to read first.
What happens next
- Sign up with your work email at checkout. No card is needed for the trial.
- Sign in to the credentials page from the welcome email, with a one-time code emailed to you. There is no password.
- Create credentials and download them as renovara-sql.json. The secret is shown once.
- Run a query with pip install renovara-sql and the quickstart script, or with curl.