Health Samurai Blog

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.

SQL on FHIR in PostgreSQL. Two types of SQL on FHIR View Runners - ETL (in-memory) & ELT (in-database) and demo the ELT implementation for PostgreSQL.

Top free FHIR tools for developers: viewer, validator, FHIRPath evaluator, CCDA-FHIR converter, and form builder — all open and free.

What a FHIR ViewDefinition is, how it flattens FHIR resources for SQL analytics, and how to use it in the SQL on FHIR specification.