Skills
.Work. You
Rest

normalized

Community

Pragmatic 3NF database schema generation.

Software Engineering#database design#oltp#data contracts#schema modeling#ddl generation#3nf
AuthorSemprini
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill addresses the challenge of translating conceptual data models into practical, operational database schemas, specifically focusing on Third Normal Form (3NF) designs for OLTP systems.

Core Features & Use Cases

  • 3NF Schema Generation: Creates physical database DDL (e.g., PostgreSQL, SQL Server) from logical models.
  • Data Contract Outputs: Generates JSON Schema and Parquet schema contracts for data products.
  • Pragmatic Denormalization: Allows for intentional, documented deviations from strict 3NF to improve usability and performance.
  • Use Case: Generate a PostgreSQL DDL script for a customer domain model, including appropriate primary keys, foreign keys, and temporal columns, while allowing selective denormalization for frequently accessed descriptive attributes.

Quick Start

Generate a PostgreSQL DDL script for the customer domain model, applying pragmatic 3NF principles.

Dependency Matrix

Required Modules

None required

Components

references

💻 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: normalized
Download link: https://github.com/Semprini/md-ddl/archive/main.zip#normalized

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 223,000+ vetted skills library on demand.