Defeating Schema Chaos: Automated Metadata & PHI/PII Flags for Healthcare Data Teams

Short summary

mdatool automates healthcare data documentation and compliance by generating data dictionaries, dbt schema.yml files, and PHI/PII tags from raw DDL scripts. The tool supports Snowflake, BigQuery, and Databricks, with features for automated sensitive-field detection, naming convention enforcement, and HL7 v2 parsing. It aims to reduce manual compliance work that risks HIPAA violations when columns are deployed without proper masking.

• •Automated metadata generator creates data dictionaries and dbt configs from raw DDL
• •PHI/PII tagging isolates sensitive fields at design phase before production deployment
• •Supports Snowflake, BigQuery, Databricks with HL7 v2 parsing and ISO-11179 naming standardization

Generated with AI, which can make mistakes.