Updates an existing Sprint Backlog with new information. Reads the existing backlog, epics, and stories, then merges updated LLD requirements, changed upstream artifacts, revised team capacity, or sprint re-planning. Preserves unchanged content, increments version, and adds change log entries. Use when the user asks to update, revise, or modify existing stories or epics.
Marks Scrum stories Done and rolls epic/backlog status up once every child is complete. BLOCKS completion if any story AC checkbox is unchecked, any dependency is not Done, any referenced deliverable is missing, or any epic-level AC is still open. Uses Edit (not Write) to flip only the Status cell and AC checkboxes, preserving every other line. If the gate blocks on ANY target, NOTHING is edited — the run is atomic from the user's view. Use when the user asks to: - Mark STORY-NN-NNN complete / close a story - Close out EPIC-NN / roll up epic status - "Are we done with sprint 3 yet?" (gate run without edits is acceptable)
Generates an Airflow DAG from the LLD artifact and pipeline configs. Reads the approved LLD from outputs/, applies DAG templates, and writes a production-ready DAG file to airflow/dags/. Also known as: dag generation, pipeline scaffolding, airflow pipeline creation. Input formats: LLD markdown, DAG config YAML. Output format: Python DAG file (.py). Use when the user asks to: - Create, generate, or scaffold an Airflow DAG - Translate an LLD into a runnable pipeline - Build a DAG for bronze/silver/gold layers
Generates layer-scoped local deploy smoke artifacts: shell scripts under _infra/cd/ that re-apply DDL migrations and re-sync the Airflow DAG bag, plus a pytest smoke module under tests/integration/ that drives those scripts and re-triggers the layer DAG end-to-end. Pairs with the scrum-master deploy-validation story type 1:1. Use when the user asks to: - Author the local deploy smoke for a layer (bronze / silver / gold) - Wire up _infra/cd/ scripts (DAG sync, DDL apply) for local - Implement a deploy-validation story (STORY-NN-NNN typed deploy-validation)
Generates the Gold layer of the Patient 360 Medallion pipeline from the approved LLD §2.3 / §5.3, DMS §4, STM Silver-to-Gold sheet, DQS §2-3 (Gold rules), and a given story. Emits PySpark builder modules for the Gold consumer tables declared in LLD §5.3 (currently `patient_summary`, `patient_clinical_history`, `patient_billing_summary` — derived at runtime, not hardcoded), per-table contracts, per-table Spark Expectations DQ rule files, unit tests, and the DAG wiring for the `gold_build` task group. Modes: - Story mode: STORY-NN-NNN — emit only Gold deliverables in scope - Full mode: process every un-Done story classified as `gold`, topo-sorted by Depends On, until the Gold layer is complete Project-agnostic: the table list, source-table joins, business-invariant DQ rules, and module names are ALL read from the LLD §5.3, DMS §4, STM Silver-to-Gold sheet, and DQS §2-3 at runtime. Use when the user asks to: - Generate or update Gold layer code for a story or epic - Build the Gold consumer tables (patient_sum
Generates the Bronze config-driven ingestion layer from the approved LLD, DMS, STM, DQS, and a given story. Modes: - Story mode: read a STORY-NN-NNN, extract backtick-quoted deliverables from its Acceptance Criteria, generate only those that fall under this skill's domain of ownership. ROUTE-OUT for others. - Full mode: process every un-Done story classified as `ingestion`, topo-sorted by Depends On. Project-agnostic: the table list, critical-table designation, per-table DQ rule filenames, and runner module names are ALL read from the current run's LLD / DMS / STM / DQS / stories at runtime. No project identifiers or story IDs are hardcoded. Use when the user asks to: - Generate or update Bronze ingestion code for a story - Build the ingestion runner / factory / SparkSubmit wrapper - Generate per-table ingestion configs
Generates CI/CD pipeline configuration (GitHub Actions / GitLab CI) from the project structure and LLD artifact. Produces lint, test, and deploy workflow files targeting the medallion pipeline. Use when the user asks to: - Create, generate, or scaffold a CI/CD pipeline - Set up GitHub Actions or GitLab CI for the project - Automate testing and deployment of the data pipeline
Generates the foundation layer of a cookiecutter-chapter project: directory tree via cookiecutter render, pyproject.toml, Makefile, docker-compose, cross-cutting utility modules under `src/<project>/utils/`, StructType schema contracts, and test-harness scaffolding. Foundation assets that every other generator (create-dag, create-ingestion, create-pipeline) assumes exist. Project-agnostic: all project-specific facts (table lists, module names, interface contracts) are read from the current run's LLD / DMS / story file at runtime. Use when the user asks to: - Scaffold the project / bootstrap the chapter - Implement a foundation-layer story (utility modules, config loader, contracts, docker-compose)