designing-database-schemas
Installation
SKILL.md
Overview
This skill assists in designing robust and normalized database schemas. It provides guidance on normalization principles, helps map relationships between entities, generates ERD diagrams for visualization, and ultimately produces SQL CREATE statements.
How It Works
- Schema Definition: Claude analyzes the user's request to understand the application's data requirements.
- Normalization & Relationship Mapping: Claude applies normalization principles (1NF to BCNF) and defines relationships between entities (one-to-one, one-to-many, many-to-many).
- ERD Generation: Claude generates a Mermaid diagram representing the Entity-Relationship Diagram.
- SQL Generation: Claude creates SQL CREATE statements for the tables, columns, indexes, and constraints.
When to Use This Skill
This skill activates when you need to:
- Design a new database schema from scratch.
- Normalize an existing database schema.
- Generate an ERD diagram for a database.
- Create SQL CREATE statements for a database.