Data Modelling Skill

What problem does it solve?

This Skill helps you design database schemas that reflect real business entities and relationships without unnecessary complexity, reducing rework and modeling mistakes.

Core Features & Use Cases

• Universal data model patterns: Leverages battle-tested patterns (e.g., Party, Product, Order/Transaction, Work Effort, Accounting) as a starting point.
• Simple-to-complex progression: Recommends the simplest viable schema variant first, adding temporal/versioning complexity only when business rules require it.
• OLTP vs OLAP schema choices: Translates requirements into either normalized (3NF) transactional schemas or dimensional (star/snowflake) analytical schemas.
• DDL-ready outputs: Produces concrete table/column/relationship designs and CREATE TABLE DDL tailored to common SQL dialects.

Quick Start

Describe your business domain and key entities, then ask for a schema that starts simple and includes the necessary joins and DDL for your database vendor.