Connects Claude to New York State's open data portal via the Socrata API. You get four core tools: search the dataset catalog, run SoQL queries against any resource, pull metadata, and grab distinct column values for exploration. Part of the Pipeworx gateway ecosystem, which means you can either point directly at this server or use the full gateway to access 670+ other data sources. Includes an ask_pipeworx wrapper that lets you query in plain English instead of calling tools manually. Useful when you need to analyze NY state datasets on things like budgets, health stats, or transit data without leaving your AI workflow.
data.ny.gov Socrata MCP.
Part of Pipeworx — an MCP gateway connecting AI agents to 673+ live data sources.
| Tool | Description |
|---|---|
datasets | Search dataset catalogue. |
query | SoQL query on a single resource. |
metadata | Resource metadata. |
column_data | Distinct values in a column. |
Add to your MCP client (Claude Desktop, Cursor, Windsurf, etc.):
{
"mcpServers": {
"data-ny": {
"url": "https://gateway.pipeworx.io/data-ny/mcp"
}
}
}
Or connect to the full Pipeworx gateway for access to all 673+ data sources:
{
"mcpServers": {
"pipeworx": {
"url": "https://gateway.pipeworx.io/mcp"
}
}
}
Instead of calling tools directly, you can ask questions in plain English:
ask_pipeworx({ question: "your question about Data Ny data" })
The gateway picks the right tool and fills the arguments automatically.
MIT
com.mcparmory/google-sheets
domdomegg/google-sheets-mcp
henilcalagiya/google-sheets-mcp
cct15/war-dashboard-data
moooonad/mcp-google-sheets-full
io.github.br0ski777/csv-to-json