P6XER MCP Server

Parse a Primavera P6 XER file and return basic project information: project list with status breakdowns, total activities, resources, calendars, WBS elements, and relationships.

Get activities from an XER file. Filter options: - project_id: numeric P6 project ID - project_short_name: project short name string - status: TK_NotStart | TK_Active | TK_Complete - task_type: TT_Task | TT_Mile | TT_FinMile | TT_WBS - limit: max rows returned (default 100)

Find critical path activities (total float <= 0, incomplete only). Results are sorted by early start date ascending. Accepts either project_id (numeric) or project_short_name as a filter.

Summarize resource utilization: planned/actual hours and costs per resource. Labor resources (RT_Labor) are flagged as over_allocated if planned hours exceed max_hours_per_year (default 2080 = 40 hrs/week x 52 weeks). Results are sorted by planned hours descending.

DCMA-style schedule quality check on open/in-progress activities. Identifies: - Activities missing predecessors (excluding start milestones) - Activities missing successors (excluding finish milestones) - Long-duration activities (threshold: long_duration_days, default 20) - High-float activities (threshold: high_float_days, default 44) - TT_Task activities without any resource assignment - Activities missing early start dates

List all resources in an XER file. Optionally filter by type: RT_Labor | RT_Mat | RT_Equip

Get resource-activity assignments, enriched with resource and activity names. - rsrc_name: partial match on resource name (case-insensitive) - task_code: exact match on activity task code

Get the Work Breakdown Structure (WBS) hierarchy, optionally filtered by project.

Get activity predecessor/successor relationships, enriched with task codes. If task_code is supplied, returns only relationships where that activity appears as the successor or as the predecessor.

List all calendar definitions in the XER file with hours-per-period data.

Comprehensive schedule summary: activity counts by status, critical activity count, milestone count, resource/calendar/WBS/relationship totals, and date range.

Calculate Earned Value Management (EVM) metrics per project: PV (Planned Value), EV (Earned Value), AC (Actual Cost), CV (Cost Variance), SV (Schedule Variance), CPI, SPI, EAC.

Get full detail for a single activity by its task_code (case-insensitive). Returns all scheduling fields plus enriched predecessors, successors, and resource assignments with names and costs.