boston_query

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

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

NameTypeRequiredDescription
resource_idstringyesCKAN datastore resource id (UUID), e.g. “b973d8cb-eeb2-4e7e-99da-c92938efc9c0”.
qstringnoFree-text search across columns.
filtersobjectnoExact-match filters as a JSON object, e.g. {“district”:“B2”}.
sortstringnoSort clause, e.g. “OCCURRED_ON_DATE desc”.
limitnumbernoMax rows (default 100, max 1000).
offsetnumbernoRow 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, or use one-click install buttons:

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

See Getting Started for client-specific install steps.

Regenerated from source · build September 19, 2026