`boston_query`

Pack: data-boston · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/boston_query for the schema, then POST the same URL with its arguments for the data.

Query any City of Boston datastore resource (data.boston.gov, CKAN) by its resource id (a UUID). Supports a free-text q, exact-match filters (field→value), sort (“field desc”), limit and offset. Use boston_datasets to find a resource id, or boston_recent for the common ones.

Parameters

Name	Type	Required	Description
`resource_id`	string	yes	CKAN datastore resource id (UUID), e.g. “b973d8cb-eeb2-4e7e-99da-c92938efc9c0”.
`q`	string	no	Free-text search across columns.
`filters`	object	no	Exact-match filters as a JSON object, e.g. {“district”:“B2”}.
`sort`	string	no	Sort clause, e.g. “OCCURRED_ON_DATE desc”.
`limit`	number	no	Max rows (default 100, max 1000).
`offset`	number	no	Row offset for paging.

Example call

Arguments

{
  "resource_id": "b973d8cb-eeb2-4e7e-99da-c92938efc9c0",
  "filters": {
    "district": "B2"
  },
  "sort": "OCCURRED_ON_DATE desc",
  "limit": 100
}

curl

curl -X POST https://gateway.pipeworx.io/data-boston/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"boston_query","arguments":{"resource_id":"b973d8cb-eeb2-4e7e-99da-c92938efc9c0","filters":{"district":"B2"},"sort":"OCCURRED_ON_DATE desc","limit":100}}}'

TypeScript (@pipeworx/sdk)

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

const result = await pipeworx.call('boston_query', {
  "resource_id": "b973d8cb-eeb2-4e7e-99da-c92938efc9c0",
  "filters": {
    "district": "B2"
  },
  "sort": "OCCURRED_ON_DATE desc",
  "limit": 100
});

More examples

{
  "resource_id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
  "q": "pothole",
  "limit": 50
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

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

Connect to just the data-boston pack

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

See Getting Started for client-specific install steps.

boston_query