collate-data-diff
Command-line tool and Python library to efficiently diff rows across two different databases.
Decision gist · record as of 2026-08-14
Yes, if you need row-level database comparison and can tolerate the abandoned maintenance status. The package has low install friction, permissive licensing, and no known vulnerabilities. However, the abandoned status and archived upstream repository mean you should verify that the fork is actively maintained by the current publisher and plan for potential lack of future support or bug fixes.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later; dbt-core is a runtime dependency with its own substantial dependency tree.
- Low install friction with a pure-Python wheel and permissive dependencies.
- However, the package is marked abandoned with no active maintenance, despite a recent release date; the underlying repository is archived and the last commit was in 2024-05-17.
License · maintenance · safety
MIT (permissive) — MIT license is permissive and imposes no restrictions on commercial or private use, modification, or redistribution.
last release 2026-08-11 (3 days) · last repo commit 2024-05-17 · 2,988 stars · archived
0 known vulnerabilities (OSV.dev, 2026-08-14) · 1,092,188 downloads/mo, #4,377 on PyPI
Alternatives
Verify before relying
pip install collate-data-diff
from collate_data_diff import compare
# Compare two database tables
results = compare(database1_conn, database2_conn, table_name)- Whether the package is actively maintained despite the abandoned status and archived repository.
- Performance characteristics and scalability limits for large datasets.
- Specific SQL dialects and database systems supported beyond the general 'SQL databases' claim.
- Whether the fork is intended as a long-term replacement or temporary maintenance of the original.
What it is and what it does
Collate-data-diff is a command-line tool and Python library forked from the archived datafold/data-diff project for comparing rows across SQL databases. It lets you identify differences between two datasets, whether they're in the same database or across different systems, without loading all data into memory. The tool is designed for data validation, synchronization checks, and quality assurance workflows where you need to verify that data matches between sources.
The package depends on dbt-core, click, pydantic, and several other libraries for database connectivity, data parsing, and terminal output formatting. It supports Python 3.10 through 3.14 and is classified as pre-alpha. The maintenance status is marked abandoned, though releases continue; the original repository is archived, so this fork's long-term viability depends on the maintaining organization.
Use it for
- Validate that data migrated between databases matches the source after ETL operations.
- Compare production and staging database tables to detect unexpected divergence.
- Audit data consistency across federated or replicated database instances.
- Verify test data fixtures match expected state during integration testing.
- Identify row-level differences for reconciliation workflows in financial or compliance systems.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you need row-level database comparison and can tolerate the abandoned maintenance status.
The package has low install friction, permissive licensing, and no known vulnerabilities. However, the abandoned status and archived upstream repository mean you should verify that the fork is actively maintained by the current publisher and plan for potential lack of future support or bug fixes.
Install
collate-data-diff on PyPI
Before you install
Low install friction with a pure-Python wheel and permissive dependencies. However, the package is marked abandoned with no active maintenance, despite a recent release date; the underlying repository is archived and the last commit was in 2024-05-17.
Requires Python 3.10 or later; dbt-core is a runtime dependency with its own substantial dependency tree.
License in practice
MIT license is permissive and imposes no restrictions on commercial or private use, modification, or redistribution.
Quickstart
pip install collate-data-diff
from collate_data_diff import compare
# Compare two database tables
results = compare(database1_conn, database2_conn, table_name)Verify before relying
- Whether the package is actively maintained despite the abandoned status and archived repository.
- Performance characteristics and scalability limits for large datasets.
- Specific SQL dialects and database systems supported beyond the general 'SQL databases' claim.
- Whether the fork is intended as a long-term replacement or temporary maintenance of the original.
Package facts
| License | MIT permissive |
| Python support | Supports the current Python release <4.0,>=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 13 packagesattrsclickdbt-coredeepdiffdsnparsekeyringmashumaropydanticrichtabulatetomltyping-extensionsurllib3 |
| Maintenance | Abandoned 3 days since the last release |
| Last repo commit | repository archived |
| First released | |
| Downloads | 1,092,188 / month, #4,377 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 2 - Pre-AlphaEnvironment :: ConsoleIntended Audience :: DevelopersIntended Audience :: Information TechnologyIntended Audience :: System AdministratorsLicense :: OSI Approved :: MIT LicenseProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Topic :: Database :: Database Engines/ServersTyping :: Typed |
Evidence: collate_data_diff-0.11.15-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “compare datasets across databases”
- collate-data-diffCompares rows across two SQL databases or datasets to identify…
- openmlOpenML-Python provides a Python interface to download and upload…
- sqlalchemy-diffCompares database schemas across two SQLAlchemy-connected databases,…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database Engines/Servers packages
DuckDB is an in-process SQL database engine that executes analytical queries on local and remote data files (CSV, Parquet, JSON) without requiring a separate server or external dependencies.
pymssql provides a Python DB-API interface to Microsoft SQL Server, built on FreeTDS, enabling standard database operations like connecting, querying, and retrieving results.
Install it if you need to connect Python to Microsoft SQL Server and prefer a lightweight, DB-API-compliant interface over heavier ORMs.
mysqlclient provides a Python interface to MySQL and MariaDB databases, enabling direct database connections and query execution from Python code.
SQLModel combines SQLAlchemy and Pydantic to let you define SQL database tables and rows as Python classes with type annotations, eliminating code duplication between ORM models and data validators.
TinyDB is a lightweight, pure-Python document database that stores JSON-like dictionaries to local files, with no external dependencies or server required.
Native Python client library for connecting to and querying Vertica databases, implementing the DB-API v2.0 standard.
However, the aging maintenance status suggests it may not receive timely updates for new Vertica features or Python versions—verify compatibility with your specific…
See also csv-diff · recursive-diff · sqlalchemy-diff · fastdiff · daff · migra · datacompy · datasette · tdda · deepdiff