`query`

Pack: data-ny · Endpoint: https://gateway.pipeworx.io/data-ny/mcp

SoQL query on a single resource.

Parameters

Name	Type	Required	Description
`resource_id`	string	yes	Socrata 4x4, e.g. “xj2p-gjci”
`where`	string	no	SoQL WHERE clause (without “WHERE”).
`select`	string	no
`group`	string	no
`order`	string	no
`limit`	number	no
`offset`	number	no

Example call

Arguments

{
  "resource_id": "xj2p-gjci",
  "where": "year = 2023",
  "limit": 100
}

curl

curl -X POST https://gateway.pipeworx.io/data-ny/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"query","arguments":{"resource_id":"xj2p-gjci","where":"year = 2023","limit":100}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('query', {
  "resource_id": "xj2p-gjci",
  "where": "year = 2023",
  "limit": 100
});

More examples

{
  "resource_id": "8n3z-qvya",
  "select": "complaint_type, count(*) as total",
  "group": "complaint_type",
  "order": "total DESC",
  "limit": 50
}

Response shape

Always returns: items, count

Field	Type	Description
`items`	array	Array of rows returned from SoQL query
`count`	integer	Number of items returned.

Full JSON Schema

{
  "type": "object",
  "properties": {
    "items": {
      "type": "array",
      "description": "Array of rows returned from SoQL query",
      "items": {
        "type": "object",
        "description": "Row object with column values"
      }
    },
    "count": {
      "type": "integer",
      "description": "Number of items returned."
    }
  },
  "required": [
    "items",
    "count"
  ]
}

Connect

Add this to your MCP client config, or use one-click install buttons:

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

See Getting Started for client-specific install steps.

query