What levels of normalization does this skill support?

The skill supports normalization from 1st Normal Form (1NF) through Boyce-Codd Normal Form (BCNF), allowing users to target specific levels based on their database requirements.

Can I use this for recurring data imports?

Absolutely. Once a normalization structure is defined, the skill generates a transform_config.json that can be used to instantly process future CSV exports with the same schema.

Does it automatically identify primary keys?

Yes, the analysis script detects candidate keys and suggests primary key selections, which the user can then confirm or modify in the configuration file.

Does this skill provide visual documentation?

Yes, it generates erd.md files containing Mermaid syntax, which allows you to visualize the resulting entity-relationship diagram in compatible markdown viewers like VS Code or GitHub.

CSV Database Normalizer

Name: CSV Database Normalizer
Author: elertan

byelertan

0•

데이터베이스 관리

Transforms flat CSV files into normalized relational database structures by detecting functional dependencies and generating SQL schemas.

The csv-normalizer skill empowers Claude to convert denormalized data exports into efficient, relational database schemas. By analyzing data structures and identifying functional dependencies, it automates the decomposition of single CSV files into multiple tables adhering to 1NF, 2NF, 3NF, or BCNF standards. This tool is essential for developers migrating spreadsheet data to SQL databases, as it generates not only the normalized data files but also the corresponding SQL DDL statements and Mermaid entity-relationship diagrams for immediate implementation.

주요 기능

010 GitHub stars

02Multi-stage decomposition into 1NF, 2NF, 3NF, and BCNF structures

03Mermaid ERD generation for visual database schema documentation

04Automated functional dependency detection with confidence scoring

05SQL DDL generation including primary and foreign key constraints

06Reusable transformation configs for recurring data processing

사용 사례

01Converting legacy flat-file CSV exports into structured relational database schemas

02Designing database architectures directly from existing spreadsheet data

03Reducing data redundancy and improving integrity in large datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add elertan/claude-dotfiles csv-normalizer

For use in Claude.ai and ChatGPT

Download Skill