skills.rest
RDEWAI
RDEWAIOFFICIAL
Explore all skills by this author →
GitHub

create-dms

Generate compliant Data Model Specification documents from HLD and DRD inputs.

5|1|Updated Sep 23, 2025
Search Tags:#data modeling#duckdb#medallion architecture#dms#hld#scd#drd
One-click install
npx skills add https://github.com/RDEWAI/Redefining-DataEngineering-With-AI --skill create-dms
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: create-dms
Source: https://github.com/RDEWAI/Redefining-DataEngineering-With-AI/tree/main/chapter-6/data-modeler-plugin/skills/create-dms
Command: npx skills add https://github.com/RDEWAI/Redefining-DataEngineering-With-AI --skill create-dms

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the error-prone, time-consuming process of manually creating data model specifications that are misaligned with high-level architecture designs and business requirements, reducing rework and ensuring consistency across data engineering teams.

Core Features & Use Cases

  • Structured Schema Elicitation: Guides users through targeted Q&A to gather complete, specific schema decisions for bronze, silver, and gold medallion layers, rejecting vague inputs to avoid ambiguous designs.
  • Source Validation: Verifies actual source table structures and column types via read-only DuckDB queries to prevent schema mismatches that cause failed transformations or silent data loss.
  • Compliant DMS Generation: Produces dual-format Data Model Specification documents with markdown narrative and embedded YAML schema blocks, including Mermaid ER and flow diagrams, SCD strategy documentation, and full HLD/DRD traceability.
  • Use Case: A healthcare data engineering team can use this Skill to automatically generate a compliant DMS for patient, encounter, and condition tables across bronze, silver, and gold layers, ensuring alignment with PHI governance policies, SCD requirements, and enterprise naming standards.

Quick Start

Provide your approved HLD and DRD documents to the create-dms skill to generate a complete, compliant data model specification with medallion layer schemas, SCD strategies, and full traceability matrices.

Frequently Asked Questions about create-dms

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a data model specification from HLD and DRD documents?▼

To generate a data model specification, provide approved HLD and DRD documents as inputs. The skill validates source structures via DuckDB and outputs a compliant DMS with bronze, silver, and gold layer schemas, SCD strategies, and embedded YAML schema blocks.

What is a medallion architecture data model and how does it handle SCD types?▼

A medallion architecture data model organizes data into bronze, silver, and gold layers. The skill processes these layers by assigning Slowly Changing Dimension (SCD) type strategies and enforcing enterprise naming conventions within the generated specification.

Does the data modeling workflow validate source structures against DuckDB?▼

Yes, the data modeling workflow validates actual source table structures and column types using read-only DuckDB queries. This prevents schema mismatches and avoids failed transformations or silent data loss during model creation.

Can I use HLD and DRD traceability for downstream data quality engineering?▼

Yes, the generated DMS includes full HLD and DRD traceability matrices. This traceability explicitly supports downstream mapping and data quality engineering teams by linking schema definitions back to approved business requirements.

What format is the output data model specification delivered in?▼

The data model specification is delivered in a dual-format document containing markdown narrative and embedded YAML schema blocks. It also includes Mermaid ER and flow diagrams to visually represent the data model.

How to define bronze, silver, and gold layer schemas for a new data model?▼

Defining bronze, silver, and gold layer schemas requires structured elicitation through targeted Q&A. The skill guides you to gather specific schema decisions for each medallion layer, rejecting vague inputs to ensure clear and unambiguous designs.

Related Skills

Explore More Data & Analytics Skills→
RDEWAIRDEWAI
5

create-lld

Generate a 14-section Low-Level Design document from approved data engineering artifacts.

Official
Advanced
RDEWAIRDEWAI
5

validate-dms

Validate DMS documents for completeness and quality standards.

Official
Intermediate
sergeyitalysergeyitaly
1

adx-schema-check

Validate KQL query identifiers against canonical ADX schema definitions.

Community
Intermediate
RDEWAIRDEWAI
5

update-dms

Merge schema changes and SCD updates into DMS documents with versioning.

Official
Advanced