Integrate SQL into Nomad Data Stack layers with migration files.
npx skills add https://github.com/isMxy0934/the-nomad-data-stack --skill create-table
Please help me install this Agent Skill. Skill: create-table Source: https://github.com/isMxy0934/the-nomad-data-stack/tree/main/.claude/skills/create-table Command: npx skills add https://github.com/isMxy0934/the-nomad-data-stack --skill create-table
This Skill helps you plug existing SQL into The Nomad Data Stack across the ODS, DIM, DWD and ADS layers. It automates the setup for new tables, data sources and layer configurations by generating the necessary SQL files, migration scripts, and dependency configurations, reducing manual work and potential errors.
Provide the target layer (e.g., ODS or DIM) and the target table name with a type suffix (e.g., ods_fund_etf_spot_full) and share your prepared SQL along with any dependencies. Claude will generate the necessary DAGs, migrations, and config templates to integrate it into the stack.
High-intent search queries and answers about installing and using this skill.
Integrating SQL into a data stack layer involves specifying your target layer (ODS, DIM, DWD, or ADS), providing your SQL query, and declaring dependencies. This Skill automates the generation of migration files, SQL scaffolds, and configuration updates needed to connect your query to the Nomad Data Stack, applying layer-specific naming conventions and partition columns automatically.
SQL migration to a data stack enforces naming conventions with _full, _inc, and _zip suffixes to indicate load type and incrementality. This Skill generates correctly located SQL files, migration scripts, and dependency configurations that match your target layer's template structure, ensuring consistency and preventing manual setup errors.
Yes. When onboarding SQL into a data stack layer, you can specify upstream data sources and declare table dependencies. This Skill automatically registers those relationships in configuration files, generates the necessary DAG definitions for Airflow orchestration, and scaffolds migration views to bootstrap new tables with proper lineage tracking.
No. This Skill automatically generates migration files and view scaffolds based on your SQL and target layer. It handles DAG creation, file placement, partition column injection, and naming compliance, reducing manual work and potential errors during the SQL onboarding process.
This Skill supports integration across ODS, DIM, DWD, and ADS layers in the Nomad Data Stack. For each layer, it enforces appropriate naming conventions and generates layer-specific SQL files, migrations, and configurations, enabling you to connect raw sources or upstream tables regardless of target depth.
Partition columns are automatically injected as ${PARTITION_DATE} during SQL scaffolding. The naming convention suffixes (_full, _inc, _zip) indicate load type and incrementality strategy. This Skill generates the correct file templates and migrations for each pattern, ensuring your table integrates seamlessly with the stack's scheduling and data refresh logic.
MJ-AgentLabManually trigger the QVL ETL pipeline from biz_ods to biz_dwd via direct SQL calls.
astronomerTrace downstream data lineage and assess impact across tables, DAGs, and dashboards.
JhabbigBuild Apache Airflow DAGs with task dependencies, sensors, and retries.
AdamAwanGenerate Postgres migration files for Markdown Magpie's custom SQL migrator.
