Spp MCP server

@pipeworx/spp

SPP (Southwest Power Pool) real-time electricity data — generation mix, load and renewable forecast vs actual, five-minute LMPs, and the raw Marketplace file archive back to 2013, for the 14-state footprint from the Texas panhandle to North Dakota.

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

Tools

(coal, gas, nuclear, wind, solar, hydro, diesel fuel oil, energy storage, waste heat, waste disposal, other) plus total load. detailed: true splits each fuel into its Market and Self-scheduled halves over a rolling 365-day feed.

• sppgenerationmix(limit?, detailed?) — MW per fuel per 5-minute interval

and solar forecasts (STLF/MTLF, STWF/MTWF, STSF/MTSF) against actual load, wind and solar.

• spploadforecast(limit?, include_future?) — short- and mid-term load, wind

interval, per settlement location (~1,600), with LMP split into MEC / MCC / MLC.

• spplmplatest(location?, limit?) — the most recently published RTBM 5-minute

Marketplace file archive directly, for a specific historical interval or day.

• spp_files(dataset, path?, download?, limit?) — browse or download the

Auth

Keyless. No registration.

Data sources

vs self-scheduled.

• — current-day generation mix CSV.
• — rolling 365-day, market

forecast vs actual CSV.

• — load/wind/solar

— JSON directory listing of the Marketplace archive.

• &path=&type=folder>

• ?path=> — the file.

Traps

Call portal.spp.org directly so a Worker fetch never depends on redirect handling.

• marketplace.spp.org 302-redirects to portal.spp.org for every API path.

first ~2,000 rows are future intervals with every value blank. A naive rows[0] returns a row of nulls as a clean success. Measured 2026-09-17: 2,017 forecast-only rows in front of 287 settled ones. spploadforecast splits on "does this row have an Actual Load", reports latestactual from the newest settled row, and exposes forecastonly_intervals so the caller can see the split. This is the pack's main reason for existing over a raw CSV fetch.

• The load-forecast CSV is published a week ahead and is newest-first, so the

FILENAMES (RTBM-LMP-SL-202609171905.csv) are Central. Mixing them shifts you five or six hours. Inside the LMP file, Interval is Central and GMTIntervalEnd is UTC.

• Two timezones in one dataset. gen-mix timestamps are GMT; the LMP archive

interval a few minutes late, so the filename for right now is usually a 404. spplmplatest lists the day's By_Interval folder and takes the newest file that exists, falling back to the previous day just after midnight CT.

• Don't compute the "current" LMP filename. SPP publishes each 5-minute

X-SPP-UI-Token header; the server does not require it (verified 2026-09-17), so this pack sends none rather than forge one.

• The file-listing endpoint needs no token. SPP's own UI sends an

• Blank means unknown, not zero. num() returns null for an empty cell.

Quick Start

Add to your MCP client (Claude Desktop, Cursor, Windsurf, etc.):

{
  "mcpServers": {
    "spp": {
      "url": "https://gateway.pipeworx.io/spp/mcp"
    }
  }
}

What this endpoint actually serves

Shortened. The full README is on GitHub.