mcp-data-cityofnewyork

NYC Open Data — US government open data (data.cityofnewyork.us) via the Socrata SoQL API: NYC agencies — 311, transportation, housing, permits, crime & health. Keyless.

Part of Pipeworx — an MCP gateway connecting AI agents to 940+ live data sources.

Tools

| Tool | Description | |------|-------------| | datasets | Search the NYC Open Data catalog of open datasets by keyword. Returns each dataset's resource_id, name, description, category and update date — pass the resource_id to query/metadata. | | query | Run a Socrata SoQL query against a NYC Open Data dataset by resource_id (e.g. "8wbx-tsch"). Filter with where/select/group/order (SoQL clauses, without the leading $) plus limit/offset. Returns matching rows as JSON. | | metadata | Get a NYC Open Data dataset's schema + metadata (columns, types, row count, category, last-updated) by resource_id, e.g. "8wbx-tsch". |

Quick Start

Add to your MCP client (Claude Desktop, Cursor, Windsurf, etc.):

{
  "mcpServers": {
    "data-cityofnewyork": {
      "url": "https://gateway.pipeworx.io/data-cityofnewyork/mcp"
    }
  }
}

Or connect to the full Pipeworx gateway for access to all 940+ data sources:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://gateway.pipeworx.io/mcp"
    }
  }
}

Using with ask_pipeworx

Instead of calling tools directly, you can ask questions in plain English:

ask_pipeworx({ question: "your question about Data Cityofnewyork data" })

The gateway picks the right tool and fills the arguments automatically.

More

• All tools and guides
• pipeworx.io

License

MIT