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