Skip to main content
Glama
pipeworx-io

data-cityofnewyork

by pipeworx-io

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".

Related MCP server: CKAN MCP Server

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

License

MIT

A
license - permissive license
-
quality - not tested
C
maintenance

Maintenance

Maintainers
Response time
Release cycle
Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Servers

  • A
    license
    -
    quality
    C
    maintenance
    Enables querying UK Office for National Statistics datasets and their editions through natural language, with no authentication required.
    Last updated
    1
    MIT
  • A
    license
    A
    quality
    B
    maintenance
    Enables AI assistants to search, explore, and query any CKAN open data portal through natural language, making public datasets accessible without requiring knowledge of the portal's API.
    Last updated
    20
    315
    57
    MIT
  • A
    license
    -
    quality
    C
    maintenance
    Provides access to New Orleans open data (data.nola.gov) through the Socrata SODA API, enabling querying and retrieval of public datasets using natural language questions.
    Last updated
    24
    MIT

View all related MCP servers

Related MCP Connectors

  • Search and query government open-data portals (Socrata SODA API).

  • Gateway between LLM agents and world data through eight tools and a bundled endpoint catalog.

  • Access US federal award, recipient, agency, and spending analytics data from USAspending.gov.

View all MCP Connectors

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/pipeworx-io/mcp-data-cityofnewyork'

If you have feedback or need assistance with the MCP directory API, please join our Discord server