# datafold/data-diff

Compare tables within or across databases

Repository: https://github.com/datafold/data-diff
Canonical: https://ross.abutalabs.com/products/data-diff
Homepage: https://docs.datafold.com
Language: Python
License: MIT
License Family: permissive
Topics: database, mysql, postgresql, snowflake, rdbms, trino, data-engineering, data-quality, data-science, data-quality-monitoring, databricks-sql, dataengineering, dataquality, oracle-database, postgres, sql, dbt, python, data, data-diffing
Archived: true
Last push: 2024-05-17T13:45:03+00:00

## Health v2 (maintenance only)
Score: 10/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 8, longevity 100
- inputs: {"age_days": 1640, "days_push": 838, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: archived
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2991, forks 312 (observed 2026-08-28T04:07:35.623670+00:00)

## What it is
A command-line tool and Python library that efficiently diffs rows between tables within or across SQL databases like PostgreSQL, MySQL, Snowflake, Oracle, and Trino. The open-source project was sunset by Datafold in May 2024 and is no longer actively maintained.

## Use cases
- compare rows between two tables in different databases
- validate data parity after a database migration
- reconcile production and staging tables
- diff a Snowflake table against a Postgres table
- check data quality by finding changed rows between environments
- verify dbt model outputs row by row

## When to choose
- you need fast row-level diffing across heterogeneous SQL databases
- you want a lightweight Python library or CLI for data reconciliation
- you're validating a data platform migration and don't need vendor support

## When to avoid
- you need actively maintained software with bug fixes and new database support
- you want CI/CD data diffing with a UI - consider Datafold's commercial product instead
- you need long-term production support for a critical pipeline

## Facets
- artifact type: cli-tool
- maturity: abandoned
- function: database, cli, developer-tools, data-science
- domain: databases, data-science
- platform: python, cli, cross-platform
- tags: data-diffing, data-quality, dbt, sql, data-reconciliation, sunset, data-engineering

## Member repositories
- datafold/data-diff (main) score 10

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:35.623670+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:47:26.815887+00:00, confidence not recorded.
  - readme: https://github.com/datafold/data-diff (fetched 2026-08-28T04:07:35.623670+00:00, sha e2956a1e14c3)
  - homepage: https://docs.datafold.com (fetched 2026-08-29T09:46:27.212286+00:00, sha a809146dbcf8)
  - site_page: https://docs.datafold.com/integrations/oauth (fetched 2026-08-29T09:46:27.224408+00:00, sha f532a4293260)
  - site_page: https://docs.datafold.com/faq/overview (fetched 2026-08-29T09:46:27.226495+00:00, sha d35b984676ab)
  - site_page: https://docs.datafold.com/integrations (fetched 2026-08-29T09:46:27.244819+00:00, sha 203ad2c1533a)
  - site_page: https://docs.datafold.com/integrations/code-repositories (fetched 2026-08-29T09:46:27.246671+00:00, sha 4800ab647976)
  - site_page: https://docs.datafold.com/deployment-testing/getting-started/universal/no-code (fetched 2026-08-29T09:46:27.248304+00:00, sha 52424f767999)
  - site_page: https://docs.datafold.com/deployment-testing/getting-started/universal/api (fetched 2026-08-29T09:46:27.250260+00:00, sha cdf362f83532)
  - site_page: https://docs.datafold.com/integrations/orchestrators/dbt-core (fetched 2026-08-29T09:46:27.252729+00:00, sha 77ada88448e2)
  - registry_pypi: https://pypi.org/pypi/data-diff/json (fetched 2026-08-29T09:46:27.255108+00:00, sha 322de3542e9d)
- Data as of 2026-08-30T08:39:29.467469+00:00.