Skip to main content
skill CX Codex

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

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 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-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 reconcile -a claude-code

3Manually: put the files in place

~/.claude/skills/reconcile/SKILL.md

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

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.

reconcile wrg32786 This Claude Code skill compares seven days of project attention with stated Tier-1 shares. Run it to reconcile attention or check for priority drift. CX Codex +1 ★ 26repo stars dbt-transformation-patterns Seth Hobson dbt-transformation-patterns — a skill for Claude, Claude and Cursor that tells the agent how to layer dbt models, write data tests and set up incremental marts. CX Codex +1 11,000installs altimate-data-engineering-skills reason-machines altimate-data-engineering-skills is a Claude Code skill for data teams using dbt and Snowflake, guiding model building, build-error diagnosis, and warehouse query tuning. CX Codex +1 2,100installs using-dbt-state dbt-labs using-dbt-state — a Claude Code skill that teaches the agent how dbt State works: a server-backed reuse mechanism that skips or clones nodes instead of rebuilding them. Covers setup, config, debugging and billing. CX Codex +1 591installs upgrading-dbt dbt-labs This skill automates upgrading dbt projects from versions 1.3–1.7 to 1.12, applying all breaking changes and behavior flags. Use it to move an older project to the latest version without manually parsing each incompatibility. CX Codex +1 131installs snowflake-data-engineering-cursorrules-prompt-file PatrickJS The snowflake-data-engineering-cursorrules-prompt-file rule for Cursor defines Snowflake data engineering practices for VARIANT, Dynamic Tables, streaming ingestion, and warehouse cost control. CX Codex +1 ★ 41,178repo stars sqlsure sqlsure sqlsure — an MCP server for Claude Code and other agent environments that catches semantic SQL errors before a query runs. Double-counting from joins, summed averages, exposed PII — mistakes valid SQL lets through silently. CX Codex +1 ★ 99repo stars

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 impact 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. 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