Skip to main content
Glama

NYSgpt Data Library

Server Details

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

If you are the author of this connector, you can claim ownership. Claimed connector authors can inspect health checks, view analytics, and manage their listing.
Status
Healthy
Uptime
100.0% over the last 24 hours
Last Tested
Transport
Streamable HTTP · MCP 2025-11-25
URL
Repository
nyd-user-1/nysgpt-data-library
GitHub Stars
0
ChatGPT
–
Claude
–

TDQS

A4.3/5.0

Scored across 4 tools

Disambiguation5/5

Each tool has a clearly distinct role in a natural discovery-to-query workflow: list databases, list tables within a database, describe a table's schema, then run SQL. There is no overlap between tools, and the descriptions reinforce the intended call order.

Naming Consistency4/5

Three tools follow a clean verb_noun snake_case pattern (list_databases, list_tables, describe_table), while 'query' is a bare verb rather than a noun-object name. The deviation is minor and the meaning remains obvious.

Tool Count5/5

Four tools is exactly the right scope for a read-only data library: database listing, table listing, schema inspection, and SQL execution. Each tool earns its place and there is no redundant surface.

Completeness4/5

The core discovery and query lifecycle is fully covered for a read-only Athena data library. Minor gaps include no cross-database keyword table search or sample-row preview, but agents can work around these using list_tables, describe_table, and query.

Available Tools

4 tools
describe_tableDescribe a tableA
Read-only
Inspect

Return the fields (name, type, description), the table description and the row count of one table. Always call this before writing SQL: many source columns are stored as text and need try_cast.

Inputs: table (required), database (required).

list_databasesList databasesA
Read-only
Inspect

List the databases in the NYSgpt Data Library. Each database is one subject of public records (for example govblock_awards = federal spending, govblock_patents, govblock_sec = company filings, govblock_scholarly = OpenAlex, govblock_labor, govblock_census, govblock_energy, govblock_health, govblock_courts). Call this first, then list_tables.

Inputs: no named parameters.

list_tablesList tablesA
Read-only
Inspect

List every table in one database with its row count. Use it to find the table that answers a question before calling describe_table.

Inputs: database (required).

queryRun SQLA
Read-only
Inspect

Run one read-only SQL statement (SELECT, WITH, SHOW or DESCRIBE) in the Amazon Athena (Trino) dialect and return up to 1,000 rows with column names and bytes scanned. Qualify every table as database.table. Select only the columns you need and filter on year or state columns where they exist, because each query has a scan limit (1 GB without a key, 10 GB with a paid key). Numeric text columns need try_cast(col AS double). When a daily limit is reached the error message gives the address for a paid key.

Inputs: sql (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      B
      quality
      D
      maintenance
      Query 20 structured datasets from AI agents — healthcare providers (9M NPI records), SEC EDGAR filings, PACER federal courts, USPTO patents and trademarks, OFAC sanctions screening, crypto whale wallets, DeFi liquidation signals, Polymarket smart money, economic indicators (FRED/BLS), federal contracts, NOAA weather, and OTC shell risk scoring. Pay per query, no subscriptions
      75
      1
      MIT
    • A
      license
      Not graded
      quality
      B
      maintenance
      Enables AI agents to query the IRS 990 nonprofit database and OpenRegs federal regulations database via SQL, providing access to nonprofit filings, grants, lobbying, and congressional data.
      Creative Commons Zero v1.0 Universal
    • A
      license
      Not graded
      quality
      C
      maintenance
      Enables querying, sampling, and exporting datasets from over twenty keyless free public data sources spanning the EU, Switzerland, Germany, the US, and global providers through one uniform set of tools. A single consistent interface lets users list databases and tables, inspect schemas and query guides, run queries, and export results as CSV or JSON without per-API clients.
      Apache 2.0
    • A
      license
      Not graded
      quality
      B
      maintenance
      Enables querying EPA drinking-water records — public water-system inventories, historical SDWA violations, enforcement actions, Lead and Copper Rule summaries, and UCMR 5 contaminant measurements — without an API key. Also supports optional read-only SQL analysis over staged dataset partitions via DuckDB canvases.
      146 npm
      2
      Apache 2.0
    Try in Browser

    Glama MCP Gateway

    Add one secure layer between your agents and this server.