The Standard for
Healthcare Data
37K+ verified definitions, abbreviations, and naming conventions for provider, claims, pharmacy, and clinical data systems.
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.
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 65,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.
AI Data Modeling
Generate entity-relationship data models from a plain-English description using AI.
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.
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).
37K+ 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 guideUsed by data teams across healthcare
Trusted by Healthcare Data Teams
From health plans to provider networks — teams use mdatool to standardize faster.
"mdatool cut our data dictionary build time by 60%. The 65,000-term library meant we weren't starting from scratch — every abbreviation and definition mapped straight to our Snowflake warehouse."
Sarah Chen
Senior Data Engineer · Regional Health System
"We used to have three different naming standards across our claims, provider, and pharmacy pipelines. mdatool gave us a single source of truth that every team now references before creating any new table or column."
Michael Rodriguez
Data Architect · Medicare Advantage Plan
"The SQL linter caught a critical security issue — an unparameterized query in our claims adjudication pipeline — before it reached production. That alone was worth the Pro plan for the entire team."
Jennifer Park
Lead Database Administrator · Health Information Exchange
Standardize your healthcare data — starting today
Free forever for individuals. No credit card required.