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.

Medlyze AI assistant generating a healthcare cost chart from a natural language request

Client

Medlyze

A healthcare pricing intelligence platform launched in 2021, helping providers, payers and employers navigate mandated price transparency data.

Studio

tuniverstudio

A boutique AI integration studio specialising in conversational agents, AI-first web experiences and voice receptionists for ambitious teams.

Study release date

Nov 13, 2025

Announced with live demo in tuniverstudio X thread.

Primary users

Non-technical Medlyze analysts

Designed to unlock access to healthcare pricing intelligence without SQL.

Data source

BigQuery + public transparency datasets

Implementation timeline

Discovery & co-design

Week 1

Rapid workshops to map Medlyze’s reporting pain points, clarify compliance constraints and prioritise the must-have conversational intents.

Prototype loop

Weeks 2-3

Built LangChain flows that translated natural language to SQL with guardrails, paired with curated demo datasets for safe iteration.

Hardening & polish

Weeks 4-5

Added 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
AI assistant presenting negotiated rate table results
Auto-generated tables give analysts a head start on deeper dives.

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
Interface showing suggested queries for the Medlyze assistant
Guided prompts reduce the intimidation factor for new users.

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
Pie chart generated by the Medlyze assistant
Visual storytelling makes benchmarks easier to share with stakeholders.

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.