Spiral gives your agent every tool with one account. Browse the tools →

Codex · Public Records

How to Use IEA country codes in Codex

Returns country names and code mappings used by IEA energy datasets, with regional aggregates identified. Use it to match countries across datasets and check coverage before comparing energy figures.

Prompts to try with IEA country codes in Codex

Copy an example into Codex, or ask in your own words.

Use IEA country codes to resolve France, Germany, and Japan, then add the returned ISO3 mappings to this project's country reference table.

IEA country codesCodex
Try asking
  • Use IEA country codes to look this up and give me the result as a table. Save the result in ./assets.

  • Pull the latest numbers from IEA country codes and tell me what changed since last week.

  • Check IEA country codes and summarize what you find in three bullet points.

  • Pull the newest data from IEA country codes and give me the result as a table.

How to set up IEA country codes in Codex

Pick the way that suits you. Each takes about two minutes.

Use Spiral's MCP server

  1. Add the hosted server
    codex mcp add spiral --url https://api.spiral.ai/mcp
  2. Sign in

    Codex opens the browser: sign in to Spiral and click Authorize. No API key. codex mcp list then shows Spiral.

    codex mcp login spiral

Use the Spiral skill

  1. Send Codex this message

    Your agent reads Spiral's skill and sets itself up.

    set up https://spiral.ai/SKILL.md
  2. Sign in or paste a key

    Approve Spiral in the browser, or give the agent a key from the console.

Use the Spiral CLI

  1. Install and sign in

    Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

    npx -y spiral-cli@latest init

Call the Spiral API

  1. Create an API key

    In the console, under API keys.

  2. Run IEA country codes

    One request; the result comes back by polling or a webhook.

    curl https://api.spiral.ai/v1/runs \
      -H "Authorization: Bearer $SPIRAL_API_KEY" \
      -H "Content-Type: application/json" \
      -H "Idempotency-Key: $(uuidgen)" \
      -d '{
        "provider": "alexandria",
        "model": "iea-org/energy/countries",
        "input": {
          "query": "<query>"
        }
      }'

Then paste one of the prompts above: Codex finds IEA country codes on Spiral, shows the price and runs it.

IEA country codes providers and prices

Spiral runs IEA country codes through Alexandria. Open a card for today's price, with every fee included.

AlexandriaPublic Records
IEA · Countries
iea-org/energy/countries

Settings you can ask for

Ask Codex for any of these in your prompt.

SettingAllowed valuesDefaultDescription
Page size1 to 100020

page_size

Include aggregateson or off

include_aggregates

Every API field of IEA · Countries is on its tool page: open its card above.

What can you do with IEA country codes in Codex?

Build country energy comparisons into a dashboard using IEA observations and their reported units. Check dataset coverage and available years before joining the results to country records in your project.

Compare national electricity mixes

Find an electricity dataset, check its available years, resolve France and Germany, and compare generation by source over a shared reporting window.

Build an energy consumption benchmark

Identify the relevant energy balance series, verify country coverage and history, and compare total final consumption for Japan, Germany, and France using the returned units.

Prepare a monthly electricity briefing

Resolve the countries in a European market watchlist, confirm the latest available period, and summarize changes in wind, solar, hydro, and nuclear generation.

Compare fuel combustion emissions

Find the emissions dataset and its reporting window, match France and Germany to IEA country codes, and compare reported emissions by sector.

Check a hydro generation shortfall

Check Norway's monthly electricity coverage, retrieve hydro generation for matching months across two years, and calculate the change in reported output.

Scope an energy research project

Find datasets relevant to electricity and consumption, then compare their frequencies, available years, units, and country coverage before choosing the analysis period.

Questions about IEA country codes in Codex

Can Codex use IEA country codes?

Yes. Add Spiral to Codex as an MCP server, and Codex can find and run IEA country codes like any built-in tool.

How much does IEA country codes cost in Codex?

$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your Codex plan is separate.

Do I need an Alexandria account to use IEA country codes in Codex?

No. Spiral runs IEA country codes on its own Alexandria account. You sign in to Spiral once and never paste a key.

How long does it take to set up IEA country codes in Codex?

About two minutes: add the hosted server, then sign in.

Does Codex wait while IEA country codes runs?

IEA country codes runs in the background. Codex starts the run, checks on it and gives you the json when it's ready.

Does every IEA dataset cover the same countries?

No. The Energy Statistics Data Browser covers over 170 countries and regions, while Monthly Electricity Statistics advertises 47 countries. Check coverage for the dataset you intend to use.

How often does IEA monthly electricity data change?

Monthly Electricity Statistics is updated monthly. Use the dataset details lookup to check current availability, since the catalog's update date is not populated.

How far back does monthly electricity history go?

Coverage generally starts in January 2010 for OECD countries and January 2015 for non-OECD countries. Confirm the available years for the specific dataset before choosing a comparison period.

Can I retrieve a large historical table in one extraction?

Observation pagination stops at an offset of 200,000. Divide broad requests into smaller country or year ranges before reaching that boundary.

Get started

Start using IEA country codes in Codex

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into Codex:

Set up Codex

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options