Generate 3NF physical database schemas and data contracts from conceptual models.
npx skills add https://github.com/Semprini/md-ddl --skill normalized
Please help me install this Agent Skill. Skill: normalized Source: https://github.com/Semprini/md-ddl/tree/main/agents/agent-artifact/skills/normalized Command: npx skills add https://github.com/Semprini/md-ddl --skill normalized
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.
Generate a PostgreSQL DDL script for the customer domain model, applying pragmatic 3NF principles.
High-intent search queries and answers about installing and using this skill.
This Skill creates 3NF database schemas by translating conceptual models into physical DDL for PostgreSQL, SQL Server, Snowflake, and Databricks SQL. It automatically handles primary keys, foreign keys, temporal data, enums, and inheritance during generation.
You can generate JSON Schema and Parquet schema contracts directly from your logical models. These outputs define structured data products, ensuring schema consistency across OLTP systems and downstream data platforms.
This approach supports selective denormalization for OLTP performance by allowing documented deviations from strict 3NF. It intentionally denormalizes frequently accessed descriptive attributes to improve query usability while maintaining overall schema integrity.
The best way to model temporal data and enums in a physical DDL is through pragmatic 3NF schema generation. It incorporates specialized handling for temporal columns and enum types directly into the database DDL creation process.
You can use this to create DDL for both PostgreSQL and Databricks SQL, along with SQL Server and Snowflake. It generates platform-specific physical database schemas tailored to each system's syntax.
You should not use strict Third Normal Form when query performance or usability suffers from excessive joins. This Skill applies pragmatic denormalization, allowing documented deviations to optimize frequently accessed descriptive attributes in OLTP systems.
SSiertsemaDefine domain entities, relationships, and business rules in plain language.
PixoraftManage PostgreSQL databases and execute safe SQL queries across environments.
pluginagentmarketplaceVersion-control database schema migrations with rollback plans and audit trails.
natslashDesign normalized SQL and NoSQL schemas with reversible migration scripts.
