Sample and reference tables from five further operators.
Publisher: SPP, MISO, IESO, ISO New England and AESO
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| url | string | "https://portal.spp.org/chart-api/interchange-trend-swpw/asF |
| status | string | 200 |
| bytes | string | 249345 |
| key | string | "raw/spp/spp_west_interchange_real_time/2026/08/31/0fbb32829 |
| sha1_12 | string | "0fbb32829a94" |
| content_type | string | "text/csv" |
| fetched_at | string | "2026-08-31T15:48:02Z" |
| filename | string | /data/j/spp_west_interchange_real_time/x/2026/08/31/_index/1 |
Settings, Connectors, Add custom connector. Paste this address:
https://data.nysgpt.com/mcp
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp
curl -s https://data.nysgpt.com/query -H "content-type: application/json" \
-d '{"sql":"SELECT count(*) FROM govblock_awards.usaspending_contracts"}'Any MCP client works. The tools are list_databases, list_tables, describe_table and query (Athena SQL, read-only, up to 1,000 rows a query). With a paid key, add ?key=YOUR_KEY to the address or send the header X-Api-Key.
$1,500/month
20,000 queries and 1 TB scanned a day, for a lab, department or team.
SubscribePayment is by card through Stripe. The key appears on screen as soon as payment completes.