john mark lowry
§ ai tools · 2026

compass

The AI transformation program's operating system — a 100+ item roadmap, 260+ automations, and a council, out of the spreadsheet.

team one internal tool, deployed in production on the agency's internal aws/eks platform.

the short version

The AI transformation program — a 100+ item roadmap across six strategic pillars, 260+ workflow automations, a tool inventory, a 13-member AI council, and executive reporting — lived in one overworked spreadsheet driven by one person. Compass is that program as software: roadmap swimlanes, automation and tool catalogs, council views, four-tier access so any employee can see the program by default, an idempotent seed pipeline that parses the original tracker with entity resolution, and a chat interface whose answers defer to the database. Agents surface; humans decide.

Full case study in progress — artifacts pending clearance or writing time. The insight below is already earned.

The LLM is an interface, not the brain. Structured data is the truth; discrepancies get flagged, never silently resolved — and every mutation is logged, because the changelog is the program's commit history.

the insight
ran onPython + FastAPI · PostgreSQL + pgvector · React + TypeScript · tiered LLM chat (4 user tiers) · production on AWS

← all work