Show HN: Lotad, an Open-Source DuckDB Differ for Data Exploration

2 points

a year ago

Lotad makes comparing DuckDB files effortless. Get started with a simple setup command that generates a config YAML file tailored to your needs.

The tool creates a comprehensive DuckDB output file containing: High-level change summaries per table Detailed table deltas Complete schema difference analysis

For tables with drift, Lotad generates dedicated comparison tables that preserve the original schema while adding an observed_in column to track data origins.

Lotad is under active development, with support for additional database types on the roadmap. It's actively being worked on and I do have expanding the number of supported Databases on the roadmap.