Data Lineage Impact Analyzer

Use when analyzing upstream and downstream impact for table changes, metric changes, field deprecation, pipeline migration, dashboard breakage, data governance review, or data asset dependency communication. 中文触发词:血缘分析、影响评估、字段下线、改口径的影响范围、下游影响。

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add shisuidata/ss-data-skills --skill data-lineage-impact-analyzer
Manual install
git clone --depth 1 https://github.com/shisuidata/ss-data-skills.git /tmp/ss-data-skills
mkdir -p ~/.claude/skills
cp -r /tmp/ss-data-skills/skills/data-lineage-impact-analyzer ~/.claude/skills/data-lineage-impact-analyzer

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# Data Lineage Impact Analyzer

## 目标

分析数据表、字段、指标、任务或口径变更会影响哪些下游,并输出可执行的影响评估和沟通方案。

这个 Skill 关注变更影响,而不是完整血缘系统建设。

## 使用场景

使用这个 Skill,当用户需要:

- 修改表结构、字段、分区、口径前做影响评估
- 下线字段、迁移表、重构任务或切换数据源
- 排查某个上游异常会影响哪些看板、报表、模型和业务方
- 数据治理中梳理资产依赖和通知范围
- 为变更评审会准备影响分析材料

## 不适用场景

不要使用这个 Skill 处理:

- 从零建设数据血缘平台
- 审查 SQL 正确性,应使用 `sql-reviewer`
- 设计新表,应使用 `table-design-advisor`
- 写事故复盘,应使用 `data-incident-postmortem-writer`
- 没有任何表、字段、任务或下游信息时断言影响范围

## 输入信息

最少输入:

- 变更对象:表、字段、指标、任务或数据源
- 变更类型:新增、修改、删除、迁移、下线、口径调整
- 已知上下游信息

推荐输入:

- 表结构、字段说明、分区和更新频率
- 上游来源、调度依赖、任务名
- 下游表、看板、报表、指标、模型、接口
- 血缘边表 CSV(`upstream`、`downstream`,可选 `upstream_column`)、dbt 的 `manifest.json`,或生产 SQL 文件
- 资产表 CSV(`name`、`type`、`owner`、`importance`),用于分级和通知清单
- 变更时间、灰度策略、回滚方案
- 业务负责人、数据负责人、通知对象

## 上下文建议

优先使用这些模板准备上下文:

- [表设计上下文模板](../../context/templates/table-context.md)
- [SQL 审查上下文模板](../../context/templates/sql-review-context.md)
- [通用数据任务上下文](../../context/templates/data-task-context.md)
- [报告上下文模板](../../context/templates/report-context.md)

上下文不足时,只能输出影响评估框架和待补充血缘信息,不要假设不存在的下游。

## 分析流程

1. 明确变更对象和变更类型。
2. 拆分影响面:字段、指标、任务、表、看板、报表、接口、模型、业务流程。
3. 识别影响等级:P0 下游会立刻报错,或核心对象的数字含义改变;P1 需要同步修改或口径变化;P2 间接影响;P3 无直接影响。
4. 判断是否需要兼容期、双跑、回滚和补数。
5. 输出通知对象和沟通节奏。
6. 列出上线前检查、上线后验证和回滚条件。

## 可用脚本

有血缘数据时,用脚本算下游闭包,不要靠记忆列举:
Read the full skill on GitHub

Details

Skill name
data-lineage-impact-analyzer
Path
skills/data-lineage-impact-analyzer/SKILL.md
License
MIT
Repo updated
8 November 2026

FAQ

What does the Data Lineage Impact Analyzer skill do?

Use when analyzing upstream and downstream impact for table changes, metric changes, field deprecation, pipeline migration, dashboard breakage, data governance review, or data asset dependency communication. 中文触发词:血缘分析、影响评估、字段下线、改口径的影响范围、下游影响。

How do I install the Data Lineage Impact Analyzer skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add shisuidata/ss-data-skills --skill data-lineage-impact-analyzer. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Data Lineage Impact Analyzer popular?

It lives in shisuidata/ss-data-skills, which has 9 GitHub stars and 0 forks.

Related skills

Ab Test Analysis

9

shisuidata/ss-data-skills

Use when designing, checking, or interpreting A/B tests and experiments. Computes significance, confidence intervals, sample ratio mismatch, power, CUPED, and sample size with a bundled zero-dependency script, then judges validity risks, guardrails, and ship/iterate/rollback decisions and renders an HTML experiment report. 中文触发词:A/B 实验、AB 测试、实验解读、显著性、样本量计算、能不能全量。

Testing & QA

Business Root Cause Analysis

9

shisuidata/ss-data-skills

Use when diagnosing business metric changes or anomalies such as GMV decline, conversion drop, retention loss, churn increase, revenue change, lead decline, or active user fluctuation with a structured root cause analysis plan. 中文触发词:指标归因、为什么下降、异常排查、GMV 下滑、指标波动原因。

Marketing, Sales & Business

Daily Report Writer

9

shisuidata/ss-data-skills

Use when writing a concise daily report, daily worklog, standup update, shift handoff, or end-of-day summary for data analysis, data development, BI, governance, or operations work. 中文触发词:日报、日终同步、站会发言、值班交接。

Writing & Content

Data Requirement Clarifier

9

shisuidata/ss-data-skills

Use when a vague data analysis or data development request needs to be turned into a clear, buildable task. Clarifies business goal, metrics, dimensions, time range, data sources, output format, acceptance criteria, risks, and open questions. 中文触发词:需求澄清、模糊需求、临时取数、需求拆解、业务想看。

Data & Analytics

Data Analysis Report Writer

9

shisuidata/ss-data-skills

Use when turning analysis results, metrics, SQL outputs, or investigation notes into a structured data analysis report for business readers. Composes a bundled zero-dependency script's report spec into a self-contained HTML report plus Markdown, where every number is bound to a source JSON (outputs of ab-test, funnel, retention, EDA scripts or user-supplied facts) via {{source:path|format}} references, traced in an appendix, and linted for unsourced numbers, missing evidence, causal overclaiming, and vague actions. 中文触发词:分析报告、数据报告、专题报告、报告数字核对。

Data & Analytics

Data Viz Kit

9

shisuidata/ss-data-skills

Use when producing any chart, data report page, KPI tile, or visual data deliverable for Chinese business audiences. Provides chart-choice rules, Chinese number and period conventions (万/亿, 同比/环比, 涨跌色), a validated light/dark palette, and a zero-dependency Python kit that renders self-contained HTML reports. 中文触发词:图表规范、选图、配色、数据可视化、HTML 数据报告。

Data & Analytics

Browse the most popular Claude skills, all data & analytics skills, or write your own with the skills generator.