How to Use EIA dataset directory in Gemini CLI
Explore EIA datasets and their metadata, including available frequencies, filters, measurement columns, and units. Use it to find the right dataset and understand its coverage before requesting observations.
Prompts to try with EIA dataset directory in Gemini CLI
Copy an example into Gemini CLI, or ask in your own words.
Use EIA dataset directory to find monthly electricity generation by state and fuel for a Texas generation chart in this project. Document the available measurements, units, and date coverage.
Use EIA dataset directory to look this up and give me the result as a table. Save the result in ./assets.
Pull the latest numbers from EIA dataset directory and tell me what changed since last week.
Check EIA dataset directory and summarize what you find in three bullet points.
Pull the newest data from EIA dataset directory and give me the result as a table.
How to set up EIA dataset directory in Gemini CLI
Pick the way that suits you. Each takes about two minutes.
Use Spiral's MCP server
- Add the server
Or add it to ~/.gemini/settings.json yourself:
gemini mcp add --scope user --transport http spiral https://api.spiral.ai/mcp
- Sign in
Start gemini and run:
/mcp auth spiral
- Check it
In Gemini CLI, run /mcp. From your shell:
gemini mcp list
Use the Spiral skill
- Send Gemini CLI this message
Your agent reads Spiral's skill and sets itself up.
set up https://spiral.ai/SKILL.md
- Sign in or paste a key
Approve Spiral in the browser, or give the agent a key from the console.
Use the Spiral CLI
- 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
- Create an API key
In the console, under API keys.
- Run EIA dataset directory
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": "eia-gov/energy-data/routes", "input": { "path": "<path>" } }'
Then paste one of the prompts above: Gemini CLI finds EIA dataset directory on Spiral, shows the price and runs it.
EIA dataset directory providers and prices
Spiral runs EIA dataset directory through Alexandria. Open a card for today's price, with every fee included.
Settings you can ask for
Ask Gemini CLI for any of these in your prompt.
| Setting | Allowed values | Default | Description |
|---|---|---|---|
| Page size | 1 to 1000 | 500 | Child routes per page (the API returns all children at once; pages are cut here). |
Every API field of US Energy Information Administration · Routes is on its tool page: open its card above.
What can you do with EIA dataset directory in Gemini CLI?
Build a state electricity comparison or grid-demand report using EIA measurements. Let the agent inspect dataset metadata and category labels before adding calculations and charts to your project.
Compare state electricity consumption
Find the retail sales dataset, resolve state and customer-sector codes, and compare monthly residential electricity sales in California, Texas, and Florida over the same period.
Compare commercial and industrial demand for electricity
Identify the retail sales measurements and sector labels, then compare commercial and industrial electricity sales in Ohio. Calculate each sector's year-over-year change.
Measure changes in a state's generation mix
Locate monthly generation by state and fuel, resolve the fuel categories, and calculate how Texas generation shares changed between 2023 and 2024.
Review power plant operating history
Find the plant generation dataset and the code for Palo Verde, then compare monthly generation across 2023 and 2024 to identify seasonal changes.
Check grid demand forecasts against reported demand
Locate hourly balancing-authority measurements and resolve PJM's reporting code. Compare reported demand with demand forecasts for a completed week and calculate the largest hourly differences.
Compare seasonal natural gas storage
Find weekly underground storage data and its regional categories, then compare working gas levels for the same weeks in successive years.
More on EIA dataset directory and Gemini CLI
Overview
EIA dataset directory in other agents
Questions about EIA dataset directory in Gemini CLI
Can Gemini CLI use EIA dataset directory?
Yes. Add Spiral to Gemini CLI as an MCP server, and Gemini CLI can find and run EIA dataset directory like any built-in tool.
How much does EIA dataset directory cost in Gemini CLI?
$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your Gemini CLI plan is separate.
Do I need an Alexandria account to use EIA dataset directory in Gemini CLI?
No. Spiral runs EIA dataset directory on its own Alexandria account. You sign in to Spiral once and never paste a key.
How long does it take to set up EIA dataset directory in Gemini CLI?
About two minutes: add the server, then sign in, then check it.
Does Gemini CLI wait while EIA dataset directory runs?
EIA dataset directory runs in the background. Gemini CLI starts the run, checks on it and gives you the json when it's ready.
What detail does EIA provide for electricity customers?
EIA's retail sales dataset includes monthly customer counts, electricity sales, revenue, and average prices by state and customer sector.
Does EIA update every dataset on the same schedule?
No. EIA says its API accesses public-facing databases directly and updates constantly rather than at regular intervals.
Can one response contain every matching observation?
EIA caps observation responses at 5,000 rows. The total count can exceed the returned count, so larger requests need pagination or narrower filters.
How far back does the hourly grid API go?
EIA says historical EIA-930 submissions through the API begin January 1, 2019. This collection covers grid operations reported by balancing authorities in the Lower 48 states.
Does hourly generation include rooftop solar?
Hourly generation captures generators managed by, or visible to, balancing authorities. Those authorities typically do not meter distribution-system generators, so rooftop solar is often excluded.
Start using EIA dataset directory in Gemini CLI
One Spiral account for every tool your agent needs. No subscription; you pay per run.
Paste this into Gemini CLI:
set up https://spiral.ai/SKILL.md


