Description:
Analyze how space is allocated inside an SQLite file
|
|
Type: Formula
|
Latest Version: 3.51.3@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.
|
| Detected |
Version |
Rev |
Change |
Commit |
| 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 |
|