DataWithBaraa/claude-code-data-engineering-skills / skills/impact
impact
UnverifiedUse 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.
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
- Name the thing to change: a table, a column, a function or a file.
- Upstream: everything it is built from, layer by layer.
- Downstream: every table, view, report, test and job that reads it, found in the SQL and the code, never from memory.
- The consumers: who queried the downstream tables in the last period, from the query logs, by role and team.
- The checks and the tests that cover it, and the ones that will break.
- The blast radius in numbers: tables, data products, consumers, queries, checks.
- The safe order of the change: what to change first, what to rebuild, what to compare, and whom to tell.
- Give the result as one web page, with the graph and the lists.
Output
One HTML file, like 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.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 195k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 192k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 192k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 192k | Updated | Claude CodeCodex | Verified | Install |