NYSgpt Data Library

com.nysgpt由 nysgpt.com 发布官方发布者v2.0.0更新于 Nov 17, 2026

SQL over 52.8B public records: USAspending, OpenAlex, patents, LEHD jobs, SEC, EPA, FERC, Medicare.

已验证Streamable HTTP可网页运行数据库网页搜索与抓取数据与分析

概览

AI 生成的概览

远程 MCP 服务器,让助手对 6,396 张预载表中的 528 亿条公共记录执行只读 SQL,涵盖联邦支出、专利、健康等数据。

可以做什么
  • 查看按主题划分的数据库及其表,并附行数
  • 查询某张表的字段、类型和说明
  • 每次调用执行一条只读 SQL 语句(Athena/Trino 方言),最多返回 1,000 行
  • 查询已预载的公共数据集,如 USAspending、OpenAlex、专利、LEHD 就业、SEC 申报、EPA、FERC 和 Medicare
适用场景
适合需要基于美国大型公共数据集回答问题、又不想下载或还原数据档案的场景,例如联邦支出、专利、学术、劳动力、能源、健康或法院记录。
运行要求
远程 streamable HTTP 端点,无需安装。需要访问密钥,通过 key 查询参数或 X-Api-Key 请求头传入。访问为付费服务,从日票起,并有每日查询次数与扫描数据量限制。
安装前请注意
每次调用都需要付费密钥,且受每日查询次数和扫描数据量上限约束。密钥会出现在 URL 或请求头中,避免写入共享日志。查询为只读,但结果是各发布方原样发布的公共记录,复用前请查看发布方条款;数值列常以文本存储。

安装

在 SourceWeft 中

  1. 打开 控制台中的 NYSgpt Data Library,将其添加到工作区。
  2. 为需要使用其工具的对话启用该服务。

Web executable,通过 Streamable HTTP。 远程服务在工作区中配置后即可从网页运行时运行。

交给智能体安装

把这段提示词粘贴到 Claude Code、Codex、Cursor 等智能体,或 SourceWeft 对话中。智能体会读取该服务器的安装指南,先向你展示发布者、端点和登录方式,经你同意后再把它添加到你的客户端。密钥不会写进任何命令。

阅读 https://sourceweft.com/mcp/com.nysgpt%2Fdata-library/install.md,并按其中说明把这个 MCP 服务器接入我的客户端。修改任何配置之前,先告诉我它的发布者、端点和登录方式,等我确认。不要把 API 密钥写进命令或我会提交的文件;问我密钥应从哪里获取。

查看智能体所依据的安装指南

其他 MCP 客户端

把它添加到你客户端的 mcpServers 配置中。

{
  "mcpServers": {
    "nysgpt-data-library": {
      "type": "http",
      "url": "https://data.nysgpt.com/mcp"
    }
  }
}

README

NYSgpt Data Library

52.8B public records in 6,396 SQL tables, queryable from Claude (or any MCP client) and over plain HTTP. Federal spending, patents, company filings, scholarly works, labor, census, energy, health, courts and more, already loaded and typed. Nothing to download or restore.

What people use it for

  • The full USAspending database in SQL without restoring the 177 GB PostgreSQL archive: transactions, awards, sub-awards, recipients and account balances.
  • OpenAlex in SQL: 465 million works with authors, institutions, funders and topics.
  • Every U.S. patent: PatentsView grants from 1976 and applications from 2001, claims, citations, assignments, examination history and office actions.
  • Jobs by census block (LEHD LODES): home-to-work flows and job counts, 2002 to 2024, 15.6 billion rows.
  • SEC financial statements, 13F holdings and insider transactions, EPA facility and emissions data, FERC electricity sales, Medicare payments and cost reports, IRS and Form 5500 filings, court opinions.

Connect

Claude (claude.ai or desktop): Settings, Connectors, Add custom connector, and paste https://data.nysgpt.com/mcp?key=YOUR_KEY.

Claude Code:

bash
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp --header "X-Api-Key: YOUR_KEY"

Cursor, VS Code and other MCP clients (mcp.json):

json
{ "mcpServers": { "nysgpt-data": { "url": "https://data.nysgpt.com/mcp?key=YOUR_KEY" } } }

HTTP:

bash
curl -s https://data.nysgpt.com/query -H 'X-Api-Key: YOUR_KEY' -H 'content-type: application/json' \  -d '{"sql":"SELECT publication_year, count(*) AS works FROM govblock_scholarly.openalex_works WHERE publication_year >= 2020 GROUP BY 1 ORDER BY 1"}'

Tools

ToolWhat it does
list_databasesThe databases, one per subject
list_tablesTables in a database, with row counts
describe_tableFields, types and description of a table
queryOne read-only SQL statement (Athena/Trino dialect), up to 1,000 rows

HTTP equivalents: GET /databases, GET /tables?database=, GET /table?database=&table=, POST /query.

Example

sql
SELECT awarding_toptier_agency_name AS agency, count(*) AS awards,       round(sum(try_cast(total_obligation AS double))/1e9, 1) AS obligated_billionsFROM govblock_awards.usaspending_db_rpt_award_searchWHERE fiscal_year = '2025'GROUP BY 1 ORDER BY 3 DESC LIMIT 5
agencyawardsobligated_billions
Department of Health and Human Services87,5481,985.9
Social Security Administration310,8841,634.6
Department of Defense3,950,955903.7
Department of Veterans Affairs491,843289.4
Department of Agriculture2,626,893231.6

