Award Flight Daily
@eCriswell7
Search award flight availability across 25 loyalty programs with 12.3M+ verified records. Real-time discovery, sweet spot identification, transfer partner optimization, and market intelligence for airline miles and points.
Overview
What is Award Flight Daily?
A FastMCP server that wraps a database of 12.3 million award flight records across 25 loyalty programs and exposes it to AI agents via seven tools for searching, analyzing, and optimizing award travel.
How to use Award Flight Daily?
Install the server with fastmcp>=1.0.0, pydantic>=2.0, and duckdb==1.1.3. Run in stdio mode via python -m mcp_server.server or in HTTP mode via python -m mcp_server.server --http 8001. The server registers seven tools that accept Pydantic-validated inputs and return JSON or Markdown responses.
Key features of Award Flight Daily
- Search 12.3M+ award flight records across 25 programs
- List all 25 loyalty programs with statistics
- Get deep stats for a single program
- View calendar availability for a specific route
- Find best-value redemption sweet spots
- Check credit card transfer partner ratios
- Retrieve aggregate database market statistics
Use cases of Award Flight Daily
- An AI travel assistant searches for business-class award availability from JFK to NRT in June.
- A points optimizer compares transfer ratios from Chase to United and Aeroplan.
- A traveler explores the best-value sweet spots across all cabin classes.
- A developer integrates award flight data into a custom trip‑planning app.
FAQ from Award Flight Daily
What data does Award Flight Daily cover?
The database contains 12.3 million award flight records across 25 loyalty programs, covering flights with cabin classes Y (economy), W (premium economy), J (business), and F (first).
How do I filter results by program or cabin?
Use the source parameter (comma‑separated program slugs) and cabin parameter (Y/W/J/F) on the search tool. All string inputs are validated with Pydantic.
Is the database read‑only?
Yes. All queries are read‑only using DuckDB in read‑only mode, filtered on expired_at IS NULL for active records only.
What are the runtime requirements?
Python 3 with packages fastmcp>=1.0.0, pydantic>=2.0, and duckdb==1.1.3. The server can run locally (stdio) or remotely (HTTP on port 8001).
What response formats are available?
The server supports JSON (default, with pagination metadata) and Markdown (human‑readable). Set the response_format parameter per tool.
