srinipusuluri/airline_reservation_system_mcp

Airline Reservation MCP Server

An MCP (Model Context Protocol) server that provides tools for interacting with an airline reservation system through Claude/Cline.

PLEASE NOTE- YOU MUST INSTALL https://github.com/srinipusuluri/airline_reservation_system

Features

This MCP server exposes 5 tools for managing airline reservations:

• search_flights - Search for available flights between cities on a specific date
• get_flight_details - Get detailed information about a specific flight
• create_booking - Create a new flight booking for a registered user
• get_user_bookings - Retrieve all bookings for a specific user
• cancel_booking - Cancel an existing flight booking

Installation

Prerequisites

• Node.js (v16 or later)
• Python 3.x
• Access to an airline reservation system database

Setup

1. Clone or create the MCP server:

   mkdir -p ~/Documents/Cline/MCP
   cd ~/Documents/Cline/MCP
   # Copy the airline-reservation-server folder here
   

2. Install dependencies:

   cd airline-reservation-server
   npm install
   

3. Build the server:

   npm run build
   

4. Set up Python scripts: Ensure the airline reservation system's Python scripts are in place at: ~/Desktop/airline_reservation_system/scripts/

   • search_flights.py
   • get_flight_details.py
   • create_booking.py
   • get_user_bookings.py
   • cancel_booking.py

5. Configure in Cline settings:

   Add the following to your MCP settings file: ~/Library/Application Support/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json

   {
     "mcpServers": {
       "airline-reservation": {
         "command": "node",
         "args": ["/Users/yourusername/Documents/Cline/MCP/airline-reservation-server/build/airline-reservation-server/index.js"],
         "disabled": false,
         "autoApprove": []
       }
     }
   }
   

   Note: Replace yourusername with your actual username in the path.

Usage

Once installed and configured, you can use the MCP server tools through natural language commands:

Examples

Search for flights:

"Find flights from New York to Los Angeles on 2025-10-08"

Get flight details:

"Show me the details for flight 101"
"Get information about flight ID 1"

Create a booking:

"Book flight 1 for user john_doe with passenger John Smith at john@example.com"
"Create a booking for mary_jane on flight 15 for Mary Jane at mary@example.com"

Check user bookings:

"Show all bookings for user john_doe"
"What are the current bookings for mary_jane?"

Cancel a booking:

"Cancel booking number 123"
"Cancel booking ID 456"

Tool Specifications

search_flights

Description: Search for available flights between cities on a specific date

Parameters:

• departureCity (string): Departure city
• arrivalCity (string): Arrival city
• departureDate (string): Departure date in YYYY-MM-DD format

Returns: Array of available flights with details

get_flight_details

Description: Get detailed information about a specific flight

Parameters:

• flightId (number): Flight ID to retrieve

Returns: Complete flight information including airline, times, pricing, and availability

create_booking

Description: Create a new flight booking for a user

Parameters:

• username (string): Username of the registered user
• flightId (number): Flight ID to book
• passengerName (string): Full name of the passenger
• passengerEmail (string): Email address of the passenger

Returns: Booking confirmation with details

get_user_bookings

Description: Get all flight bookings for a specific user

Parameters:

• username (string): Username to retrieve bookings for

Returns: Array of user's bookings with flight details

cancel_booking

Description: Cancel an existing flight booking

Parameters:

• bookingId (number): Booking ID to cancel

Returns: Success/failure status of cancellation

Architecture

The MCP server acts as a bridge between natural language interfaces and the Python-based airline reservation system:

[Claude/Cline] → [MCP Server (TypeScript)] → [Python Scripts] → [SQLite Database]

• MCP Server: Handles protocol communication and tool validation
• Python Scripts: Interface with the existing database operations
• Database: Stores flight, user, and booking information

Error Handling

The server includes comprehensive error handling for:

• Invalid parameters
• Database connection issues
• Flight/booking not found
• Booking conflicts (no seats available)

Contributing

To extend this MCP server:

1. Add new tools in src/airline-reservation-server/index.ts
2. Create corresponding Python scripts in the airline system
3. Update the database helper functions as needed
4. Rebuild and test the server

License

MIT License - see LICENSE file for details.

Related

• Airline Reservation System - The underlying database system
• Model Context Protocol - MCP specification and documentation