A multi-tenant operations platform: requests come in as plain text, get routed, assigned and tracked, with LLM drafting and a read-only assistant on top.
Operations teams get requests as loose text. OpsPilot routes them to a department, runs them through a guarded lifecycle and keeps an append-only history. I built it end to end: the FastAPI and PostgreSQL backend, the Next.js front end, two LLM features, and the evals that decided which model ships.
Under the hood: The model never sees a database id. The assistant's tools run in read-only transactions with the asking user's permissions, re-checked on every call.
Python · FastAPI · SQLAlchemy 2 (async) · PostgreSQL · Alembic · Next.js
Read the case study