01 · AI feasibility analysis
Feasibility Cohort Explorer
Ask for a patient cohort in plain English, get an instant validated count across 114,594 synthetic patients.
Problem
Every clinical study starts with "are there enough patients who meet these criteria?" Answering means a data analyst hand-writing SQL, so each question becomes a ticket and a wait. Pointing an LLM at the database instead trades the wait for a worse problem: confident-looking queries that reference codes that don't exist.
What I built
A chat-driven cohort builder with live counts and demographic breakdowns. The LLM's only job is producing a small, validated criteria structure grounded to real ICD-10-CM, NDC, and LOINC codes — a deterministic, LLM-free compiler turns it into parameterized SQL. The same engine also answers over MCP.
Outcome
- Zero hallucinated codes by construction — every code validated against 261k+ vocabulary entries before execution
- ~75 ms median cohort counts across 114,594 patients
- One engine, two surfaces — web app and MCP server return identical counts