entity-relationship-modeling
CommunityDesign robust database schemas from ER models.
Software Engineering#database design#normalization#schema migration#entity relationship#temporal modeling#foreign key constraints#junction table
Authorjacob-balslev
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Entity-relationship modeling turns unclear conceptual requirements into correct, constraint-backed database tables that are safe to migrate and resilient to real-world data.
Core Features & Use Cases
- ER-to-SQL translation: Convert ER notation into concrete relational structures with primary keys, foreign keys, junction tables, and constraints.
- Normalization & denormalization guidance: Choose appropriate normal forms for OLTP correctness and decide when denormalization is justified for performance.
- Temporal modeling & inheritance mapping: Implement SCD strategies and inheritance patterns (STI/class-table/concrete-table) without breaking integrity.
- Quality verification checklist: Validate identity, referential actions, indexing expectations, and anti-pattern avoidance (EAV, polymorphic associations, mega-tables).
Quick Start
Use entity-relationship-modeling to translate your ER diagram for an Orders system into a PostgreSQL schema with correct keys, foreign keys, constraints, and indexing assumptions.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: entity-relationship-modeling Download link: https://github.com/jacob-balslev/skill-graph/archive/main.zip#entity-relationship-modeling Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.