The Healthcare Data Dictionary
for dbt, Snowflake, Databricks & BigQuery
100,000+ ISO-11179 standard healthcare data terms for dbt projects, Snowflake schemas, Databricks lakehouses, and BigQuery datasets. Free tools for healthcare data engineers.
Works with
Built by healthcare data engineers with experience at Epic, Optum, and CMS — meet the team →
AI-Powered Data Modeling
Generate production-ready healthcare data models in seconds. 8 architectures, 8 platforms, 100K+ healthcare terms as context.
Coverage
Every healthcare data domain, standardized
Built for the full healthcare data ecosystem — from provider enrollment to pharmacy claims and clinical quality reporting.
Provider Data
NPI, taxonomy classifications, credentialing, and provider network schemas. Production-ready standards for healthcare organizations.
Claims & Billing
ICD-10, CPT, EDI 837/835, carrier payments, and adjudication workflows. Complete coverage from submission to remittance.
Pharmacy
NDC codes, dispensing data, CSTD safety protocols, and PBM integration standards for medication data pipelines.
Clinical & Quality
HCC risk adjustment, HEDIS measures, FHIR resources, LOINC, SNOMED CT, and Stars ratings data models.
Engineering Toolkit
Tools built for healthcare data engineers
Everything from SQL auditing to AI-powered data modeling — purpose-built for the healthcare data stack.
AI Data Modeling
AIGenerate production-ready healthcare data models from plain English. 8 architectures, 8 platforms, 100K+ terms as context.
SQL Linter
Audit SQL for security, performance, and naming violations before they reach production.
DDL Converter
Translate DDL schemas across Snowflake, BigQuery, Oracle, SQL Server, and PostgreSQL.
Bulk Sanitizer
Standardize hundreds of column names at once against the 100,000-term glossary.
Naming Auditor
Check column and table names against platform-specific naming standards.
Name Generator
Convert any business term to an ISO-11179-compliant snake_case physical name.
HCC Calculator
Calculate CMS-HCC V28 RAF scores and Medicare Advantage risk-adjusted payment estimates.
NPI Lookup
Search the CMS NPPES registry by provider name, NPI number, or organization instantly.
ICD-10 Search
Look up any of 70,000+ ICD-10-CM clinical codes by description or code prefix.
Schema Diff
Paste two DDL schemas and instantly see added, removed, and modified tables and columns.
HL7 v2 Parser
Decode any HL7 v2 message into labeled segment fields. Supports ADT, ORU, ORM, and more.
Product Preview
See the tools in action
Purpose-built for healthcare data workflows — from SQL auditing to HL7 message parsing.
SQL Input
SELECT p.patient_id, p.first_name, p.last_name, d.description, c.clm_id, c.total_charge_amount FROM patients p JOIN claims c ON p.patient_id = c.patient_id JOIN diagnoses d ON c.clm_id = d.claim_id WHERE p.status = 'A'
Lint Results
Naming violation
description — use standard abbr desc
Performance warning
Implicit JOIN on clm_id — verify index exists
Naming convention
total_charge_amount — prefer total_chg_amt
Parameterization — OK
No string concatenation or injection risk detected
SQL Linter
Security violations, missing parameterization, naming non-compliance, and performance issues flagged inline — before they reach production.
How it works
From definition to deployment
mdatool fits into the healthcare data engineer's workflow at every stage — from naming a column to validating a full DDL migration.
Search the Standard Library
Look up any healthcare data term — from NPI and ICD-10 to HCC codes and NDC. Every entry includes the canonical abbreviation, full definition, and domain context (Provider, Claims, Pharmacy, Clinical).
100,000+ terms across provider, member, claim, and RX domains
Run Your Data Through the Tools
Use the engineering toolkit to lint SQL for security and performance issues, convert DDL across databases (Snowflake, BigQuery, Oracle, SQL Server), audit column naming compliance, and sanitize bulk column lists against the glossary.
7 tools: SQL Linter, DDL Converter, Bulk Sanitizer, Naming Auditor, Name Generator, AI Modeling, HCC Calculator
Export and Implement Standards
Download your standardized naming conventions as CSV or Excel, export validated DDL scripts ready for deployment, and share a consistent data dictionary with your team — from data engineers to analytics leads.
CSV, Excel, and SQL export · Pro API access · Team collaboration
Reference Library
Healthcare data reference guides
Technical deep-dives with database schemas, code examples, and implementation guides.
NPI Guide
National Provider Identifier lookup, taxonomy codes, and database design.
Read guideICD-10 Codes
Diagnosis codes, database schema, and billing integration standards.
Read guideCPT Codes
Procedure codes, modifiers, RVUs, and healthcare billing.
Read guideHL7 FHIR
FHIR R4 resources, APIs, and healthcare interoperability standards.
Read guideHCC Risk Adjustment
CMS-HCC model, RAF scoring, and Medicare Advantage payment methodology.
Read guideEDI Transactions
X12 837, 835, 270/271 transaction sets and healthcare EDI standards.
Read guideWhy mdatool
Why teams choose mdatool
Purpose-built for healthcare data — not adapted from a generic tool.
Built for Healthcare
Not a generic data dictionary. Every term, abbreviation, and naming convention is healthcare-specific — covering provider, claims, pharmacy, and clinical domains end to end.
Engineer-First
Tools designed for data engineers, not just analysts or business users. SQL linting, DDL conversion, schema diffing — built for the data warehouse, not a slide deck.
Ready to Deploy
Export-ready DDL, CSV, and API access — not just a reference doc. Drop standardized schemas directly into Snowflake, BigQuery, Oracle, or any SQL platform.
Knowledge Base
From the knowledge base
Deep dives on healthcare data engineering, written for practitioners.
Standardize your healthcare data — starting today
Free forever for individuals. No credit card required.