Ferc Eqr MCP server

ferc-eqr

Who sells wholesale power to whom: FERC Electric Quarterly Report (EQR) filers, and the contracts between sellers and their counterparties.

Part of Pipeworx — an MCP gateway connecting AI agents to 1679+ live data sources.

Not the same thing as ferc-elibrary: that pack is FERC's docket/document search (filings, orders, opinions). This pack is the underlying filer and contract data — a different question entirely ("who sells to whom" vs. "what did FERC file").

Tools

Auth

None. No key, no account.

No personal data

The upstream source also carries filer CONTACT fields per company — a named individual's name, title, address, phone and email. None of that is loaded or returned by any tool. Only company-level identity (companyidferc, fileruniqueid, company_name) is kept.

Coverage is not automatically "everything since 2013"

The upstream data spans 2013q3 through the present, but this pack's coverage is loaded incrementally rather than all at once. Call eqrcoverage for the quarter range actually covered before treating an empty result as "no such contract"** — a result outside the covered range is a coverage gap, not a negative answer. Every tool's response says this too.

Data source, licence, attribution

FERC itself publishes Electric Quarterly Reports only as quarterly nested ZIP files, with no query interface of its own. Catalyst Cooperative's PUDL project — a widely-used open energy-data project — normalizes EQR into structured per-quarter tables and republishes them publicly.

Licence: "Copyright 2016-2026, Catalyst Cooperative, CC-BY-4.0" () — explicit on the DATA (their processing code carries a separate MIT licence, which is a different thing and does not govern the data). CC-BY-4.0 permits redistribution with attribution. Every tool response carries an attribution field; do not remove it if you touch this pack.

Refreshing

node scripts/ingest-ferc-eqr.mjs --since <yyyyqN>

Re-runnable and safe: rows upsert on a content hash of every loaded column, so loading an already-covered quarter again is a no-op rather than a duplicate. node scripts/ingest-ferc-eqr.mjs --dry-run [--since | --all] parses without writing anything, useful for checking a new quarter's row counts before committing to a load. listQuarters() discovers what's published live each run, so a newly published quarter needs no code change — just a wider --since.

Phase 1 vs Phase 2

Phase 1 (this pack): filer identity, index-price-publisher reporting, and contract terms — one row per contract RATE-PERIOD line item, not one row per contract (a single contract can carry several rows for different rate periods over its life). A quantity or rate returned here comes from the CONTRACT's stated terms, not from a settled trade.

Shortened. The full README is on GitHub.