Locational prices, loads, intertie flows, fuel mix, renewables and interconnection requests.
Publisher: California Independent System Operator
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| mkt_type | string | DAM |
| interval_start_gmt | string | 2026-08-30T23:00:00-00:00 |
| interval_end_gmt | string | 2026-08-31T00:00:00-00:00 |
| node | string | 0096WD_7_N001 |
| product | string | IRD |
| marginal_clearing_price | string | 0.13064 |
| capacity_price | string | 0.13064 |
| congestion_price | string | 0 |
| loss_price | string | 0 |
| _group | string | 1 |
| filename | string | /data/j/caiso_ir_rc_prices/x/2026/08/30/047b587a7656_z/20260 |
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.