MCP server

Bts

io.github.pipeworx-io/bts

Checked 26 Oct 2026, 08:29 UTC · Connected to it and listed its tools

U.S. Bureau of Transportation Statistics (BTS) — data.bts.gov open-data portal (Socrata platform).

Website Source

At a glance

Type

MCP server

Publisher

pipeworx.io (verified by the MCP Registry)

Status

Working at last check

Tools

45

Token cost

About 27,130 tokens per request

Sets up in

Claude Code, Claude Desktop, Codex, Gemini CLI, Cursor, VS Code, Antigravity, ChatGPT, OpenAI API, Grok

Last checked

26 Oct 2026, 08:29 UTC

Connect it to your agent

Add to CursorAdd to VS CodeVS Code Insiders

Opens the app, which shows the server and asks you to confirm. For other apps, copy the setup below.

Claude Code

claude mcp add --transport http bts https://gateway.pipeworx.io/bts/mcp

Claude Desktop

Settings → Connectors → Add custom connector, and paste the URL.

Codex (config.toml)

[mcp_servers.bts]
url = "https://gateway.pipeworx.io/bts/mcp"

Gemini CLI

{"mcpServers":{"bts":{"httpUrl":"https://gateway.pipeworx.io/bts/mcp"}}}

Cursor

{"mcpServers":{"bts":{"url":"https://gateway.pipeworx.io/bts/mcp"}}}

VS Code

{"servers":{"bts":{"type":"http","url":"https://gateway.pipeworx.io/bts/mcp"}}}

Antigravity

agy mcp add bts https://gateway.pipeworx.io/bts/mcp

ChatGPT

Settings → Apps & Connectors → Advanced settings: turn on Developer mode, then Create a connector and paste the URL. Which plans can do this varies.

OpenAI API (Responses tools)

{"type":"mcp","server_label":"bts","server_url":"https://gateway.pipeworx.io/bts/mcp","require_approval":"always"}

Grok (xAI API tools)

{"type":"mcp","server_label":"bts","server_url":"https://gateway.pipeworx.io/bts/mcp"}

Tools

• dataset_columns ~145 tokens
  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 ~418 tokens
  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
• search_datasets ~264 tokens
  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, a

Browse

• GitHub tools
• GitHub and code hosting
• Databases
• Travel and flights
• Government and public data

Related MCP servers

• Socrata
  Search and query government open-data portals (Socrata SODA API).
• Datos Co
  datos.gov.co — Colombia's national open-data portal (Socrata platform).
• Data Usdot
  US DOT Open Data (datahub.transportation.gov) Socrata MCP.
• Intelligence Gateway
  Unified MCP gateway to Algeria TKAWEN ecosystem: commerce, certification and AI tools.
• Opendata Cat
  15 Catalan portals + radio archive: gov, INE/REE/CNMC, CORA, Catalònica, radioteca.cat.
• Nova Scotia Data Explorer
  Query and explore Nova Scotia open datasets via the Socrata SODA API.
• Econdata
  Econdata MCP — wraps BLS (Bureau of Labor Statistics) public API v2…
• Kolmo
  WA permit rules (city + state baseline, cited), parcel zoning, L&I checks, Seattle estimates & ROI

Badge for your README

[![AptLynx](https://aptlynx.net/badge/io.github.pipeworx-io/bts.svg)](https://aptlynx.net/servers/io.github.pipeworx-io/bts)

Listing text is written by the maker; AptLynx lists tools and does not vouch for them. Find another tool · Browse by topic · For agents