Convert legacy SQL into layered dbt models with build validation.
npx skills add https://github.com/miptah21/skills --skill migrating-sql-to-dbt
Please help me install this Agent Skill. Skill: migrating-sql-to-dbt Source: https://github.com/miptah21/skills/tree/main/.agents/skills/migrating-sql-to-dbt Command: npx skills add https://github.com/miptah21/skills --skill migrating-sql-to-dbt
Migrating legacy SQL into dbt without breaking logic or losing validation.
Ask the skill to convert your legacy SQL file into dbt by first discovering existing models and sources, then creating missing sources, building staging models, and validating each layer before producing the final mart model.
High-intent search queries and answers about installing and using this skill.
Migrating legacy SQL to dbt involves breaking monolithic queries into staging, intermediate, and mart models while validating row-level outputs through incremental dbt builds. This approach converts stored procedures and raw query files into maintainable transformations without breaking existing logic.
Splitting monolithic SQL queries requires project-aware discovery to map referenced tables to existing models or new sources. You create missing YAML sources, build staging models first, validate them, and then produce the final mart model incrementally.
Converting stored procedures does not require manual sources.yml creation if the migration process handles project-aware discovery. It automatically checks for existing models and sources, creating missing YAML sources only when necessary during the port.
Validating row-level outputs when refactoring SQL into dbt models is done by running incremental dbt builds per layer and using dbt show. This ensures each staging, intermediate, and mart model maintains data integrity before moving to the next step.
Porting existing views into dbt without breaking logic is achieved through iterative build-and-validate requirements. The migration checks for model and source existence, applies layer-by-layer conversion, and adds tests and documentation during the port to preserve validation.
AltimateAIConvert SQL stored procedures, views, and raw SQL files into dbt models.
sfc-gh-dflippoSelect and implement dbt materializations for models with configuration options.
JhabbigOrganize dbt transformations into staging, intermediate, and mart layers.
Sir-chawakornModernize legacy applications using Strangler Fig and Anti-Corruption Layer patterns.
