agentsclimarketplace

Dw self test

Skill pugyy/dw-harness/template/.claude/skills/dw-self-test

A Claude Code engineering template for reliable data warehouse AI development./面向数仓 AI 开发的 Claude Code 工程化模板：hooks、skills、subagents 与八步标准流程。

Install
npx -y skills add pugyy/dw-harness --skill dw-self-test

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • 3 stars3 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

数仓自测流程，适用于通过 data-quality-checker subagent 执行 23 项标准自测并只返回摘要。直接调用命令：/dw-self-test。

SKILL.md

1.3 KB, as published. Nobody here has run it

Step 4: 自测

执行流程

  1. 调用 data-quality-checker subagent 执行 23 项标准自测
  2. subagent 在独立 context 运行，防止大量输出撑爆主 context
  3. 主对话只接收摘要结果

23 项标准自测

完整性 (8 项)

  1. 主键非空
  2. 分区数据量
  3. 必填字段非空
  4. 外键关联完整性
  5. 去重后数据量对比
  6. 空值率统计
  7. 枚举字段值域
  8. 重复记录

准确性 (6 项)

  1. 核心金额字段容差 (≤0.01%)
  2. 数值字段范围
  3. 日期字段合理性
  4. 字符串长度
  5. 类型一致性
  6. 业务规则校验

一致性 (5 项)

  1. 上下游数据量一致性
  2. 关联字段口径一致性
  3. 汇总表与明细表一致性
  4. 标志位联动逻辑
  5. 跨表口径一致性

时效性 (4 项)

  1. 数据产出时间 (SLA ≤ 次日 8:00)
  2. 分区数据完整性
  3. 增量数据连续性
  4. 数据更新频率

推荐提示词

用 data-quality-checker subagent 对 [表名] 执行 23 项标准自测，
partition_dt = '[日期]'，只返回未通过的项目和总结。

输出

由 data-quality-checker subagent 返回结构化报告，主对话只接收通过/失败总结。

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.