SCD Implementation Generator

SkillDev tools

Generates Slowly Changing Dimension implementations across platforms

Instructions available. Your AI can read the instructions. Execution depends on the setup they require.

Account requirements not reviewed. Check the skill instructions before use; ahel provides instructions and does not run this skill.

Add ahel to your AI once: Claude, ChatGPT, Cursor, Claude Code or Codex. Then ask it to use this.

Then ask your AI: use the SCD Implementation Generator skill

What this skill tells your AI

The instructions your AI receives, as published by a5c-ai/babysitter in library/specializations/data-engineering-analytics/skills/scd-implementation-generator/SKILL.md and read by ahel’s review.

Overview

Generates Slowly Changing Dimension implementations across platforms. This skill automates the creation of SCD patterns for proper historical tracking.

Capabilities

SCD Type 1/2/3/4/6 implementation
MERGE statement generation
dbt snapshot configuration
Historical tracking optimization
Surrogate key management
Effective date handling
Current flag management
Mini-dimension design

Input Schema

{
  "dimension": {
    "name": "string",
    "columns": ["object"],
    "businessKey": ["string"]
  },
  "scdType": "1|2|3|4|6",
  "platform": "snowflake|bigquery|redshift|dbt",
  "trackingColumns": ["string"]
}

Output Schema

{
  "ddl": "string",
  "mergeStatement": "string",
  "dbtConfig": "object",
  "documentation": "string"
}

Target Processes

SCD Implementation
Dimensional Model Design
dbt Model Development

Usage Guidelines

Define dimension structure with business keys
Select appropriate SCD type for business requirements
Specify target platform for syntax generation
Identify columns to track for historical changes

Best Practices

Use SCD Type 2 for attributes requiring full history
Implement surrogate keys for dimension tables
Use effective dates rather than just current flags
Consider mini-dimensions for rapidly changing attributes
Test SCD logic with representative change scenarios

Signals

GitHub stars: 2k
Forks: 112
Last commit: Sep 2026

Advanced

Item type: skill
Key: scd-implementation-generator
Source: github.com/a5c-ai/babysitter

github.com/a5c-ai/babysitter