Healthcare Data Architecture Platform
mdatool is a free healthcare data engineering
platform built specifically for data engineers,
architects, and analysts working in health plans,
hospitals, and healthcare IT.
The platform includes 11 specialized tools:
- AI Data Modeling — Generate production-ready
healthcare data models in seconds. Choose from
8 architectures (Star Schema, Data Vault,
Lakehouse, MongoDB and more) across 8 platforms
(Snowflake, BigQuery, Databricks, PostgreSQL
and more) with 7 healthcare domains (claims,
clinical, pharmacy, member, provider, quality,
finance).
- SQL Linter — Catch SQL bugs, performance issues,
and ISO-11179 naming violations before they
reach production.
- DDL Converter — Convert DDL schemas between
Snowflake, BigQuery, Databricks, Oracle,
SQL Server, and PostgreSQL instantly.
- Naming Auditor — Audit column and table names
against ISO-11179 healthcare data standards.
- Bulk Sanitizer — Standardize and sanitize bulk
healthcare data fields at scale.
- Name Generator — Generate standard ISO-11179
column and table names for healthcare schemas.
- NPI Lookup — Search the CMS NPPES provider
registry by name, NPI number, or organization.
- HCC Calculator — Calculate HCC risk adjustment
scores for Medicare Advantage populations.
- ICD-10 Search — Look up ICD-10 diagnosis codes
instantly.
- HL7 Parser — Parse and decode HL7 v2 messages
from clinical systems.
- Schema Diff — Compare two SQL schemas and
identify structural differences.
The platform also includes a 100,000+ term
healthcare data glossary covering 13 domains —
clinical, claims, pharmacy, member, provider,
operations, quality, finance, laboratory, supply,
technology, behavioral health, and population
health — with ISO-11179 standard abbreviations
and full definitions