sqlite-analyzer ☆
« Back to VersTracker
Description:
Analyze how space is allocated inside an SQLite file
Type: Formula  |  Latest Version: 3.53.4@0  |  Tracked Since: Dec 28, 2025
Links: Homepage  |  formulae.brew.sh
Category: Developer tools
Tags: sqlite database analyzer cli debugging
Install: brew install sqlite-analyzer
About:
The SQLite Analyzer is a command-line utility that inspects and reports on the internal structure of SQLite database files. It details page allocation, b-tree structure, and overall database performance characteristics. This tool is essential for diagnosing storage inefficiencies and optimizing complex database schemas.
Key Features:
  • Detailed page-by-page breakdown of database files
  • Identification of b-tree structures and fragmentation
  • Analysis of freelist pages and unused space
  • Cross-platform compatibility via Homebrew
Use Cases:
  • Optimizing database performance by identifying fragmentation
  • Debugging unexpectedly large database file sizes
  • Auditing internal structure during database migrations
Alternatives:
  • DB Browser for SQLite – Provides a GUI for inspection, whereas Analyzer is a CLI tool for automated analysis.
  • sqlite3 CLI – Offers general database interaction, while Analyzer focuses specifically on low-level file structure.
Version History
Detected Version Rev Change Commit
Jul 25, 2026 3:17pm 3.53.4 0 VERSION_BUMP faaf6835
Jun 26, 2026 11:34pm 3.53.3 0 VERSION_BUMP b0c1faac
Jun 3, 2026 11:09pm 3.53.2 0 VERSION_BUMP 16ef869b
May 7, 2026 3:59pm 3.53.1 0 VERSION_BUMP 4b1356db
Apr 10, 2026 11:55pm 3.53.0 0 VERSION_BUMP b202f4a3
Mar 16, 2026 10:20am 3.51.3 0 VERSION_BUMP 750e61b4
Mar 11, 2026 1:41pm 3.52.0 0 VERSION_BUMP 5f81367b
Jan 9, 2026 9:59pm 3.51.2 0 VERSION_BUMP ad3f4361
Sep 15, 2025 12:08pm 3.50.4 0 VERSION_BUMP f46795c0
Nov 10, 2024 1:46pm 3.47.0 1 VERSION_BUMP 7e3f46e9
Oct 23, 2024 10:21am 3.47.0 0 VERSION_BUMP ee1c60f9
Aug 15, 2024 9:07pm 3.46.1 0 VERSION_BUMP 72eaab3e
Apr 16, 2024 10:21pm 3.45.3 0 VERSION_BUMP bba47828
Jan 30, 2024 8:23pm 3.45.1 0 VERSION_BUMP 3c13b518
Jan 16, 2024 6:40pm 3.45.0 0 VERSION_BUMP 06e2dd4a
Jan 15, 2024 7:02pm 3.45.0 0 VERSION_BUMP 3d29d375
Nov 28, 2023 12:49am 3.44.2 0 VERSION_BUMP 00abe195
Nov 26, 2023 12:47am 3.44.1 0 VERSION_BUMP ed24a806
Nov 26, 2023 12:04am 3.44.0 0 VERSION_BUMP 4d9e4718
Nov 25, 2023 7:21pm 3.44.1 0 VERSION_BUMP 5c52f245
Nov 3, 2023 6:19pm 3.44.0 0 VERSION_BUMP 9777ded1
Sep 25, 2023 2:03am 3.43.1 0 VERSION_BUMP c28d0fbb
May 17, 2023 1:03am 3.42.0 0 VERSION_BUMP 31b3b904
Mar 12, 2023 5:35am 3.41.1 0 VERSION_BUMP c29c3a74
Mar 12, 2023 5:35am 3.41.1 0 VERSION_BUMP d92a8a49
Feb 25, 2023 7:16am 3.41.0 0 VERSION_BUMP 608f9030
Dec 30, 2022 11:10pm 3.40.1 0 VERSION_BUMP cfc4224f
Dec 30, 2022 11:10pm 3.40.1 0 VERSION_BUMP 4bed8129
Nov 24, 2022 8:58pm 3.40.0 0 VERSION_BUMP 971af1ef
Nov 23, 2022 10:39pm 3.40.0 0 VERSION_BUMP 63f28de9
Nov 23, 2022 10:39pm 3.40.0 0 VERSION_BUMP 25d2523a
« Back to VersTracker  |  Browse Packages  |  About