NYSgptData LibraryConnectPricing

OpenAlex

Works, authors, awards, sources, institutions, funders, publishers, topics, concepts and reference lists.

586MRecords
21Tables
398Fields
CurrentYears

Publisher: OpenAlex

Try it

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

Tables
Fields in openalex_works
FieldTypeExample
idstringhttps://openalex.org/W4415673682
doistringhttps://doi.org/10.16929/ajas/11/2
titlestringGalactic Gold Rush: The Promise and Perils of Mining Beyond
display_namestringGalactic Gold Rush: The Promise and Perils of Mining Beyond
idsmap<string,string>{openalex=https://openalex.org/W4415673682, doi=https://doi.
indexed_inarray<string>[crossref]
publication_datedate2024-07-01
publication_yearint2024
languagestringen
typestringparatext
authorshipsarray<struct<author:struct<display_name:string,id:string,orcid:string,observed_orcids:array<string>>,author_position:string,affiliations:array<struct<institution_ids:array<string>,raw_affiliation_string:string>>,countries:array<string>,raw_author_name:string,raw_orcid:string,is_corresponding:boolean,raw_affiliation_strings:array<string>,institutions:array<struct<country_code:string,display_name:string,id:string,lineage:array<string>,ror:string,type:string>>>>[]
authors_countint0
corresponding_author_idsarray<string>[]
corresponding_institution_idsarray<string>[]
primary_topicstruct<id:string,display_name:string,score:float,subfield:struct<id:string,display_name:string>,field:struct<id:string,display_name:string>,domain:struct<id:string,display_name:string>>{id=https://openalex.org/T12717, display_name=Space explorat
topicsarray<struct<id:string,display_name:string,score:float,subfield:struct<id:string,display_name:string>,field:struct<id:string,display_name:string>,domain:struct<id:string,display_name:string>>>[]
keywordsarray<struct<id:string,display_name:string,score:float>>[]
conceptsarray<struct<id:string,wikidata:string,display_name:string,level:int,score:float>>[]
locationsarray<struct<id:string,doi:string,source:struct<id:string,display_name:string,issn_l:string,issn:array<string>,is_oa:boolean,is_in_doaj:boolean,is_core:boolean,listed_in:array<string>,host_organization:string,host_organization_name:string,host_organization_lineage:array<string>,host_organization_lineage_names:array<string>,type:string>,is_oa:boolean,is_published:boolean,landing_page_url:string,pdf_url:string,raw_source_name:string,raw_type:string,provenance:string,license:string,license_id:string,version:string,is_accepted:boolean>>[{id=10.16929/ajas/11/2, doi=https://doi.org/10.16929/ajas/1
locations_countint2
primary_locationstruct<id:string,doi:string,source:struct<id:string,display_name:string,issn_l:string,issn:array<string>,is_oa:boolean,is_in_doaj:boolean,is_core:boolean,listed_in:array<string>,host_organization:string,host_organization_name:string,host_organization_lineage:array<string>,host_organization_lineage_names:array<string>,type:string>,is_oa:boolean,is_published:boolean,landing_page_url:string,pdf_url:string,raw_source_name:string,raw_type:string,provenance:string,license:string,license_id:string,version:string,is_accepted:boolean>{id=10.16929/ajas/11/2, doi=https://doi.org/10.16929/ajas/11
best_oa_locationstruct<id:string,doi:string,source:struct<id:string,display_name:string,issn_l:string,issn:array<string>,is_oa:boolean,is_in_doaj:boolean,is_core:boolean,listed_in:array<string>,host_organization:string,host_organization_name:string,host_organization_lineage:array<string>,host_organization_lineage_names:array<string>,type:string>,is_oa:boolean,is_published:boolean,landing_page_url:string,pdf_url:string,raw_source_name:string,raw_type:string,provenance:string,license:string,license_id:string,version:string,is_accepted:boolean>{id=null, doi=null, source=null, is_oa=null, is_published=nu
sustainable_development_goalsarray<struct<id:string,display_name:string,score:double>>[]
study_designsarray<struct<id:string,display_name:string>>[]
awardsarray<struct<id:string,display_name:string,funder_award_id:string,funder_id:string,funder_display_name:string>>[]
fundersarray<struct<id:string,display_name:string,ror:string>>[]
institutionsarray<struct<id:string,display_name:string,ror:string,country_code:string,type:string,lineage:array<string>>>[]
countries_distinct_countint0
institutions_distinct_countint0
open_accessstruct<is_oa:boolean,oa_status:string,any_repository_has_fulltext:boolean,oa_url:string>{is_oa=false, oa_status=closed, any_repository_has_fulltext=
is_paratextbooleantrue
is_retractedbooleanfalse
is_xpacbooleanfalse
bibliostruct<volume:string,issue:string,first_page:string,last_page:string>{volume=11, issue=2, first_page=null, last_page=null}
volumestruct<id:string,display_name:string>
referenced_worksarray<string>[]
referenced_works_countint0
related_worksarray<string>[]
abstract_inverted_indexstring{"'Pluriversos": [0], "en": [1], "la": [2, 13, 20, 34, 40, 5
cited_by_countint0
counts_by_yeararray<struct<year:int,cited_by_count:int>>[]
apc_liststruct<value:int,currency:string,value_usd:int>{value=400, currency=BRL, value_usd=76}
apc_paidstruct<value:double,currency:string,value_usd:double>{value=400.0, currency=BRL, value_usd=76.0}
fwcidouble0.0
citation_normalized_percentilestruct<value:double,is_in_top_1_percent:boolean,is_in_top_10_percent:boolean>{value=0.12963242, is_in_top_1_percent=false, is_in_top_10_p
cited_by_percentile_yearstruct<min:int,max:int>{min=90, max=94}
mesharray<struct<descriptor_ui:string,descriptor_name:string,qualifier_ui:string,qualifier_name:string,is_major_topic:boolean>>[]
has_contentstruct<pdf:boolean,grobid_xml:boolean>{pdf=false, grobid_xml=false}
has_fulltextbooleanfalse
created_datetimestamp2025-10-29 00:00:00.000
updated_datetimestamp2025-10-29 00:00:00.000
partition_datestring2025-10-29
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 Scholarly Works