sqldiff
« Back to VersTracker
Description:
Displays the differences between SQLite databases
Type: Formula  |  Latest Version: 3.51.3@0  |  Tracked Since: Dec 28, 2025
Links: Homepage  |  formulae.brew.sh
Category: Databases
Tags: sqlite diff database cli synchronization
Install: brew install sqldiff
About:
Sqldiff is a command-line utility that compares two SQLite database files and outputs the differences in SQL. It can generate SQL INSERT, UPDATE, or DELETE statements to transform one database into another. This is highly useful for synchronizing databases or debugging data discrepancies.
Key Features:
  • Compares schema and data between two SQLite databases
  • Outputs standard SQL statements for easy application
  • Can output data differences in CSV format
  • Part of the official SQLite toolset
Use Cases:
  • Synchronizing a development database with a production database
  • Debugging why two databases contain different data
  • Generating incremental update scripts for an application
Alternatives:
  • sqldiff (Python) – A different Python-based tool for diffing SQL files, not specifically optimized for SQLite internals.
Version History
Detected Version Rev Change Commit
Mar 16, 2026 10:17am 3.51.3 0 VERSION_BUMP 8375e258
Mar 11, 2026 1:41pm 3.52.0 0 VERSION_BUMP fd4270c9
Jan 9, 2026 9:59pm 3.51.2 0 VERSION_BUMP 9255ddb1
Sep 15, 2025 12:04pm 3.50.4 0 VERSION_BUMP 2aa7ee05
Oct 23, 2024 10:21am 3.47.0 0 VERSION_BUMP 77488925
Aug 15, 2024 9:07pm 3.46.1 0 VERSION_BUMP a6a9a76b
Apr 16, 2024 10:21pm 3.45.3 0 VERSION_BUMP e6d04dd9
Jan 30, 2024 8:23pm 3.45.1 0 VERSION_BUMP ba5c3f4f
Jan 15, 2024 7:02pm 3.45.0 0 VERSION_BUMP 11edf079
Nov 28, 2023 12:49am 3.44.2 0 VERSION_BUMP b069503a
Nov 26, 2023 12:47am 3.44.1 0 VERSION_BUMP 9587dc46
Nov 26, 2023 12:04am 3.44.0 0 VERSION_BUMP 4a6e8766
Nov 25, 2023 7:21pm 3.44.1 0 VERSION_BUMP 4dee147f
Nov 3, 2023 6:19pm 3.44.0 0 VERSION_BUMP c1a24924
Sep 25, 2023 2:03am 3.43.1 0 VERSION_BUMP 2b185c70
May 17, 2023 1:03am 3.42.0 0 VERSION_BUMP e892635a