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 engineers & architects.

Blog

Healthcare Data Insights

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

Filter:All (1)Tools & ComparisonsHealthcare Data ModelingHealthcare Data PlatformsData ModelingHealthcareData ArchitectureSQL & PerformanceDatabase MigrationPharmacyData EngineeringData GovernanceCloud ArchitectureProvider DataRisk AdjustmentDDL & SQLHealthcare StandardsPharmacy DataHealthcare Data Engineering

Provider Data Articles

1 article

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.