NYSgptData LibraryConnectPricing

New York (NYISO)

Locational prices, loads, interface flows, fuel mix, ancillary services, limiting constraints and behind-the-meter solar.

1.6BRecords
54Tables
436Fields
CurrentYears

Publisher: New York Independent System Operator

Try it

This runs against the full table, free, with no key.

Tables
nyiso_lmp_real_time_5_min_realtime_gen1.2Bnyiso_lmp_real_time_hourly_rtlbmp_gen120Mnyiso_area_control_error_ace61.4Mnyiso_lmp_day_ahead_hourly_mlbmp_gen52.9Mnyiso_interface_limits_and_flows_5_min_externallimitsflows43Mnyiso_lmp_real_time_5_min_realtime_zone30.5Mnyiso_load_pal25.3Mnyiso_load_raw_pal25.2Mnyiso_as_prices_real_time_5_min_rtasp12Mnyiso_fuel_mix_rtfuelmix8.4Mnyiso_fuel_mix_raw_rtfuelmix6.5Mnyiso_lmp_real_time_hourly_rtlbmp_zone3.5Mnyiso_limiting_constraints_real_time_limitingconstraints3.4Mnyiso_zonal_load_hourly_palintegrated2.4Mnyiso_lake_erie_circulation_real_time_eriecirculationrt1.8Mnyiso_load_forecast_hourly_isolf1.4Mnyiso_load_forecast_isolf1.4Mnyiso_zonal_load_forecast_hourly_isolf1.4Mnyiso_lmp_day_ahead_hourly_mlbmp_zone1.3Mnyiso_as_prices_day_ahead_hourly_masp983Knyiso_limiting_constraints_day_ahead_mlimitingconstraints732Knyiso_btm_solar_forecast_btmdaforecast605Knyiso_btm_solar_btmestimatedactual600Knyiso_lake_erie_circulation_day_ahead_eriecirculationda152Knyiso_interface_limits_and_flows_5_min54.4Knyiso_as_prices_real_time_5_min49.9Knyiso_load28.9Knyiso_load_raw28.9Knyiso_fuel_mix19.1Knyiso_fuel_mix_raw19.1Knyiso_lmp_day_ahead_hourly18.3Knyiso_lmp_real_time_hourly16Knyiso_btm_installed_capacity_btminstalledcapacitytracking14.8Knyiso_lmp_real_time_hourly_tlbmp_gen10Knyiso_lake_erie_circulation_real_time2.9Knyiso_as_prices_day_ahead_hourly1.8Knyiso_limiting_constraints_real_time1.7Knyiso_lmp_real_time_5_min1.3Knyiso_limiting_constraints_day_ahead565nyiso_zonal_load_hourly396nyiso_lmp_real_time_15_min292nyiso_btm_solar288nyiso_btm_solar_forecast288nyiso_area_control_error178nyiso_load_forecast144nyiso_load_forecast_hourly144nyiso_zonal_load_forecast_hourly144nyiso_btm_installed_capacity72nyiso_lake_erie_circulation_day_ahead24nyiso_capacity_prices14nyiso_generators12nyiso_status8nyiso_interconnection_queue7nyiso_generation_outages_forecast4
Fields in nyiso_lmp_real_time_5_min_realtime_gen
FieldTypeExample
time_stampstring01/25/2017 15:00:00
namestringGOWANUS_GT2_1
ptidstring24114
lbmp_mwhrstring28.19
marginal_cost_losses_mwhrstring2.79
marginal_cost_congestion_mwhrstring-0.01
filenamestring/data/j/nyiso_lmp_real_time_5_min/x/2017/01/01/a041aa2e9324_
Connect

Claude

Settings, Connectors, Add custom connector. Paste this address:

https://data.nysgpt.com/mcp

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp

HTTP

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.

Pricing

Free

$0

30 queries a day, 1 GB scanned per query. No key, no sign-up.

Connect

Day pass

$29

300 queries and 100 GB scanned in 24 hours. One payment.

Buy a day pass

Monthly

$149/month

2,000 queries and 200 GB scanned a day. Cancel any time.

Subscribe

Institution

$1,500/month

20,000 queries and 1 TB scanned a day, for a lab, department or team.

Subscribe

Payment is by card through Stripe. The key appears on screen as soon as payment completes.

More in Electricity Grid and Energy