Airflow Dag Patterns
Use when designing or reviewing Apache Airflow DAGs, task dependencies, sensors, retries, backfills, or pipeline tests.
Install
npx skills add sandbaseai/workbuddy-skill --skill airflow-dag-patternsgit clone --depth 1 https://github.com/sandbaseai/workbuddy-skill.git /tmp/workbuddy-skill
mkdir -p ~/.claude/skills
cp -r /tmp/workbuddy-skill/skills/airflow-dag-patterns ~/.claude/skills/airflow-dag-patternsPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Airflow DAG Patterns
设计可观察、可重试、可回放的数据编排。重点是 DAG 的时间语义、幂等任务、依赖等待、失败处理、测试和部署边界,而不是替用户直接触发生产任务。
## 使用边界
- 开始前确认 Airflow 版本、provider、时区、DAG 提交、数据范围、owner、SLA、连接引用和目标环境。
- 默认只读检查 DAG、配置、任务日志、依赖和测试;验证使用本地/CI/隔离环境及合成或脱敏数据。
- 不擅自触发生产 DAG、重试、清理、`backfill`、`clear`、`pause/unpause`、连接/变量修改或数据写入;这些操作需要明确授权。
- 日志、XCom、样本和报告不得保存 secret、token、完整客户行或可还原的个人标识。
## DAG 设计
每个 DAG 说明业务目的、输入分区、输出、粒度、调度时区、数据就绪条件、最大并发、超时、SLA、重跑和所有者。任务应满足:
- 幂等:同一逻辑日期重复执行不会重复写入或产生不同结果;用分区键/幂等键和事务边界约束写入。
- 原子:失败不会留下“成功”标记或半成品;临时结果在校验后再发布。
- 可增量:按逻辑日期和 watermark 处理,明确迟到数据、删除和更新语义。
- 可观察:结构化日志、耗时/行数/新鲜度指标、失败上下文和告警都能追溯到 DAG run 与 task instance。
使用 TaskFlow API 或清晰的 Operator 封装任务逻辑。DAG 文件保持轻量,避免导入时联网、查询数据库、读取不稳定的全局状态或执行重计算。
```python
from datetime import datetime, timedelta
from airflow.decorators import dag, task
@dag(
dag_id="daily_orders",
schedule="0 6 * * *",
start_date=datetime(2024, 1, 1),
catchup=False,
max_active_runs=1,
dagrun_timeout=timedelta(hours=2),
tags=["etl"],
)
def daily_orders():
@task(retries=3, retry_exponential_backoff=True,
execution_timeout=timedelta(minutes=30))
def extract(logical_date=None):
# Use the logical date/partition, not wall-clock "now".
return {"partition": logical_date.strftime("%Y-%m-%d")}
@task
def validate(input_ref):
# Validate completeness and schema before publishing output.
return input_ref
validate(extract())
daily_orders()
```
## 依赖、传感器与分支Details
- Skill name
airflow-dag-patterns- Repository
- sandbaseai/workbuddy-skill
- Path
skills/airflow-dag-patterns/SKILL.md- License
- MIT
- Repo updated
- 8 September 2026
FAQ
What does the Airflow Dag Patterns skill do?
Use when designing or reviewing Apache Airflow DAGs, task dependencies, sensors, retries, backfills, or pipeline tests.
How do I install the Airflow Dag Patterns skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add sandbaseai/workbuddy-skill --skill airflow-dag-patterns. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Airflow Dag Patterns popular?
It lives in sandbaseai/workbuddy-skill, which has 9 GitHub stars and 3 forks.
Related skills
Access Control Security Best Practices
9sandbaseai/workbuddy-skill
Design, review, implement, and verify least-privilege access controls across users, services, tenants, resources, and administrative workflows.
Accessibility Review
9sandbaseai/workbuddy-skill
Use when reviewing a web interface or interaction for semantic, keyboard, focus, screen-reader, ARIA, and contrast accessibility risks.
Acquire Codebase Knowledge
9sandbaseai/workbuddy-skill
Use when the user asks to map, document, or onboard into an existing codebase and needs evidence-backed architecture, structure, conventions, integrations, testing, and concerns documentation.
Chaos Engineer
9sandbaseai/workbuddy-skill
Use when designing or running authorized resilience experiments, failure-injection tests, or game days for distributed systems. Requires a written hypothesis, verified steady state, bounded blast radius, and tested rollback.
Skills Review
9flurdy/agent-skills
Explicit, skeptical review of a source skill collection. Screens the catalog, tests sampled skills' necessity, and proposes evidence-backed trims, merges, retirements or fixes; read-only until selected findings go to triage.
Deep Project Primer
9sandbaseai/workbuddy-skill
Build an evidence-backed project baseline before significant work by inspecting repository guidance, architecture, runtime, tests, and delivery constraints.
Browse the most popular Claude skills, all testing & qa skills, or write your own with the skills generator.