dbhash
« Back to VersTracker
Description:
Computes the SHA1 hash of schema and content of a SQLite database
Type: Formula  |  Latest Version: 3.51.2@0  |  Tracked Since: Dec 17, 2025
Links: Homepage  |  formulae.brew.sh
Category: Databases
Tags: sqlite hashing database integrity cli verification
Install: brew install dbhash
About:
dbhash is a command-line utility included with SQLite that computes the SHA1 hash of both the schema and the content of a SQLite database file. This creates a unique fingerprint that accurately reflects the database's structure and data state. It is particularly useful for verifying database integrity, detecting changes, and comparing different versions of a database.
Key Features:
  • Computes SHA1 hash of database schema and content
  • Provides a single fingerprint for the entire database state
  • Simple command-line interface for easy scripting and automation
  • Helps in detecting accidental or unauthorized changes to a database
Use Cases:
  • Verifying database integrity after migrations or backups
  • Comparing two databases to ensure they contain identical data and schema
  • Generating a unique version identifier for a database snapshot
Alternatives:
  • sha1sum – Hashes the raw database file bytes, which can change even if logical content is identical due to internal SQLite formatting.
  • checksum – A generic utility for file integrity, but not aware of SQLite's internal structure.
License: blessing
Bottles available for: arm64_tahoe, arm64_sequoia, arm64_sonoma, tahoe, sequoia, sonoma, arm64_linux, x86_64_linux
Version History
Detected Version Rev Change Commit
Jan 9, 2026 9:59pm 3.51.2 0 VERSION_BUMP 0d1749fd
Sep 15, 2025 6:38am 3.50.4 0 VERSION_BUMP 7bacdd4c
Oct 23, 2024 10:21am 3.47.0 0 VERSION_BUMP b7938799