NYSgptData LibraryConnectPricing

Budget

Public Budget Database and Historical Tables, fiscal year 2027.

15.9KRecords
60Tables
2,697Fields
CurrentYears

Publisher: Office of Management and Budget

Try it

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

Tables
Fields in omb_budget_db_2_sheet
FieldTypeExample
agency_codestring001
agency_namestringLegislative Branch
bureau_codestring00
bureau_namestringLegislative Branch
account_codestring241400
account_namestringReceipts, Central fiscal operations
treasury_agency_codestring00
cgac_agency_codestring000
subfunction_codestring803
subfunction_titlestringCentral fiscal operations
bea_categorystringMandatory
grantnongrant_splitstringNongrant
on_or_off_budgetstringOn-budget
_1962string-628
_1963string-390
_1964string-469
_1965string-413
_1966string-410
_1967string-722
_1968string-464
_1969string-522
_1970string-439
_1971string-360
_1972string-343
_1973string-427
_1974string-539
_1975string-307
_1976string-287
tqstring-132
_1977string-429
_1978string-385
_1979string-726
_1980string0
_1981string0
_1982string0
_1983string0
_1984string0
_1985string0
_1986string0
_1987string0
_1988string0
_1989string0
_1990string0
_1991string0
_1992string0
_1993string0
_1994string0
_1995string0
_1996string0
_1997string0
_1998string0
_1999string0
_2000string0
_2001string0
_2002string0
_2003string0
_2004string0
_2005string0
_2006string0
_2007string0
_2008string0
_2009string0
_2010string0
_2011string0
_2012string0
_2013string0
_2014string0
_2015string0
_2016string0
_2017string0
_2018string0
_2019string0
_2020string0
_2021string0
_2022string0
_2023string0
_2024string0
_2025string0
_2026string0
_2027string0

5 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 Executive Branch