Travel Company MCP Server

An MCP (Model Context Protocol) server that provides Claude with access to a travel company's customer data, trip history, and information requests.

Features

• Customer Management: Search and retrieve customer profiles

• Trip History: Query past and upcoming trips by customer or destination

• Request Tracking: Manage customer inquiries and follow-up requests

Requirements

• Python 3.10 or higher

• pip package manager

Installation

1. Clone or download this repository

2. (Optional) Create a virtual environment:

   python -m venv venv
   source venv/bin/activate  # On Windows: venv\Scripts\activate

3. Install dependencies:

   pip install -r requirements.txt

4. Initialize the database:

   python -m src.seed_data

Running the Server

The MCP server is designed to be run by Claude Desktop via stdio transport:

python -m src.server

Configuration for Claude Desktop

Add this to your Claude Desktop MCP configuration:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "travel-company": {
      "command": "python",
      "args": ["-m", "src.server"],
      "cwd": "/path/to/mcpdemo"
    }
  }
}

Available Tools

Customer Tools

• search_customers: Search for customers by name, email, phone, or ID

• get_customer_profile: Get detailed customer profile with trip statistics

Trip Tools

• search_trips: Search trips by destination, date range, or status

• get_trip_history: Get trip history for a specific customer

Request Tools

• search_requests: Search information requests by various criteria

• get_pending_requests: Get pending customer requests for follow-up

Example Queries

Try asking Claude:

• "Show me all customers named John"

• "What trips has customer ID 5 taken?"

• "List all pending requests from the last 7 days"

• "Find trips to Paris in 2024"

• "Show me the profile for customer@email.com"

Project Structure

mcpdemo/
├── src/
│   ├── server.py           # Main MCP server
│   ├── database.py         # Database layer
│   ├── seed_data.py        # Demo data generator
│   └── tools/              # Tool implementations
├── data/                   # SQLite database
├── config/                 # Configuration files
└── logs/                   # Server logs

Development

The server uses SQLite for storage with demo data including:

• 100+ customer records

• 200+ trip records

• 50+ information requests

All data is synthetic and for demonstration purposes only.

License

MIT