Skip to main content
skill CX Codex

impact — Claude Code skill: dependency analysis and install

The impact Claude Code skill maps what depends on a table, column, or function. It gathers upstream sources, downstream consumers, checks, and a safe change order.

MIT ★ 106 updated 2026-11-06

Install into Claude Code · Plugin marketplace All methods and platforms ↓
/plugin marketplace add DataWithBaraa/claude-code-data-engineering-skills
/plugin install data-engineering@data-with-baraa
Open on GitHub

What impact does

impact traces the effects of changing a table, column, function, or file. It finds upstream inputs and downstream tables, views, reports, tests, and jobs in SQL and code. Query logs show which roles and teams used downstream tables during the last period.

The skill lists relevant checks and tests, counts the affected tables, data products, consumers, queries, and checks, then lays out the change sequence: what to edit or rebuild, what to compare, and whom to notify. It reads SQL, code, data contracts, query logs, checks, and tests.

The result is a single HTML page with a dependency graph and lists. impact does not make changes, and it only reports dependencies found in code or logs.

What it helps with

  • trace the inputs behind a table or function
  • find reports and jobs affected by a change
  • identify teams and roles querying downstream tables
  • plan the order for edits and rebuilds

Example prompts for the agent

  • Map the effects of changing the orders table and lay out a safe sequence.
  • Find the objects and tests that depend on the customer_id column.
  • Analyze the impact of changing calculate_total and produce the HTML result.

How to install impact

1Plugin marketplace

/plugin marketplace add DataWithBaraa/claude-code-data-engineering-skills
/plugin install data-engineering@data-with-baraa

This installs the whole data-engineering plugin with all its skills

2Skills CLI (Vercel)

npx skills add DataWithBaraa/claude-code-data-engineering-skills --skill impact -a claude-code

3Manually: put the files in place

~/.claude/skills/impact/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/impact/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about impact

How do I install impact in Claude Code?

Add the marketplace with /plugin marketplace add DataWithBaraa/claude-code-data-engineering-skills, then install the plugin with /plugin install data-engineering@data-with-baraa.

What does impact do?

It traces an object's dependencies and consumers, identifies affected checks, and creates an HTML page with a graph and change sequence. It does not modify the project.

What sources does impact use to find dependencies?

It reads SQL, code, data contracts, query logs, checks, and tests. Dependencies must appear in code or logs; the skill does not infer them.

Source text

SKILL.md · MIT
---
name: impact
description: Use before you change a table, a column or a function, to see what it is built from, what depends on it, who reads it, which checks cover it, and the safe order of the change.
argument-hint: "[table, column or function]"
---

# Impact

The job: the answer to "if I change this, what breaks", before the change is made.

Input: the table, the column or the function to change.

## Steps

1. Name the thing to change: a table, a column, a function or a file.
2. Upstream: everything it is built from, layer by layer.
3. Downstream: every table, view, report, test and job that reads it, found in the SQL and the code, never from memory.
4. The consumers: who queried the downstream tables in the last period, from the query logs, by role and team.
5. The checks and the tests that cover it, and the ones that will break.
6. The blast radius in numbers: tables, data products, consumers, queries, checks.
7. The safe order of the change: what to change first, what to rebuild, what to compare, and whom to tell.
8. Give the result as one web page, with the graph and the lists.

## Output

One HTML file, like [references/impact.html](references/impact.html): the numbers on top, the graph with the thing to change lit, upstream and downstream, then the consumers, the checks and the safe order of the change. Read it for the layout before you write the page.

## Reads

- the SQL, the code, the data contracts, the query logs, the checks and the tests

## Writes

- the web page only

## Never

- Never makes the change.
- Never guesses a dependency: a dependency is one found in the code or in the logs.

© Data With Baraa · MIT · DataWithBaraa/claude-code-data-engineering-skills

Similar skills

All skills for Data and databases →

From the same set15

The whole set →
cost-review cost-review — a Claude Code skill that breaks down platform compute and storage costs for a chosen period. It builds a monthly review by job, pipeline, and table. CX Codex +1 ★ 106repo stars big-review The big-review Claude Code skill reviews a data platform using query logs and repository code. It produces an HTML report with findings and proposed changes ranked by effort and risk. CX Codex +1 ★ 106repo stars reconcile The reconcile Claude Code skill traces differences between figures in reports, queries, or tables. It narrows the gap to specific slices and explains the causes. CX Codex +1 ★ 106repo stars quality quality — a Claude Code skill that reports data checks and whether tables are safe to use. Give it a date or period to inspect failures, warnings, quarantined rows, and freshness. CX Codex +1 ★ 106repo stars incident The incident Claude Code skill traces a failed job run from its error toward a root cause. Give it a failure date or job and run; it produces an HTML page with a workaround, solution options and email drafts. CX Codex +1 ★ 106repo stars knowledge-refresh knowledge-refresh — a Claude Code skill that checks project knowledge against code and data after a release. It proposes fixes for stale or inaccurate files. CX Codex +1 ★ 106repo stars data-product Builds a data product page for people using a table. It runs when a table is released, changed, or served to consumers. CX Codex +1 ★ 106repo stars toolkit The toolkit Claude Code skill builds a project documentation site from the repository. It covers architecture, data lineage, code calls, quality checks, and runs. CX Codex +1 ★ 106repo stars

Project sponsors

Companies that keep this analytics open