cyberneticlibrary

Design database schemas and ERDs

database-schema-designerskillsetup L117,464
alirezarezvani/claude-skills
What it does

the user asks to create erd diagrams

Best for

Designing normalized relational schemas with ERD diagrams and DDL generation from high-level requirements.

Inputs
  • · schema requirements
  • · entity relationships
Outputs
  • · ERD diagram
  • · SQL DDL statements
Preconditions

Database system selected; schema requirements defined

Failure modes
  • · Circular references
  • · Missing foreign keys
  • · Cardinality mismatch
Trust signals
  • · Normalization rules (3NF/BCNF)
  • · Circular reference detection