Tru-Trac Rollers × Pharos
How a world-leading conveyor component manufacturer put AI to work on their ERP data.
The Problem
A modern factory running on fragmented data and manual processes.
Manual ERP queries
Managers relied on IT to pull reports or wrote raw SQL against production databases. Simple questions took hours to answer.
Disconnected data
MRP data in Tempo, transactions in SYSPRO, warehouse in a separate system, reporting in Excel. No single source of truth.
Slow decision-making
By the time a report was ready, the data was stale. Operations decisions lagged behind the factory floor.
The Solution
Pharos connects AI agents directly to Tru-Trac's live ERP data via the Model Context Protocol (MCP). No data migration, no middleware, no changes to their existing SYSPRO installation.
Operations staff now query their data through natural language and get answers grounded in live production numbers.
- Natural-language queries against live ERP data via any MCP-compatible AI client
- Schema discovery: AI navigates the data model without hand-holding
- KPI dashboards, MRP analysis, and customer risk assessments on demand
- Write operations (labour posting, inventory adjustments) with confirmation gates
Outcomes
Qualitative changes since Pharos went into production. Numeric results are tracked internally; we publish numbers only when the customer has approved them for release.
Before
Cross-system questions required a developer, a SQL query, and a ticket. Operations decisions lagged the floor.
After
The same questions are answered in seconds via Pharos in plain English, grounded in live SYSPRO, Tempo, and warehouse data.
Scope
Live across SYSPRO Company DB, Tempo MRP, and the analytics warehouse. Read by default; write operations gated by confirmation.
Adoption
In daily production use at Tru-Trac Rollers. New queries added by operations staff without engineering involvement.
Technical Implementation
Pharos connects to 4 data sources via curl-based MCP tools. Stateless, secure, and deployed on-premise alongside the existing infrastructure.
SYSPRO Company DB
Customers, orders, inventory, transactions
Tempo MRP
MRP runs, shortages, suggestions
Analytics Warehouse
Cross-entity reporting and KPIs
PhX Write API
Labour posting, warehouse transfers
See what Pharos can do for your operation
If your team spends hours pulling reports from your ERP, there's a faster way.