Health Samurai Blog

FHIR has no $unmerge operation. We built one that reverses a merge using Provenance + History API and lets the client decide what to do with data added between the merge and unmerge.

We analyzed 7 million records in the NPI Registry and found thousands of providers with multiple NPIs. Explore the duplicates yourself with our interactive tool.

Aidbox 2604 brings HIPAA Safe Harbor de-identification in SQL-on-FHIR, Databricks Lakebase token auth, a reworked SQL Console, and Formbox SMART on FHIR integration.

Aidbox supports HIPAA Safe Harbor de-identification directly in ViewDefinitions. Transform FHIR data into compliant, analytics-ready tables with per-column control — and map results back when needed.

Aidbox 2603 brings BigQuery streaming, Databricks Lakebase support, FHIR package dependency overrides, and Formbox improvements.

Use agentic coding on FHIR to build a Patient Weight dashboard from a single prompt — data model, terminology, and live demo with Aidbox.

FHIR (Fast Healthcare Interoperability Resources) revolutionized medical data exchange between systems. However, its nested JSON structure makes data analytics challenging.

FHIR's nested structure works for APIs but frustrates SQL analytics. SQL on FHIR uses a simple DSL to define flat views – portable across ETL/ELT runners, tested via shared suites. Nikolai Ryzhikov's DevDays session demos the workflow from Synthea data to Grafana dashboards.

An HL7-aware AI assistant for FHIR Structured Data Capture: form authoring, analytics queries, accessibility, and data quality — built on Aidbox.

Struggling with messy health data? Aidbox Forms + SQL on FHIR transform data collection & analysis. Standardize inputs with coded forms, query FHIR data easily, and focus on care—not paperwork. See how it works with a real risk assessment example.