SCD Implementation Generator
Generates Slowly Changing Dimension implementations across platforms
Profile →npx skills add a5c-ai/babysitter --skill scd-implementation-generator --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# SCD Implementation Generator ## 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 ```json { "dimension": { "name": "string", "columns": ["object"], "businessKey": ["string"] }, "scdType": "1|2|3|4|6", "platform": "snowflake|bigquery|redshift|dbt", "trackingColumns": ["string"] } ``` ## Output Schema ```json { "ddl": "string", "mergeStatement": "string", "dbtConfig": "object", "documentation": "string" } ``` ## Target Processes - SCD Implementation - Dimensional Model Design - dbt Model Development ## Usage Guidelines 1. Define dimension structure with business keys 2. Select appropriate SCD type for business requirements 3. Specify target platform for syntax generation 4. Identify columns to track for historical changes ## Best Practices - Use SCD Type 2 for attributes requiring full history - Implement surrogat
- Overview
- Capabilities
- Input Schema
- Output Schema
- Target Processes
- Usage Guidelines
- Best Practices
What does the SCD Implementation Generator skill do?
Generates Slowly Changing Dimension implementations across platforms
How do I install it?
Run `npx skills add a5c-ai/babysitter --skill scd-implementation-generator --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From a5c-ai/babysitter, a repository with 1,642 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.