NYSgptData LibraryConnectPricing

Contract opportunities

Contract opportunity notices: the current file and every fiscal-year archive.

8.3MRecords
1Tables
49Fields
1969–2029Years

Publisher: General Services Administration, SAM.gov

Try it

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

Tables
Fields in sam_opportunities
FieldTypeExample
noticeidstringd45af4c8a293338c8a115581354b7b21
titlestringG--Keyboardist- Catholic Services, 1200 SUN MCAS Futenma
solstringM6740010T0104
departmentindagencystringDEPT OF DEFENSE
cgacstring017
subtierstringDEPT OF THE NAVY
fpds_codestring1700
officestringCOMMANDING OFFICER
aac_codestringM67400
posteddatestring2029-12-20 01:18:21
typestringPresolicitation
basetypestringPresolicitation
archivetypestringautocustom
archivedatestring2010-06-05
setasidecodestringSBA
setasidestringSmall Business Set Aside - Total
responsedeadlinestring2010-05-21T00:00:00-05:00
naicscodestring923110
classificationcodestringG
popstreetaddressstringUSDA, ARS, ERRC600 East Mermaid Lane Wyndmoor, PA 19038
popcitystring
popstatestring
popzipstring
popcountrystring
activestringNo
awardnumberstringF09607-02-D2001
awarddatestring2001-09-26
awardstringnot to exceed 95,562.50
awardeestringKing Moving and Storage1700 Cypress Street Valdosta, GA 3160
primarycontacttitlestringPurchasing Agent
primarycontactfullnamestringManetta B. Williams 011-81-611-745-3128 Manetta B. Williams/
primarycontactemailstringrdennis@errc.ars.usda.gov
primarycontactphonestring215-233-6553
primarycontactfaxstring215-233-6485
secondarycontacttitlestringContract Specialist
secondarycontactfullnamestringMaureen V Corpus
secondarycontactemailstringmaureen.corpus@moody.af.mil
secondarycontactphonestring229-257-4715
secondarycontactfaxstring229-257-4032
organizationtypestringOFFICE
statestringAP
citystringFPO
zipcodestring96371-9001
countrycodestringUSA
additionalinfolinkstring
linkstringhttps://sam.gov/workspace/contract/opp/d45af4c8a293338c8a115
descriptionstringThis is a pre-solicitation notice for commercial services pr
source_filestringFY2030_archived_opportunities.csv
fiscal_yearstring2030
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 Federal Spending