query_dataset
Pack: bts · Endpoint: https://gateway.pipeworx.io/bts/mcp
Query rows from a data.bts.gov dataset using SoQL. datasetId is the Socrata 4x4 code from
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
datasetId | string | yes | Socrata 4x4 id, e.g. “crem-w557”. |
select | string | no | Columns or aggregates, e.g. “date, safety_general_aviation”. |
where | string | no | SQL-like filter, e.g. “date > ‘2024-01-01’”. |
order | string | no | Sort, e.g. “date desc”. |
group | string | no | Group-by field(s) for aggregation. |
q | string | no | Full-text search across the whole row. |
limit | number | no | Rows to return (default 50). |
offset | number | no | Pagination offset (default 0). |
Example call
curl -X POST https://gateway.pipeworx.io/bts/mcp \
-H 'Content-Type: application/json' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"query_dataset","arguments":{}}}'Connect
Add this to your MCP client config, or use one-click install buttons:
{
"mcpServers": {
"bts": {
"url": "https://gateway.pipeworx.io/bts/mcp"
}
}
}See Getting Started for client-specific install steps.