Skip to main content

FERC EQR and Form 1 in AI Agents: Wholesale Power Contracts, Prices, and Utility Financials

· 4 min read
Tony Lewis
MCPBundles
Ask AI:
PerplexityClaudeChatGPTGoogleGrok

TL;DR​

  • The FERC EQR & Form 1 MCP server materializes Electric Quarterly Report contracts and aggregated transaction price/quantity rollups plus Form 1 utility financials from Catalyst Cooperative PUDL — the bulk filings data.ferc.gov does not expose.
  • Ask for hyperscaler power buyers, long-term ENERGY contracts, $/MWh rollups, or utility operating revenue and the agent searches pre-loaded Postgres — no EQR Online export wrestling.
  • Pair with the FERC Open Data server for market-based rate authorizations and entity–PPA links on the live API.

Alex Joyce at Cascadia Partners filed a server request for exactly this: EQR and Form 1 for datacenter power-contract equity research. The open-data API ships MBR and PPAs; EQR and Form 1 live elsewhere. This connector closes that gap.

Contracts first, transactions when price matters​

EQR has two layers analysts care about.

Contracts answer who sells to whom, for what product, on what term, starting when. "Search FERC EQR contracts where the customer matches Amazon and product is ENERGY with long-term term" returns seller names, commencement dates, and tariff references across loaded quarters.

Transaction rollups answer what quantity moved at what price. Raw EQR transaction filings are billions of rows — we store quarterly rollups grouped by seller, customer, product, term, class, and delivery balancing authority. Each group carries transaction count, total quantity, total charge, min/max price, and a quantity-weighted average price.

"Search FERC EQR transactions where Microsoft is the customer, product ENERGY, term LT — show weighted average price and total quantity for the latest quarter" is the hyperscaler diligence pattern.

Form 1 for the utility balance sheet​

Form 1 annual filings cover major US utilities. The pipeline loads utility identification (name, state, latest report year) and four income-statement line items: operating revenues, net utility operating income, net income, and utility operating expenses.

Workflow: search by name, then pull financials for the utility ID. "Find Duke Energy in FERC Form 1 and return operating revenues and net income for the latest year" composes two tool calls.

Honest boundaries​

  • Not on data.ferc.gov — use ferc for the API catalog; use ferc-eqr for bulk EQR + Form 1.
  • Transaction rollups, not raw line items — every hourly tolling row is not in Postgres; aggregated price/quantity per party/product/quarter is.
  • Customer names are free text — sellers type buyer names inconsistently; fuzzy search helps but spelling varies.
  • PUDL attribution required — CC BY 4.0; original filings are FERC EQR and Form 1.

Connect and try it​

Enable FERC EQR & Form 1 in your workspace and open the try page. A solid opener: "What FERC EQR quarters are loaded? Then search transactions where the customer matches Microsoft and product is ENERGY."