Connects Claude to the U.S. Bureau of Transportation Statistics open data portal, which runs on the Socrata platform and covers everything from airline performance to freight movement and safety statistics. Part of the Pipeworx gateway system that bundles 693+ data sources behind a streamable HTTP transport. The interesting bit is the ask_pipeworx function that interprets plain English questions and routes them to the appropriate BTS datasets without needing to know the underlying API structure. Useful when you're analyzing transportation trends, building logistics tools, or need programmatic access to federal transit data without dealing with Socrata's API directly.
U.S. Bureau of Transportation Statistics (BTS) — data.bts.gov open-data portal (Socrata platform).
Part of Pipeworx — an MCP gateway connecting AI agents to 693+ live data sources.
| Tool | Description |
|---|
Add to your MCP client (Claude Desktop, Cursor, Windsurf, etc.):
{
"mcpServers": {
"bts": {
"url": "https://gateway.pipeworx.io/bts/mcp"
}
}
}
Or connect to the full Pipeworx gateway for access to all 693+ data sources:
{
"mcpServers": {
"pipeworx": {
"url": "https://gateway.pipeworx.io/mcp"
}
}
}
Instead of calling tools directly, you can ask questions in plain English:
ask_pipeworx({ question: "your question about Bts data" })
The gateway picks the right tool and fills the arguments automatically.
MIT
com.mcparmory/google-sheets
domdomegg/google-sheets-mcp
henilcalagiya/google-sheets-mcp
cct15/war-dashboard-data
moooonad/mcp-google-sheets-full
io.github.br0ski777/csv-to-json