mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Blog

Healthcare Data Insights

In-depth guides, tutorials, and best practices for database design, data architecture, and healthcare data modeling.

For Data Leaders

Executive briefings for Directors, VPs, and CTOs

Platform comparisons, TCO analysis, and governance frameworks — written for the people who approve the budget.

View platform guides
Filter:All (2)Tools & ComparisonsProvider DataHealthcare Data ModelingMember EnrollmentData ModelingRevenue CycleClaims & AdjudicationHealthcare Data PlatformsHealthcareData ArchitectureSQL & PerformanceDatabase MigrationPharmacyData EngineeringData GovernanceCloud ArchitectureRisk AdjustmentDDL & SQLHealthcare StandardsPharmacy DataHealthcare Data EngineeringTools

Provider Data Articles

2 articles

Provider Data

Provider Data Management: NPI, Credentialing, Network, and Provider Data Warehouse Design

The complete guide to healthcare provider data management for data architects and engineers. Covers NPI numbers, provider credentialing, network participation, taxonomy codes, and production-ready provider master data model design for Snowflake, Databricks, and BigQuery.

16 min read·Jun 14
provider dataNPI
Read more Provider Data

NPI Number Validation & Provider Data: A Practical Guide

How to validate NPI numbers using the Luhn algorithm, build a provider master data model, and reconcile against the NPPES registry — with SQL and Python examples for healthcare data engineers.

10 min read·Apr 29
NPINPPES
Read more

Stay Updated

Get the latest healthcare data architecture articles delivered to your inbox.