Google Flights MCP Server (.NET 8.0)

A comprehensive Model Context Protocol (MCP) Server for Google Flights integration, built with C# .NET 8.0. This solution includes a Web API with search history tracking, real-time flight scraping, and IP address logging.

🚀 Features

• Real-time Flight Scraping - Uses Playwright and AngleSharp to fetch live flight data from Google Flights.
• RESTful Web API - Full-featured flight search API with Swagger documentation.
• Search History Tracking - Persistent storage of all flight searches with client IP addresses.
• PostgreSQL Database - Production-ready database with Entity Framework Core.
• Request Logging - Comprehensive middleware for tracking all API requests.
• Console MCP Server - Command-line interface for MCP protocol integration.
• Docker Support - Complete containerization with Docker Compose.
• CI/CD Pipeline - GitHub Actions workflow for automated testing.
• Comprehensive Testing - Unit and integration tests with xUnit and WebApplicationFactory.

📁 Project Structure

Google-Flights-MCP-Server/
├── GoogleFlights.Core/             # Shared models, entities, and core business logic
│   ├── Services/
│   │   ├── IFlightSearchService.cs
│   │   └── FlightSearchService.cs  # Main scraping logic using Playwright
│   ├── Models/                     # Core data models
│   └── Helpers/                    # Date and Price helpers
├── GoogleFlightsApi/               # Web API Project (ASP.NET Core)
│   ├── Controllers/                # API endpoints (Flights, History, Health)
│   ├── Data/                       # EF Core DbContext and Entities
│   ├── Services/                   # API-specific services (Tracking, History)
│   └── Middleware/                 # Request logging middleware
├── GoogleFlightsMcp/               # Console MCP Server
│   ├── Mcp/                        # MCP Protocol implementation
│   └── Tools/                      # MCP Tool definitions
├── GoogleFlightsApi.Tests/         # Unit and Integration tests
│   ├── Services/                   # Service unit tests
│   └── Integration/                # API integration tests
├── docker/                         # Dockerfile
├── docker-compose.yml              # Multi-container setup
└── GoogleFlightsMcp.sln            # Solution file

🛠️ Prerequisites

• .NET 8.0 SDK or higher.
• PostgreSQL 16 (optional - uses in-memory DB if not configured).
• Docker (optional, for containerized deployment).
• Playwright Browsers (Required for scraping).

🚀 Getting Started

1. Clone the Repository

git clone https://github.com/tdav/Google-Flights-MCP-Server.git
cd Google-Flights-MCP-Server

2. Build the Solution

dotnet restore
dotnet build

3. Install Playwright Browsers

# Install Playwright CLI tool if not already installed
dotnet tool install --global Microsoft.Playwright.CLI

# Install Chromium browser
powershell -ExecutionPolicy Bypass -File GoogleFlightsMcp/bin/Debug/net8.0/playwright.ps1 install chromium

4. Run the Web API

Option A: With In-Memory Database (Development)

cd GoogleFlightsApi
dotnet run

Option B: With PostgreSQL (Production)

First, update appsettings.json with your connection string:

{
  "ConnectionStrings": {
    "DefaultConnection": "Host=localhost;Database=google_flights;Username=postgres;Password=yourpassword"
  }
}

Then run:

cd GoogleFlightsApi
dotnet ef database update  # A

... [View full README on GitHub](https://github.com/tdav/Google-Flights-MCP-Server#readme)