What you can do with FERC EQR & Form 1

Built for

Energy Analysts, Infrastructure Investors, Regulatory Researchers

Example workflows

Hyperscaler power transactions

Price and volume diligence for datacenter power buyers.

Try this

Search FERC EQR transactions where the customer matches Microsoft, product is ENERGY, and term is LT. Show seller, weighted average price, total quantity, and total charge for the latest quarter.

Utility Form 1 financials

Utility-side financial context alongside EQR contracts.

Try this

Find Duke Energy in FERC Form 1 utilities and return operating revenues and net income for the latest filing year.

Long-term energy contracts

Contract terms without opening EQR Online.

Try this

Search FERC EQR contracts where Amazon is the customer and product is ENERGY with long-term term. Include commencement dates.

AI Skill
SKILL.md

Domain knowledge for FERC EQR & Form 1 — workflow patterns, data models, and gotchas for your AI agent.

FERC EQR & Form 1

Bulk Electric Quarterly Report (EQR) and Form 1 data for hyperscaler / utility wholesale power diligence — the datasets Alex Joyce asked for that are not on data.ferc.gov. Materialized from Catalyst Cooperative PUDL parquet on public S3 (CC BY 4.0 attribution).

Pair with the live FERC Open Data connector (ferc) for MBR authorizations and PPAs on the API.

Workflow

  1. Dataset stats — quarters loaded, row counts, last refresh.
  2. Search contracts — seller/customer names, product (ENERGY, CAPACITY), LT/ST term, contract dates.
  3. Search transactions — aggregated price, quantity, and charge rollups for the same parties (use when the user asks for $/MWh, volumes, or transaction totals).
  4. Search utilities then get utility financials — Form 1 operating revenues, net income, operating expenses.

Transaction rollups

Raw EQR transaction filings are billions of rows. This pipeline stores quarterly rollups grouped by seller, customer, product, term, class, and delivery balancing authority. weighted_avg_price is quantity-weighted across the group.

Key fields

Contracts: seller_company_name, customer_company_name, product_name, term_name (LT/ST), commencement_date, year_quarter

Transactions: total_quantity, total_charge, weighted_avg_price, min_price, max_price, transaction_count

Form 1: utility_id_ferc1, operating_revenues, net_utility_operating_income, net_income_loss, utility_operating_expenses

Attribution

Data via Catalyst Cooperative PUDL (CC BY 4.0). Original filings: FERC EQR and FERC Form 1.

Where the data comes from

PUDL FERC EQR Contracts
Catalyst Cooperative (from FERC EQR filings)

Quarterly EQR contract rows as Apache Parquet on public S3 (s3://pudl.catalyst.coop/ferceqr/).

~10M contract rows full history; transaction rollups ~17k groups/quarter
Source updated: Quarterly
We refresh: Daily check; PUDL targets updates by the 15th of Feb/May/Aug/Nov
Parquet (contracts + transactions per quarter)
US wholesale power EQR contract and transaction filings
PUDL FERC Form 1
Catalyst Cooperative (from FERC Form 1 filings)

Annual utility financial filings — identification and income statement parquet on s3://pudl.catalyst.coop/stable/.

~6.8k utilities; key income line items filtered
Source updated: Annual
We refresh: Daily check against PUDL stable release
Parquet (yearly tables)
US major electric and gas utility Form 1 filers
EQR transaction data is stored as quarterly rollups, not raw transaction line items. Customer company names are free-text seller entries and may vary in spelling.

Tools in this Server (5)

Ferc Eqr Get Stats

Return FERC EQR and Form 1 dataset coverage — contract rows, transaction rollup groups, utility count, quarters loaded, and last refresh time.

Ferc Eqr Get Utility Financials

Return FERC Form 1 income statement metrics for a utility — operating revenues, net utility operating income, net income, and operating expenses. Look...

Ferc Eqr Search Contracts

Search FERC Electric Quarterly Report (EQR) wholesale power contracts by seller or customer company name. Returns contract terms — product, firm/non-f...

Ferc Eqr Search Transactions

Search aggregated FERC EQR wholesale transaction rollups by seller or customer company name. Returns transaction count, total quantity, total charge, ...

Ferc Eqr Search Utilities

Search FERC Form 1 utility filers by name. Returns utility_id, state, latest report year, and filing date. Use before ferc_eqr_get_utility_financials ...

Frequently Asked Questions

What is the FERC EQR & Form 1 MCP server?

Search FERC Electric Quarterly Report wholesale power contracts and aggregated transaction price/quantity rollups, plus FERC Form 1 utility financials. Materialized from Catalyst Cooperative PUDL parquet (CC BY 4.0). It provides 5 tools that AI agents can use through the Model Context Protocol (MCP).

How do I connect FERC EQR & Form 1 to my AI agent?

Add the MCPBundles server URL to your MCP client configuration (Claude Desktop, Cursor, VS Code, etc.). The URL format is: https://mcp.mcpbundles.com/bundle/ferc-eqr. Authentication is handled automatically.

How many tools does FERC EQR & Form 1 provide?

FERC EQR & Form 1 provides 5 tools that can be called by AI agents, along with a SKILL.md that gives your AI agent domain knowledge about when and how to use them.

What authentication does FERC EQR & Form 1 require?

FERC EQR & Form 1 uses open data APIs — no authentication required.

Setup Instructions

Connect FERC EQR & Form 1 to any MCP client in minutes

MCP URL
https://mcp.mcpbundles.com/bundle/ferc-eqr

One-click install:

The link prefills the Add custom connector dialog — you still review the values and click Add, then Connect to complete OAuth.

Or add manually

  1. Open claude.ai → Settings → Connectors.
  2. Click the + button and choose Add custom connector.
  3. Set Name to FERC EQR & Form 1 and paste the MCP URL into Remote MCP server URL.
  4. Click Add. FERC EQR & Form 1 will appear under Not connected — select it and click Connect to complete OAuth.
Name: FERC EQR & Form 1
Remote MCP server URL: https://mcp.mcpbundles.com/bundle/ferc-eqr
Authentication: OAuth

Custom connectors at claude.ai require a paid Claude plan (Pro, Max, Team, or Enterprise).

Other ways to use FERC EQR & Form 1

Same data, different audiences.

Dataset

FERC EQR Power Contracts — live data product, refresh cadence + sources documented.

Open dataset
REST API

Call every tool from your own backend. OpenAPI spec + cURL examples.

Open API docs

Try FERC EQR & Form 1 now

No API key or third-party login required. Chat with AI and run tools instantly.