query_dataset
ActiveTool of Bts
declared in 0.1.0
Query rows from a data.bts.gov dataset using SoQL. datasetId is the Socrata 4x4 code from search_datasets. SoQL clauses: $select (columns / aggregates like "count(*)" or "avg(air_fare)"), $where (SQL-like filter, e.g. "date > '2024-01-01' AND state='TX'"), $order ("date desc"), $group, $q (full-text across the row). Use dataset_columns first to learn field names. Returns an array of row objects keyed by field name. Default $limit is 50 (Socrata max per page is 50000).
Parameters schema
{
"type": "object",
"required": [
"datasetId"
],
"properties": {
"$q": {
"type": "string",
"description": "Full-text search across the whole row."
},
"$group": {
"type": "string",
"description": "Group-by field(s) for aggregation."
},
"$limit": {
"type": "number",
"description": "Rows to return (default 50)."
},
"$order": {
"type": "string",
"description": "Sort, e.g. \"date desc\"."
},
"$where": {
"type": "string",
"description": "SQL-like filter, e.g. \"date > '2024-01-01'\"."
},
"$offset": {
"type": "number",
"description": "Pagination offset (default 0)."
},
"$select": {
"type": "string",
"description": "Columns or aggregates, e.g. \"date, safety_general_aviation\"."
},
"datasetId": {
"type": "string",
"description": "Socrata 4x4 id, e.g. \"crem-w557\"."
}
}
}No endpoints wrapped at confidence ≥ 0.50.
Parent server
Bts
https://github.com/pipeworx-io/mcp-bts
1/7 registries