csv-to-normalized-db-migration

What problem does it solve?

This Skill provides a structured workflow to migrate flat or wide CSV data (including clinical datasets) into a normalized PostgreSQL schema using an EAV + event-sourcing model, covering column mapping, ontology alignment, value normalization, and SQL generation to support auditable migrations.

Core Features & Use Cases

• Extract CSV columns and sample rows to understand structure and data quality.
• Map CSV columns to ontology variables and event types, generating deterministic IDs and ensuring idempotent SQL.
• Normalize values, handle missing data, and generate the necessary inserts for patients, events, and values.
• Support deriving indicators and creating views to compute derived metrics after migration.

Quick Start

Run the provided migrate_csv.py against your data.csv to generate the migration SQL and apply it to your PostgreSQL database.