About Bts
Bts is an MCP server in the Science category: u.S. Bureau of Transportation Statistics (BTS) — data.bts.gov open-data portal (Socrata platform).
Install
From source
git clone https://github.com/pipeworx-io/mcp-btsThis server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.
Tools (3)
dataset_columnsList 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.
Parameters not published.
query_datasetQuery 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 not published.
search_datasetsSearch 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".
Parameters not published.
Ask AI
✦
Ask AI about Bts
Powered by Claude · Grounded in docs
I know everything about Bts. Ask me about installation, configuration, usage, or troubleshooting.
Security checks
6 checks have not been run yet.