FERC MCP Server

FERC

Federal energy regulatory data for wholesale power-contract and utility diligence — Electric Quarterly Reports (EQR), Form 1 utility financials, and data.ferc.gov open datasets (MBR authorizations, PPAs, company registration, NEPA).

MCPBundles supplies the FERC Open Data API key server-side. Enable this server once — no separate FERC sign-in.

Hyperscaler / datacenter power research

1. Dataset stats — EQR quarters loaded, row counts, last refresh (ferc_eqr_get_stats).
2. Search contracts — seller/customer names, product (ENERGY, CAPACITY), LT/ST term, contract dates.
3. Search transactions — aggregated price, quantity, and charge rollups 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.
5. Open Data catalog — MBR seller authorizations, entity-to-PPA links, company registration when the user needs portal datasets not in EQR.

EQR 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.

Open Data API (data.ferc.gov)

1. Catalog overview or find datasets by keyword before any row pull.
2. Get dataset details for row_count, freshness, and whether a dictionary exists.
3. Get dataset dictionary before wide pulls when available.
4. Get dataset data or search dataset rows with deliberate pagination — quote slice.fraction_examined on partial scans.

Dataset IDs can change over time. Always resolve the current ID from find/list before details, dictionary, or data.

Key EQR 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

Gotchas

• No server-side row filters on the Open Data API — only pagination via limit and offset.
• Row scan is slice-bounded — ferc_search_dataset_rows examines only part of large tables; quote coverage; never treat partial matches as a full cohort.
• Large Open Data tables (>5000 rows) require a field from ferc_get_dataset_dictionary before row scan.
• Open Data rate limit: ~1,000 requests per hour per API key. Prefer find + details + small page reads.
• EQR attribution: bulk EQR/Form 1 data via Catalyst Cooperative PUDL (CC BY 4.0). Original filings: FERC EQR and FERC Form 1.