Crew Qualifications & Certifications MCP Server

Production-ready MCP server for airline crew data, qualifications, certifications, and automated pay calculations.

Part of the Number Labs Airline Agentic Operating System - Avelo Airlines Design Partnership

Overview

The Crew Qualifications MCP Server serves as the canonical source of truth for airline crew operations, enabling:

• Automated Pay Calculations - Reduce crew pay claims by 80% through accurate, automated calculations
• FAA Part 117 Compliance - Real-time duty time validation and legality checking
• Qualification Tracking - Comprehensive crew qualification and certification management
• Proactive Alerts - Automatic notifications for expiring licenses, medicals, and training
• Multi-App Integration - Powers crew scheduling, pay processing, and training management systems

Business Impact

Current State: Daily crew pay claims due to manual calculation errors
Target State: 80% reduction in claims through automated validation
ROI: Reduced administrative overhead + improved crew satisfaction

Architecture

              CREW QUALIFICATIONS & CERTIFICATIONS           
                       MCP SERVER                             
                                                              
           
     Crew HR        PostgreSQL        Rules          
     Import         Database       Engine          
     Agents                        (FAA/Union)       
           
                                                            
                              
                     Pay Calc       Legality            
                     Engine         Validator           
                              
                                                             
                                              
                     MCP Server                            
                      Protocol                             
                                              

                          MCP Tools
        
                                        
  
 Crew Pay          Crew          Training   
Intelligence     Scheduling     Management  
  

Tech Stack

• Backend: Node.js 20+ with TypeScript
• Database: PostgreSQL (Neon for dev, Railway for prod)
• MCP Protocol: @modelcontextprotocol/sdk
• Rules Engine: Custom TypeScript + JSON configurations
• Pay Calculator: Custom engine with FAA Part 117 compliance
• Testing: Jest + Supertest
• Deployment: Railway / Vercel

Quick Start

Prerequisites

• Node.js 20 or higher
• PostgreSQL 15 or higher
• npm or yarn

Installation

# Clone the repository
git clone <repo-url>
cd crew-mcp

# Install dependencies
npm install

# Configure environment
cp .env.example .env
# Edit .env with your database credentials

# Set up database
npm run db:reset

# Build the project
npm run build

# Start the MCP server
npm start

Development

# Run in watch mode
npm run dev

# Run tests
npm test

# Run tests in watch mode
npm test:watch

# Check code coverage
npm test:coverage

MCP Tools

The server provides 8 powerful tools:

1. get-crew-qualifications

Get comprehensive qualification profile for a crew member including licenses, ratings, medical, and training status.

2. validate-crew-legality

Validate if a crew member can legally be assigned to a duty period based on FAA Part 117, qualifications, and rest requirements.

3. calculate-crew-pay

Calculate crew member pay for a given period using automated rules engine with union contract compliance.

4. flag-pay-discrepancies

Analyze pay records to identify potential discrepancies and prevent crew claims.

5. get-training-requirements

Get training requirements and currency status for crew members.

6. check-certification-expiry

Monitor and alert on expiring certifications (licenses, medicals, type ratings).

7. get-qualified-crew-pool

Get list of qualified and available crew members for specific aircraft types and duty periods.

8. update-duty-time

Record duty time, flight time, and rest periods for crew members.

Database Schema

The system uses 10 core tables:

• crew_members - Core crew member information
• pilot_qualifications - Pilot licenses and qualifications
• aircraft_type_ratings - Aircraft type rating certifications
• medical_certificates - Medical certificate tracking
• recurrent_training - Training and recurrency records
• duty_time_records - Flight and duty time tracking
• crew_pay_records - Pay calculation records
• pay_calculation_rules - Configurable pay rules
• crew_claims - Pay claim tracking
• faa_part117_compliance - FAA compliance monitoring

See database/schema.sql for complete schema definition.

Configuration

Key environment variables:

# Database
DATABASE_URL=postgresql://user:pass@host:port/dbname

# MCP Server
MCP_SERVER_NAME=crew-qualifications-mcp
NODE_ENV=development

# Features
FAA_PART117_ENABLED=true
ALERT_DAYS_BEFORE_EXPIRY=60

Testing

# Run all tests
npm test

# Run specific test suite
npm test -- tests/engines/pay-calculator.test.ts

# Run with coverage
npm test:coverage

Deployment

Railway

# Deploy to Railway
railway up

Docker

# Build image
docker build -t crew-mcp .

# Run container
docker run -e DATABASE_URL=$DATABASE_URL crew-mcp

Integration

With Aircraft MCP

The Crew MCP integrates with the Aircraft MCP for:

• Validating aircraft type qualifications
• Cross-referencing crew ratings with fleet types
• Ensuring crew coverage for entire fleet

With Claude Desktop

Add to your Claude Desktop configuration:

{
  "mcpServers": {
    "crew-qualifications": {
      "command": "node",
      "args": ["/path/to/crew-mcp/build/index.js"]
    }
  }
}

Documentation

• API Documentation
• Pay Calculation Guide
• FAA Compliance
• Examples

License

MIT

Support

For issues and questions, please open a GitHub issue or contact Number Labs.

Built by Number Labs for Avelo Airlines
Part of the Airline Agentic Operating System