One-click install
npx skills add https://github.com/linhlvit/ubck_atomic_design --skill atomic-lld-design
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: atomic-lld-design
Source: https://github.com/linhlvit/ubck_atomic_design/tree/main/.claude/skills/atomic-lld-design
Command: npx skills add https://github.com/linhlvit/ubck_atomic_design --skill atomic-lld-design

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill eliminates inconsistent, error-prone low-level design (LLD) for source tables in the Atomic data layer of the UBCK Medallion architecture, which commonly causes mismatched attributes, failed ETL pipelines, and inconsistent data models across source systems.

Core Features & Use Cases

  • Guided LLD Workflow: Step-by-step process for designing compliant LLD files for individual source tables, including attribute mapping, data domain selection, and foreign key standardization.
  • Shared Entity Handling: Built-in rules for splitting Involved Party data into standardized shared entities (IP Postal Address, IP Electronic Address, IP Alt Identification) with consistent naming and classification formatting.
  • Validation & Consolidation: Automated pre-flight checks, post-validation workflows, and Level 2 entity consolidation support for merging attributes from multiple source systems into unified Atomic entities.
  • Use Case: A data modeler designing LLD for the NHNCK source system's PROFESSIONALS table can use this Skill to ensure all attributes are mapped correctly, shared entities are split properly, and all validation checks pass before human review.

Quick Start

Use the atomic-lld-design skill to generate a compliant LLD file for the NHNCK.PROFESSIONALS source table, mapping all source columns to Atomic attributes, handling shared Involved Party entities, and running all required validation checks.

Frequently Asked Questions about atomic-lld-design

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

FAQPage Schema
How do I create a compliant low-level design for source tables in a Medallion architecture?

Creating a compliant low-level design (LLD) for source tables involves mapping source columns to Atomic attributes, enforcing foreign key naming conventions, and running validation workflows to ensure the LLD files meet project requirements prior to human review.

What is the process for splitting shared Involved Party entities during data modeling?

Splitting shared Involved Party entities involves separating source data into standardized Atomic entities like IP Postal Address, IP Electronic Address, and IP Alt Identification, applying consistent naming conventions and classification value formatting across source systems.

How do I consolidate attributes from multiple source systems into unified Atomic entities?

To consolidate attributes from multiple source systems into unified Atomic entities, use Level 2 entity consolidation support to merge mapped attributes, ensuring standardized data domain selection and consistent data models across systems.

Does this LLD design workflow include automated validation checks?

Yes, the LLD design workflow includes automated pre-flight checks and post-validation workflows that verify attribute mappings, foreign key naming conventions, and classification formatting to ensure files pass project requirements before approval.

Why do ETL pipelines fail when mapping source table columns to Atomic data layers?

ETL pipelines fail when low-level design (LLD) for source tables is inconsistent, causing mismatched attributes, incorrect foreign key naming, and inconsistent data models across source systems in the Atomic data layer.

Can I standardize classification value formatting and data domain selection for Atomic entities?

Yes, you can standardize classification value formatting and data domain selection for Atomic entities by enforcing consistent low-level design (LLD) rules during the source table column mapping process.