fare-data MCP server
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@fare-data MCP serverShow me the cheapest business-class fares in MEX_LAX_28Jul.csv"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
fare-data MCP server
New here? Follow the step-by-step SETUP.md to get running.
Exposes ATPCO fare CSV snapshots (the ~119-column fare feed layout: CXR, ORIG, DEST, Fare Class, Fare AMT, Tax AMT, Total Price AMT, Cabin, restrictions, …) from a local folder to Claude via the Model Context Protocol, plus a live fare-shopping tool backed by engine-wrapper-service.
Data directory
Drop your fare CSVs into the data folder. Resolution order:
FARE_DATA_DIRenvironment variable, if set../fare-data(a folder namedfare-datanext to this repo), if it exists./datainside this repo
Any *.csv with the fare-feed header layout is picked up automatically; no
restart needed when you add or replace files (each tool call re-reads the
directory).
Related MCP server: Business Intelligence MCP Server
Tools
Tool | What it does |
| List available CSVs with fare counts, markets, carriers |
| Column names + a sample row for one file |
| Filter fares (exact-match on any column, price range), sorted, compact column projection |
| Count/min/avg/max of Fare AMT and Total Price AMT grouped by any column (default Cabin) |
| Diff two snapshots of a market: added / removed / repriced fares |
| Live fare shop via engine-wrapper-service — POST to frmwithtotalpricewrapperstream |
shop_fares notes
Requires the internal engine-wrapper endpoint (corporate network/VPN). Configure it via
ENGINE_WRAPPER_URL— copy.env.exampleto.envand fill in the URL (ask your team; it is deliberately not committed) — or passendpoint_urlper call (e.g. to hit the historical wrapper).origin,destination,carrierare required; everything else defaults to the standard request: dates (travelDate,asOfDateTime,ticketDate) default to the current date/time in engine format (e.g.02AUG26T1119),hostCarrierdefaults tocarrier,userIddefaults toATP1XXX, trip typeOW,daysStay7.Any other request field can be set through the
overridesdict, which is merged last and wins (e.g.{"taxes": false, "validateCategories": "15"}). An override set tonullremoves that field from the request entirely.Responses whose parsed JSON exceeds
max_response_chars(default 200000) return a preview only, to protect the LLM context window. Programmatic callers should passmax_response_chars: 0for complete data.
Setup
cd fare-mcp-server
python3 -m venv .venv
.venv/bin/pip install -r requirements.txt
cp .env.example .env # then fill in ENGINE_WRAPPER_URLRunning without Claude
Claude is just one MCP client — the server runs standalone and anything that speaks MCP (or plain Python) can drive it.
Raw stdio mode (what any MCP client spawns):
.venv/bin/python server.pyIt waits silently for JSON-RPC on stdin — normal for a stdio server. Ctrl+C to exit.
MCP Inspector — interactive web UI to browse and call the tools (best for development, debugging, and demos; requires Node):
npx @modelcontextprotocol/inspector .venv/bin/python server.pyFrom a Python script — the MCP client library is already installed in the server's venv:
import asyncio
from mcp import ClientSession, StdioServerParameters
from mcp.client.stdio import stdio_client
async def main():
params = StdioServerParameters(command=".venv/bin/python", args=["server.py"])
async with stdio_client(params) as (read, write):
async with ClientSession(read, write) as session:
await session.initialize()
result = await session.call_tool("list_fare_files", {})
print(result.content[0].text)
asyncio.run(main())No MCP at all — the tools are plain Python functions:
.venv/bin/python -c "import server, json; print(json.dumps(server.list_fare_files(), indent=2))"Register with Claude Code
From the directory where you cloned this repo:
claude mcp add --scope user fare-data \
--env FARE_DATA_DIR="$(pwd)/../fare-data" \
-- "$(pwd)/.venv/bin/python" "$(pwd)/server.py"(--env FARE_DATA_DIR=... is optional — see the resolution order above.)
Register with Claude Desktop
Add to ~/Library/Application Support/Claude/claude_desktop_config.json,
replacing <repo> with your clone's absolute path:
{
"mcpServers": {
"fare-data": {
"command": "<repo>/.venv/bin/python",
"args": ["<repo>/server.py"]
}
}
}Then restart Claude Desktop.
Use from FarePulse-Agent
FarePulse-Agent can route its wrapper snapshot calls and competitor probes
through this server: clone the two repos side by side and set
FARE_MCP_ENABLED=1 in FarePulse-Agent's .env (see the "fare-data MCP
server" section of its README).
Example prompts once connected
"What fare files are available?"
"Show me the cheapest business-class fares in MEX_LAX_28Jul.csv"
"Summarize fares by cabin in the 28Jul file"
"What changed between the 10Jul and 28Jul MEX-LAX snapshots?"
"Shop live fares for ADL-LAX on FJ, one way"
This server cannot be deployed
Maintenance
Related MCP Connectors
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
Flight search MCP server providing search, pagination, and itinerary details for AI assistants.
Governed data discovery, exact queries, decisions, simulations, and runtime utilities over MCP.
Hosted Amazon Seller and Vendor MCP server for Claude, ChatGPT, Cursor, Codex, Gemini, Copilot.
Related MCP Servers
AlicenseAqualityDmaintenanceEnables searching J-Quants API endpoints, retrieving detailed documentation, generating executable sample code, and answering FAQs via MCP clients like Claude Desktop.714MIT- FlicenseNot gradedqualityDmaintenanceEnables AI-powered business intelligence queries on Elasticsearch data using natural language and Claude integration via MCP.-
- FlicenseAqualityCmaintenanceMCP server exposing portfolio AI tools including semantic search, evaluation framework, and prompt management, enabling natural language interaction with these services via Claude Desktop.5-
- AlicenseBqualityDmaintenanceEnables AI-driven semantic code search via natural language queries, integrating with MCP clients like Claude Desktop to retrieve relevant code context from any codebase.1MIT