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 (1)Tools & ComparisonsProvider DataHealthcare Data ModelingMember EnrollmentData ModelingRevenue CycleClaims & AdjudicationHealthcare Data PlatformsHealthcareData ArchitectureSQL & PerformanceDatabase MigrationPharmacyData EngineeringData GovernanceCloud ArchitectureRisk AdjustmentDDL & SQLHealthcare StandardsPharmacy DataHealthcare Data EngineeringTools

Healthcare Data Engineering Articles

1 article

Healthcare Data Engineering

NPI Validation in Python: Luhn Algorithm, NPPES Lookup, and Snowflake UDF Guide

Every healthcare data warehouse has a provider dimension table with NPI numbers. Bad NPIs cause claims rejections, failed eligibility checks, and broken provider analytics. This guide shows you how to validate NPIs programmatically — from format checking to Luhn algorithm to bulk Snowflake UDF deployment.

10 min read·May 31
PythonNPI
Read more

Stay Updated

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