NYSgptData LibraryConnectPricing

Other tables

Tables that support the application and fall outside the datasets above.

3.1MRecords
2Tables
1,905Fields
CurrentYears

Publisher:

Try it

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

Tables
Fields in submissions
FieldTypeExample
doctype_htmlstring <html lang="en">
column01string charset=ISO-8859-1" />
column02string"></div> -->
column03string">
column04string ?></span><button type="button" id="copyAzureCliBtn" class="
column05string" aria-label="Click to Copy AWS CLI" style="padding: 0px 5px
column06string border-width: 0px
column07string"><i class="fa fa-clone fa-rotate-270 me-2"></i></button>
column08string at times that look reasonable and to &quot
column09string1&quot
column10string at times that look obviously bad. Again, the data have not
column11stringbr&gt
column12string
column1string
column2string
column3string
column4string
column5string
column6string
column7string
column8string
column13string
column14string
column15string
column16string
column17string
column18string
column9string
column19string
column20string
column21string
column22string
column23string
column24string
column25string
column26string
column27string
column28string
column29string
column30string
column31string
column32string
column33string
column34string
column35string
column36string
column37string
column38string
column39string
column40string
column41string
column42string
column43string
column44string
column45string
column46string
column47string
column48string
column49string
column50string
column51string
column52string
column53string
column54string
column55string
column56string
column57string
column58string
column59string
column60string
column61string
column62string
column63string
column64string
column65string
column66string
column67string
column68string
column69string
column70string

1,821 more fields; select the table above to list them all.

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