How CodeIQ Pro turned CompuFast's flagship workforce-management platform — a sprawling, undocumented legacy estate — into a fully queryable knowledge graph, ready to modernize.
CompuFast builds Perfast — a workforce-management suite covering attendance, work patterns, rostering, pay, timesheets and shop-floor data capture. Two decades of development across VB.NET, ASP.NET Web Forms and WPF, all sharing one SQL Server database.
Every app read and wrote the same shared schema, but not a single relationship was declared. The real data model existed only inside the SQL.
The original authors had moved on. Behavior lived in the heads of a few people and in code nobody wanted to touch.
Asked how attendance rules worked, off-the-shelf AI confidently invented columns — rule_id, threshold — that simply did not exist in the database.
A change to one shared table could ripple through nine applications. Nobody could say what a fix would break.
Nine applications — code, the SQL Server schema and stored procedures, and the live screens — parsed into one knowledge graph per app, plus a portfolio view across all of them.
With no foreign keys to read, CodeIQ Pro reconstructed 149 relationships across the estate from the JOINs in Perfast's own SQL — making the real data model explicit for the first time.
From the database's own menu tables it recovered 62 screens across 11 modules and 3 roles, then linked human field labels to the columns behind them and mined 312 lookup tables for real reference data.
An anti-hallucination guard now validates every identifier against the graph and refuses thin-grounded answers — so questions about attendance rules return the real tables, not invented ones.
The largest app broke into 318 dependency-safe slices, each with a recommended strategy and a parity gate to prove the rewrite preserves every table and PII path.
Customer quote pending approval. This space is reserved for an approved endorsement from CompuFast — add it here once cleared. We don't publish quotes we haven't been given.
Bring your hardest application. We'll map a real module live and show you the path forward.
Code