Travel Company MCP Server

# Example Queries Once the MCP server is connected to Claude Desktop, you can ask these types of questions: ## Customer Queries ### Basic Customer Search - "Show me all customers named John" - "Find customers with email containing 'smith'" - "Search for customer with phone number 555-1234" - "Look up customer ID 42" ### Customer Profiles - "Get the complete profile for customer ID 5" - "Show me detailed information about customer 15, including their trip history" - "What's the lifetime spending for customer 23?" - "When was the last trip for customer ID 8?" ## Trip Queries ### Search by Destination - "Find all trips to Paris" - "Show me trips to France" - "List all trips to Japan" - "What trips have we booked to Italy?" ### Search by Date - "Show me trips starting after 2024-01-01" - "Find trips in March 2024" - "List all upcoming trips" - "Show me completed trips from last year" ### Search by Status - "List all upcoming trips" - "Show me completed trips" - "Find cancelled trips" - "What trips are scheduled for the future?" ### Combined Searches - "Find upcoming trips to Paris" - "Show me completed trips to Tokyo in 2024" - "List all trips to Spain that are coming up" ### Customer Trip History - "What trips has customer ID 5 taken?" - "Show me the travel history for customer 12" - "List all trips for customer 25" - "How many trips has customer 7 taken?" ## Request Queries ### Basic Request Search - "Show me all pending requests" - "Find requests for trips to Italy" - "List requests from john@email.com" - "Show me all contacted requests" ### Time-Based Queries - "Get pending requests from the last 7 days" - "Show me requests from the last 30 days" - "List recent inquiries that need follow-up" - "What requests came in this week?" ### Status-Based Queries - "Show me all pending requests" - "List converted requests" - "Find closed requests" - "What inquiries have we contacted?" ### Follow-up Workflows - "Show me pending requests that need attention" - "List all new inquiries for follow-up" - "What requests are waiting for a response?" ## Analytics Queries ### Customer Analytics - "How many customers are in the Gold loyalty tier?" - "Show me customers who have taken the most trips" - "Which customers have the highest lifetime spending?" ### Trip Analytics - "What are the most popular destinations?" - "How many trips to Paris have we booked?" - "What's the average trip cost?" - "Show me trips by type (luxury, adventure, etc.)" ### Request Analytics - "How many pending requests do we have?" - "What destinations are people most interested in?" - "What's our request conversion rate?" ## Complex Multi-Step Queries Claude can combine multiple tools to answer complex questions: - "Find customer John Smith and show me his trip history" - "Look up customer ID 10, show their profile and all their trips" - "Find all trips to Tokyo and tell me how many customers went there" - "Show me pending requests for Paris and tell me how many trips to Paris we've booked" - "Find customers who have traveled to both France and Italy" ## Business Intelligence Queries - "Which customers should we follow up with for repeat business?" - "What pending requests have the highest budget ranges?" - "Show me customers with upcoming trips who might want to book another" - "Find high-value customers (Gold/Platinum tier) and their trip preferences" ## Customer Service Scenarios ### Scenario 1: Customer Calls In "A customer just called. Their email is sarah.johnson@email.com. Can you look them up and show me their trip history?" ### Scenario 2: Follow-up Leads "Show me all pending requests from the last 7 days so I can follow up with them." ### Scenario 3: Trip Planning "A customer wants to go to Paris. Show me what other customers have paid for Paris trips so I can give them a quote." ### Scenario 4: Loyalty Rewards "Find all Gold tier customers who have taken more than 5 trips and show me their profiles." ### Scenario 5: Destination Research "Show me all trips to Bali - I need to understand the typical costs and duration." ## Advanced Queries ### Data Validation - "Check if customer with email test@example.com exists" - "Verify if we have any trips for customer ID 999" - "See if anyone has requested information about Antarctica" ### Reporting - "Summarize all trips by destination" - "Count how many customers we have by loyalty tier" - "List all trips with special notes or requirements" ### Troubleshooting - "Find customer ID 15 and verify their email address" - "Check the status of trip ID 42" - "Look up request ID 10 and see if it's been contacted" ## Tips for Best Results 1. **Be specific**: "Show trips to Paris in 2024" vs "Show trips" 2. **Use IDs when known**: "Customer ID 5" is more precise than "customer named John" 3. **Combine searches**: Claude can call multiple tools to answer complex questions 4. **Ask follow-ups**: "Now show me that customer's profile" after a search 5. **Natural language works**: You don't need to memorize exact syntax ## Tool Parameters Reference ### search_customers - `query`: Name, email, phone, or ID - `search_by`: "name" | "email" | "phone" | "customer_id" ### get_customer_profile - `customer_id`: Integer ID ### search_trips - `destination`: Destination name (partial match) - `start_date`: YYYY-MM-DD format - `end_date`: YYYY-MM-DD format - `status`: "completed" | "upcoming" | "cancelled" - `limit`: Max results (default 50) ### get_trip_history - `customer_id`: Integer ID - `limit`: Max trips (default 50) ### search_requests - `email`: Email address (partial match) - `destination`: Destination interest - `status`: "pending" | "contacted" | "converted" | "closed" - `date_from`: YYYY-MM-DD format - `date_to`: YYYY-MM-DD format - `limit`: Max results (default 50) ### get_pending_requests - `days_back`: Number of days to look back (default 30)