Back to browse
GitHub Repository

Local-first CLI for semantic data reconciliation with YAML rules and JSON reports.

1 starsPython

Reconlify – local-first reconciliation CLI for CSV/TSV and text logs

by testuteab·Mar 5, 2026·2 points·0 comments

AI Analysis

●●SolidSolve My ProblemNiche Gem

Key-based CSV/log reconciliation with normalization rules beats diff, Excel VLOOKUP, Beyond Compare manually.

Strengths
  • DuckDB-backed tabular engine handles 200k+ row datasets in seconds without external DB dependency
  • Declarative YAML rules + deterministic JSON output designed explicitly for CI/CD exit codes (0/1/2)
  • Hybrid comparison modes (line-by-line, unordered, key-based) with column-level normalization covers real-world reconciliation workflows
Weaknesses
  • Niche audience: mostly appeals to data engineers and finance ops—limited broad appeal
  • No Excel or database source connectors mentioned; author explicitly flagged as future work
Target Audience

QA engineers, data engineers, finance/ops teams, CI/CD pipeline maintainers validating data migrations

Similar To

Beyond Compare · Great Expectations · DBCompare

Post Description

I built Reconlify, a local-first reconciliation CLI for comparing CSV/TSV and text logs with a structured audit report (not just raw diff).

Typical uses: QA regression checks after refactors, data migration validation from exports, finance/ops reconciliation of transaction files.

Features: key-based row matching, normalization rules (trim/case/nulls), row filtering/exclusions, line-by-line + unordered text modes, JSON report output.

Data never leaves your machine (offline-friendly).

Repo: https://github.com/testuteab/reconlify-cli

I’d love feedback on missing features for real-world reconciliation workflows (esp. Excel/DB connection next).

Similar Projects