reconcile · datawithbaraa — Claude Code skill: what it does, how to install
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.
MIT ★ 106 updated 2026-11-06
/plugin marketplace add DataWithBaraa/claude-code-data-engineering-skills
/plugin install data-engineering@data-with-baraaWhat reconcile does
The skill compares two figures and tracks down where they diverge. It first aligns the grain, time period, filters, currency, units, and time zone. Then it breaks totals into dimensions and checks rows in the slices where the gap remains.
The report shows rows found on just one side and shared rows with different values. It attributes causes such as filters, joins, late data, or type conversions, then records the remaining difference after each cause. It also identifies the correct side using evidence from the source. The output is an HTML page; the skill leaves both sets of numbers unchanged. It reads the two sides, data contracts, pipeline SQL, and query logs.
What it helps with
- locate the slice where two totals diverge
- find rows present on only one side
- trace a mismatch to a filter or join
- show the remaining gap after each cause
Example prompts for the agent
- Compare the report total with its source query and trace the difference.
- Check these two tables for the same period, explain the mismatched rows, and create an HTML report.
How to install reconcile
1Plugin marketplace
/plugin marketplace add DataWithBaraa/claude-code-data-engineering-skills/plugin install data-engineering@data-with-baraaThis installs the whole data-engineering plugin with all its skills
2Skills CLI (Vercel)
npx skills add DataWithBaraa/claude-code-data-engineering-skills --skill reconcile -a claude-code3Manually: put the files in place
~/.claude/skills/reconcile/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/reconcile/
1Skills CLI (Vercel)
npx skills add DataWithBaraa/claude-code-data-engineering-skills --skill reconcile -a codex2Manually: put the files in place
.agents/skills/reconcile/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add DataWithBaraa/claude-code-data-engineering-skills --skill reconcile -a cursor2Manually: put the files in place
.cursor/skills/reconcile/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install DataWithBaraa/claude-code-data-engineering-skills skills/reconcile2Manually: put the files in place
.github/skills/reconcile/SKILL.md1Skills CLI (Vercel)
npx skills add DataWithBaraa/claude-code-data-engineering-skills --skill reconcile -a gemini-cli2Platform CLI
gemini skills install https://github.com/DataWithBaraa/claude-code-data-engineering-skills --path skills/reconcileManually: put the files in place
.devin/skills/reconcile/SKILL.mdThe legacy .windsurf/skills/ path still works
Claude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about reconcile
How do I install reconcile in Claude Code?
Add the marketplace with /plugin marketplace add DataWithBaraa/claude-code-data-engineering-skills, then install the skill with /plugin install data-engineering@data-with-baraa.
What does reconcile do?
It investigates why two figures differ by comparing totals, individual slices, and rows. It writes the findings to an HTML page without changing the source numbers.
What data does reconcile inspect?
It reads both sides of the comparison, data contracts, pipeline SQL, and query logs. The comparison aligns grain, period, filters, currency, units, and time zone.
Source text
SKILL.md · MIT
--- name: reconcile description: Use when two numbers that should agree do not, a report against its source, a rollup against its detail, two systems for the same table, to find where they diverge and why. argument-hint: "[the two numbers or queries]" --- # Reconcile The job: two numbers that should match, the places where they stop matching, and the reasons. It reads, it changes no number. Input: the two sides, the report, query or table of each, and the number each one gives. ## Steps 1. Name the two sides: the query, the table and the filter of each, and the number each one gives. 2. Make both sides comparable: the same grain, the same period, the same filters, the same currency and unit, the same time zone. 3. Compare the totals, then split by the dimensions until a difference sits in one slice: a day, a source, a status, a key. 4. In that slice, compare row by row: the rows only on one side, and the rows on both sides with different values. 5. Name the cause: a filter, a join that drops or doubles rows, a late delivery, a type conversion, a rounding, a time zone. 6. After each cause, show what is left of the difference, and go on until it is zero or inside the agreed tolerance. 7. Say which side is right, with the proof from the source. 8. Give the result as one web page. ## Output One HTML file: the two numbers on top, the difference, the drill-down from the total to the slices, the rows behind each cause, and what is left after each cause. ## Reads - both sides, the data contracts, the pipeline SQL, the query logs ## Writes - the web page only ## Never - Never changes a number on either side. - Never calls it a rounding difference without showing the rows.
© Data With Baraa · MIT · DataWithBaraa/claude-code-data-engineering-skills
Similar skills
All skills for Data and databases →reconcile by other authors comes first.