Case Study
Medlyze AI Data Assistant
Democratising price transparency analytics with a conversational copilot
Together with Medlyze, we launched an AI copilot that turns plain-language healthcare questions into trustworthy BigQuery answers, complete with smart retries and polished visuals.
Implementation timeline
Discovery & co-design
Week 1Rapid workshops to map Medlyze’s reporting pain points, clarify compliance constraints and prioritise the must-have conversational intents.
Prototype loop
Weeks 2-3Built LangChain flows that translated natural language to SQL with guardrails, paired with curated demo datasets for safe iteration.
Hardening & polish
Weeks 4-5Added smart retry logic, guided prompts, export options and contextual explanations before shipping the first internal release.
introduction
Introduction & Background
Medlyze entered the market focused on taming mandated healthcare price transparency files. Their tooling already served data-savvy users, but adoption lagged with analysts, policy teams and consultants who needed quick answers without writing SQL. tuniverstudio, fresh off AI agent deployments for boutique retailers, partnered with Medlyze to prototype a conversational interface that could prove the value of AI-assisted analytics to their broader customer base.
- Strategic push to make complex pricing benchmarks self-serve
- tuniverstudio's mission: accessible AI copilots for regulated industries
challenge
Problem & Constraints
Healthcare price transparency data is noisy, high-volume and compliance-sensitive. Medlyze needed a way for non-technical teammates to explore negotiated rates, spot outliers and export usable views without risking misinterpretation or exposing sensitive partner data. Any assistant had to cope with the idiosyncrasies of payer/provider terminology, gracefully recover from malformed queries and respect the guardrails of public versus private datasets.
- Conversational UX had to map to intricate schemas and healthcare vernacular
- Compliance rules limited which datasets could power demos and marketing collateral
solution
Solution Overview
We architected an AI analyst copilot that goes end-to-end: it interprets natural language, composes SQL, validates the response shape and presents insights as narrative-ready visuals. Suggested prompts help first-time users explore safely, while contextual disclaimers explain how each answer was generated. The assistant can export both raw tables and presentation-ready charts, ensuring downstream teams can continue their workflows without friction.
- Plain-English queries route through a guardrailed LangChain orchestration
- Dynamic visualisation picker chooses the most legible chart for each insight
implementation
Implementation Journey
We grounded the LLM in Medlyze’s canonical BigQuery schemas and added schema-aware planning so the assistant only touches approved tables. A retry handler diagnoses BigQuery errors, corrects column names and resubmits without surfacing raw stack traces to end-users. Front-end guidance, including spotlighted suggested queries and state-aware buttons, keeps the experience discoverable.
- LangChain tooling with deterministic prompt templates and schema tags
- Anthropic Claude during experimentation, tuned towards OpenAI GPT for launch
- SvelteKit shell embedding the assistant alongside knowledge panels
results
Results & Early Signals
Early pilot users cut the time to first meaningful insight from hours to minutes. Teams outside core data engineering now explore reimbursement patterns independently, supporting Medlyze’s positioning as an indispensable pricing intelligence partner. Public demo datasets power safe conference demos and marketing videos without risking PHI leakage.
- Faster analyst onboarding and reduced dependency on SQL specialists
- Demo environments seeded with anonymised public data for go-to-market impact
conclusion
Looking Ahead
With the Medlyze launch, tuniverstudio has a reusable blueprint for regulated analytics copilots. Next on the roadmap: deeper integration with Medlyze Mentor, enterprise-ready RBAC and customer-specific fine-tuning. The collaboration showcases how lean AI teams can unlock outsized value with thoughtful orchestration and empathetic UX.
Details we can still add
Answering these will let us enrich the manuscript with sharper narrative proof points and concrete outcomes.
- Studio story: What inspired the creation of tuniverstudio and how does this project showcase that ethos?
- Client context: How large is the Medlyze team and what specific roles rely on the assistant day-to-day?
- Objectives: Which business KPIs (adoption, retention, deal velocity) is the assistant expected to move?
- Technical metrics: Do we have benchmark numbers for SQL error recovery, query speed or visualization exports?
- Quotes: Is there a Medlyze stakeholder willing to provide an impact statement or testimonial?
- Visual assets: Do we have wireframes or before/after comparisons worth embedding alongside the screenshots?
Stack at a glance
- BigQuery
- LangChain + OpenAI GPT
- Vercel AI SDK
- SvelteKit marketing shell
- TypeScript
- Cloud Run hosting
Plan your own AI copilot
We help teams move from idea to production-grade assistant in weeks. Bring us your data, constraints and success metrics — we’ll co-design the path.