MCP server exposing 3 tools for bts.
This URL is a JSON-RPC 2.0 endpoint over HTTP. Issue POST requests with a JSON-RPC body. Browsers and search crawlers land here on GET.
POST https://gateway.pipeworx.io/bts/mcp
Content-Type: application/json
{"jsonrpc":"2.0","id":1,"method":"tools/list"}search_datasets — Search datasets published on the U.S. Bureau of Transportation Statistics open-data portal (data.bts.gov). Returns each dataset's Socrata 4x4 id (e.g. "crem-w557"), name, and description. Use the id with dataset_columns and query_dataset. BTS covers aviation (passenger counts, on-time performance, air fares, airline financials), freight movement, transit ridership, border crossings, and transportation safety. Example queries: "aviation", "border crossing", "transit", "freight".dataset_columns — List the columns of a data.bts.gov dataset: field name (used in SoQL $select/$where), human label, and data type (number, text, calendar_date, etc.). Call this before query_dataset so you know which fields exist. datasetId is the Socrata 4x4 code from search_datasets.query_dataset — 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).Code samples (curl / TypeScript / one-click client install), schemas, and the live playground are on the pack page:
https://pipeworx.io/packs/bts/
Pipeworx is an open MCP gateway connecting AI agents to live data. pipeworx.io