More in examples/.

Largest datasets

DatasetSubjectRecordsTablesPublisher
Jobs by census block (LEHD)Labor15.6B4Census Bureau, Longitudinal Employer-Household Dynamics
American Community SurveyCensus and Geography12.7B4Census Bureau
FERC electricity sales reportsElectricity Grid and Energy5.4B4Federal Energy Regulatory Commission, through the PUDL project
New York (NYISO)Electricity Grid and Energy1.6B54New York Independent System Operator
PubMedHealth1.4B7National Library of Medicine
USAspending databaseFederal Spending1.2B79U.S. Department of the Treasury, Bureau of the Fiscal Service
Hospital and facility cost reportsHealth1.2B45Centers for Medicare and Medicaid Services
Power plant emissionsEnvironment1B2Environmental Protection Agency, Clean Air Markets
Patent Examination Research DatasetPatents998M15USPTO Office of the Chief Economist
Texas (ERCOT)Electricity Grid and Energy978M675Electric Reliability Council of Texas
Financial Statement and Notes data setsCompany Filings869M8SEC Division of Economic and Risk Analysis
PatentsView, granted patentsPatents821M41USPTO PatentsView
Care Compare quality and staffingHealth671M1073Centers for Medicare and Medicaid Services
OpenAlexScholarly Works586M21OpenAlex
Wind measurements and turbinesElectricity Grid and Energy581M53U.S. Geological Survey; published research datasets
Quarterly Census of Employment and WagesLabor502M7Bureau of Labor Statistics
Medicare payments by providerHealth487M16Centers for Medicare and Medicaid Services
Monthly merchandise tradeTrade460M23Census Bureau
PatentsView, pre-grant publicationsPatents394M30USPTO PatentsView
Trademark case filesTrademarks384M17USPTO Office of the Chief Economist
ClaimsPatents325M6USPTO Office of the Chief Economist
Home Mortgage Disclosure ActMortgage Lending and Banks312M6Consumer Financial Protection Bureau; Federal Financial Institutions Examination Council
Licences and applicationsConsumer Protection and Communications304M115Federal Communications Commission
Precinct returnsElections269M4MIT Election Data and Science Lab; OpenElections; Voting and Election Science Team; local election offices
EIA bulk seriesElectricity Grid and Energy261M41U.S. Energy Information Administration
Financial Statement Data SetsCompany Filings241M4SEC Division of Economic and Risk Analysis
Award files by fiscal yearFederal Spending228M2U.S. Department of the Treasury, Bureau of the Fiscal Service
Employee benefit plans (Form 5500)Nonprofits and Benefit Plans197M94U.S. Department of Labor, Employee Benefits Security Administration
Opinions and citationsCourts143M8Free Law Project
Classification master filesPatents142M2USPTO bulk data
Medicaid drug utilization and pricesHealth141M12Centers for Medicare and Medicaid Services
AssignmentsPatents136M8USPTO assignment records
Company factsCompany Filings127M2SEC EDGAR
Institutional holdings (Form 13F)Company Filings126M7SEC
Common Core of DataEducation110M200National Center for Education Statistics
USAspending database, publisher's subsetFederal Spending106M79U.S. Department of the Treasury, Bureau of the Fiscal Service
Open PaymentsHealth95.9M5Centers for Medicare and Medicaid Services
Office actionsPatents86.5M4USPTO Office of the Chief Economist and USPTO bulk data
Health plansHealth86.3M127Centers for Medicare and Medicaid Services
FERC financial formsElectricity Grid and Energy82.2M1139Federal Energy Regulatory Commission, through the PUDL project
Bulk filesFederal Campaign Finance79.5M7Federal Election Commission
DocketsCourts74.1M2Free Law Project
Artificial intelligence patent datasetPatents61.8M2USPTO Office of the Chief Economist
Filing index and company historiesCompany Filings57.1M4SEC EDGAR
Drug and device safetyHealth57M31Food and Drug Administration

All 132 datasets, with every table and field: https://nysgpt.com/data

Limits and plans

PlanPriceQueries a dayData scanned a day
Day pass$29300100 GB
Monthly$149 a month2,000200 GB
Institution$1,500 a month20,0001 TB

Every call needs a key: add ?key=YOUR_KEY to the MCP address or send the header X-Api-Key.

Notes

  • Queries are read-only: SELECT, WITH, SHOW, DESCRIBE.
  • Many source files are loaded as published, so numeric columns are often text; use try_cast.
  • The data is public records as issued by each publisher. Each dataset page names its publisher. Check the publisher's terms for your use.
  • Questions and requests for datasets: open an issue here.

来源:README.md,提交 e862d22

工具

0
SourceWeft 尚未读取此服务器的工具。

版本历史

1
  1. v2.0.0最新Nov 17, 2026

评分

已满足适用检查项的 75%

该评分衡量此收录条目的完整程度,依据注册中心条目、端点与公开来源计算得出。它不是对服务器本身的评价,也不表示服务器安全或当前可用:可连通性是带日期的检查结果,评分也不包含安装量或用户评价。

  • 近 30 天内可连通必需25 分
  • 已声明认证方式必需10 分
  • 已列出工具必需15 分

    请让服务器在无凭据时响应 tools/list,或发布可在沙箱中无凭据启动的软件包。

  • 描述必需15 分
  • 图标10 分
  • 文档15 分
  • 许可证10 分

    请在仓库或注册中心条目中声明许可证。