MCP_TOOLS_SUMMARY.md

FleetMind MCP Tools - Quick Reference

Geocoding & Routing (3 tools)

1. geocode_address - Convert address to GPS coordinates
2. calculate_route - Calculate route with vehicle-specific optimization (motorcycle/car/bicycle), toll avoidance, traffic data
3. calculate_intelligent_route - Advanced routing with weather + traffic + vehicle type analysis

Order Management (8 tools)

4. create_order - Create new delivery order with MANDATORY expected_delivery_time and SLA tracking
5. count_orders - Count orders by status (pending/assigned/in_transit/delivered)
6. fetch_orders - Get list of orders with filters and pagination
7. get_order_details - Get full details of specific order by ID including timing and SLA data
8. search_orders - Search orders by customer name, address, or order ID
9. get_incomplete_orders - Get all pending/assigned/in_transit orders
10. update_order - Update order status, driver, location, notes (with assignment cascading)
11. delete_order - Delete order (with active assignment checks)

Driver Management (8 tools)

12. create_driver - Register new driver with name, phone, vehicle type
13. count_drivers - Count drivers by status (active/busy/offline)
14. fetch_drivers - Get list of drivers with filters and pagination
15. get_driver_details - Get full details of specific driver by ID
16. search_drivers - Search drivers by name, phone, or driver ID
17. get_available_drivers - Get all active drivers ready for assignment
18. update_driver - Update driver status, phone, vehicle type, location (with assignment validation)
19. delete_driver - Delete driver (with assignment safety checks)

Assignment Management (6 tools)

20. create_assignment - Assign order to driver (validates status, calculates route, saves all data)
21. get_assignment_details - Get assignment details by assignment ID, order ID, or driver ID
22. update_assignment - Update assignment status with cascading updates to orders/drivers
23. unassign_order - Unassign order from driver (reverts statuses, requires confirmation)
24. complete_delivery - Mark delivery complete and auto-update driver location to delivery address
25. fail_delivery - Mark delivery as failed with MANDATORY driver location and failure reason

Bulk Operations (2 tools)

26. delete_all_orders - Bulk delete all orders (or by status filter, blocks if active assignments exist)
27. delete_all_drivers - Bulk delete all drivers (or by status filter, blocks if assignments exist)

---

Total: 27 MCP Tools

Routing Tools: 3 (with Google Routes API integration) Order Tools: 8 (full CRUD + search + cascading) Driver Tools: 8 (full CRUD + search + cascading) Assignment Tools: 6 (complete assignment lifecycle + delivery completion + failure handling) Bulk Operations: 2 (efficient mass deletions with safety checks)

Key Features:

• ✅ Real-time traffic & weather-aware routing
• ✅ Vehicle-specific optimization (motorcycle/bicycle/car/van/truck)
• ✅ Toll detection & avoidance
• ✅ Complete fleet management (orders + drivers + assignments)
• ✅ Assignment system with automatic route calculation
• ✅ Mandatory delivery deadline (expected_delivery_time) when creating orders
• ✅ Automatic SLA tracking with grace period
• ✅ Delivery performance status: on_time, late, very_late, failed_on_time, failed_late
• ✅ Automatic driver location updates on delivery completion
• ✅ Mandatory location + reason tracking for failed deliveries
• ✅ Structured failure reasons for analytics and reporting
• ✅ Cascading status updates (order → assignment → driver)
• ✅ Safety checks preventing invalid deletions/updates
• ✅ PostgreSQL database with foreign key constraints
• ✅ Search & filtering capabilities
• ✅ Status tracking & validation

Assignment System Capabilities:

• Manual assignment with validation (pending orders + active drivers only)
• Automatic route calculation from driver location to delivery address
• Delivery completion with automatic driver location update to delivery address
• SLA & Timing Tracking:
  • Mandatory expected_delivery_time when creating orders
  • Automatic comparison of actual vs expected delivery time
  • Grace period support (default: 15 minutes)
  • Performance statuses: on_time, late (within grace), very_late (SLA violation)
  • delivered_at field automatically populated on completion/failure
• Delivery failure handling with mandatory GPS location and failure reason
• Failure timing tracking: failed_on_time vs failed_late status
• Structured failure reasons: customer_not_available, wrong_address, refused_delivery, damaged_goods, payment_issue, vehicle_breakdown, access_restricted, weather_conditions, other
• Status management with cascading updates across orders/drivers/assignments
• Safety checks preventing deletion of orders/drivers with active assignments
• Assignment lifecycle: active → in_progress → completed/failed/cancelled
• Database integrity via FK constraints (ON DELETE CASCADE/RESTRICT/SET NULL)