Skills
.Work. You
Rest

logical-data-modeling

Community

Generate neutral, normalized data models.

Data & Analytics#normalization#data-modeling#database-design#er-diagram#referential-integrity#domain-analysis#logical-model
AuthorSSiertsema
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Produces a technology-agnostic logical data model that documents domain concepts as normalized entities, attributes, keys, and relationships, serving as a bridge between business requirements and physical database design.

Core Features & Use Cases

  • Normalization-focused modeling: enforces 1NF through 3NF with explicit PKs, FKs, natural or surrogate keys, and constraints (NOT NULL, UNIQUE, CHECK).
  • Entity- and relationship-centric output: per-entity attributes, keys, and constraints; relationship cardinalities and cascade rules; support for M:N via junctions.
  • Diagrams and reports: Mermaid ERD visuals and a structured report covering scope, entities, relationships, normalization verification, and referential integrity decisions.
  • Fail-safe guidance: avoids vendor-specific types and preserves conceptual clarity to guide physical-model input.

Quick Start

Describe your domain concept and target normalization level to generate a technology-agnostic logical data model.

Dependency Matrix

Required Modules

None required

Components

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: logical-data-modeling
Download link: https://github.com/SSiertsema/claude-code-plugins/archive/main.zip#logical-data-modeling

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.