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. Built for healthcare data architects, modelers, and engineers.
Used by healthcare data architects, modelers, and engineers at health plans, PBMs, and provider networks.
Works with
Built by healthcare data engineers with experience at Epic, Optum, and CMS — meet the team →
Healthcare Metadata Generator
Paste your DDL → Get business descriptions, PHI flags, dbt YAML & governance reports powered by 100,000+ ISO-11179 standard healthcare term definitions.
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.
Toolkit
Tools built for healthcare data architects, modelers, and engineers
SQL tools for engineers, data modeling for architects, and governance for leaders — purpose-built for healthcare data teams.
Metadata Generator
AIPaste your DDL → get business descriptions, PHI flags, dbt YAML & governance reports. Powered by 100,000+ ISO-11179 standard healthcare term definitions.
AI Data Modeling
Generate production-ready healthcare data models from plain English — for data architects and data modelers. 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
Free HCC RAF Score Calculator. Calculate Medicare Advantage risk adjustment scores from ICD-10 codes. CMS-HCC V28 model.
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.
Data Model Canvas
Build and visualize interactive healthcare ERD diagrams — for data architects and solution architects. Export to DDL or PNG.
For Every Role
The Standard Your Whole Team Can Use
For Data Engineers
Build Faster
SQL Linter, Naming Auditor, and Bulk Sanitizer keep your pipelines clean and compliant. 100,000+ ISO-11179 standard abbreviations for every healthcare data element — claims, clinical, pharmacy, member, and provider.
For Data Architects & Modelers
Design Consistently
AI Data Modeling generates production-ready schemas in seconds. The Data Model Canvas lets you build and visualize ERDs interactively. DDL Converter translates schemas across Snowflake, Databricks, and BigQuery.
For Data Leaders
Govern at Scale
Governance guides for Directors and VPs, team plans for 5+ engineers, and enterprise options with SSO and custom dictionaries. Enforce ISO-11179 standards across the warehouse and pass audits with confidence.
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 team'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.
Business Impact
Healthcare data teams using standardized naming conventions report:
faster onboarding for new engineers
reduction in data dictionary maintenance
consistent schemas across Snowflake, Databricks, and BigQuery
Standardize your healthcare data — starting today
Free forever for individuals. No credit card required.