# Data Ny

> Data Ny is a freemium MCP server for legal and government. Search and query New York State open-data datasets from data.ny.gov via MCP. It can run locally on your machine or as a hosted remote server.

- **Kind:** MCP server
- **Pricing:** Freemium
- **Platforms:** API, CLI, self-hosted
- **Website:** https://pipeworx.io/packs/data-ny
- **Repository:** https://github.com/pipeworx-io/mcp-data-ny
- **MCP Registry name:** io.github.pipeworx-io/data-ny
- **Categories:** [legal and government](https://ai-powered.com/categories/legal-and-government)
- **Listing updated:** 2026-11-18

## About

The README describes this as a keyless bridge to the data.ny.gov Socrata portal, where state agencies publish public datasets. Four pack-specific tools cover catalogue search, resource metadata, distinct column values, and SoQL queries against a single dataset identified by its four-by-four resource ID.

The server is hosted on the Pipeworx gateway, so calls go through a remote streamable-HTTP endpoint or a local npm stdio bridge. The README says anonymous use is capped at 50 calls a day, and a free Pipeworx account raises that to 200. The endpoint also lists shared gateway meta-tools such as ask_pipeworx alongside the pack's own tools.

It suits developers and analysts who want an assistant to pull New York State figures without writing Socrata API calls by hand. The pricing page gives rate cards for paid use, but this pack is listed under government open data.

## Features

- **Dataset catalogue search:** Finds state open-data datasets by keyword, with paging via limit and offset.
- **SoQL resource queries:** Runs SoQL-style filters, selections, grouping and ordering against one dataset.
- **Resource metadata lookup:** Returns descriptive metadata for a dataset identified by its four-by-four ID.
- **Distinct column values:** Lists the unique values held in a chosen column to help build filters.
- **Keyless upstream access:** The README says the data.ny.gov source needs no API key.

## Good for

- Finding state datasets on a topic before downloading or analysing them
- Checking which values a column contains before writing a filter
- Pulling counts or grouped totals from a New York State dataset inside an assistant
- Asking plain-English questions about state data via ask_pipeworx

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http data-ny https://gateway.pipeworx.io/data-ny/mcp
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://gateway.pipeworx.io/data-ny/mcp
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "data-ny": {
      "url": "https://gateway.pipeworx.io/data-ny/mcp"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "data-ny": {
      "type": "http",
      "url": "https://gateway.pipeworx.io/data-ny/mcp"
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "data-ny": {
      "serverUrl": "https://gateway.pipeworx.io/data-ny/mcp"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "data-ny": {
      "type": "http",
      "url": "https://gateway.pipeworx.io/data-ny/mcp"
    }
  }
}
```

## Tools

- `datasets`: Search dataset catalogue
- `query`: SoQL query on a single resource
- `metadata`: Resource metadata
- `column_data`: Distinct values in a column

## FAQ

### Does it need an API key?

The upstream data.ny.gov source is keyless. The README says a free Pipeworx key is optional and raises the daily call cap from 50 to 200.

### How do I identify a dataset?

The README says resource_id is the four-by-four code, for example xj2p-gjci.

### Does the endpoint list only four tools?

No. The README says tools/list also returns shared Pipeworx meta-tools such as ask_pipeworx, alongside the pack's own tools.

### Is Data Ny free?

Data Ny has a free plan, with paid plans for more usage or features.

### How do I add Data Ny to Claude Code?

Run this command in your terminal: claude mcp add --transport http data-ny https://gateway.pipeworx.io/data-ny/mcp

### What are the best alternatives to Data Ny?

The closest alternatives to Data Ny are Data Cityofchicago, Data Govt Nz, Datos Gob Es, Data Europa and Datos Cl.

## Where this comes from

- Description: written from the project's README, the project's website and its MCP Registry entry.
- Install steps: from the official MCP Registry entry.

## Alternatives

- [Data Cityofchicago](https://ai-powered.com/mcp/data-cityofchicago): Data Cityofchicago is a freemium MCP server for legal and government.
- [Data Govt Nz](https://ai-powered.com/mcp/data-govt-nz): Data Govt Nz is a freemium MCP server for legal and government.
- [Datos Gob Es](https://ai-powered.com/mcp/datos-gob-es): Datos Gob Es is a freemium MCP server for legal and government.
- [Data Europa](https://ai-powered.com/mcp/data-europa): Data Europa is a freemium MCP server for legal and government.
- [Datos Cl](https://ai-powered.com/mcp/datos-cl): Datos Cl is a freemium MCP server for legal and government.
- [publicdata.au](https://ai-powered.com/mcp/publicdata-au): publicdata.au is a free MCP server for analytics and data.

---
Source: https://ai-powered.com/mcp/data-ny
