macOS
Homebrewverified · 100%
brew install sqlite-analyzerlocal Homebrew formula metadata
brew
Install sqlite-analyzer with Homebrew, apk, chocolatey, dnf, pacman
Analyze how space is allocated inside an SQLite file. Version 3.53.3 via Homebrew; verified 2026-06-27.
install
Additional install commands
Linux
Alpine Linux apkverified · 92%
sudo apk add sqlite-analyzerAlpine Linux edge package indexes · sqlite-analyzer · source: dl-cdn.alpinelinux.org
Fedora dnfverified · 92%
sudo dnf install sqlite-analyzerFedora Rawhide package metadata · sqlite-analyzer · source: dl.fedoraproject.org
Arch Linux pacmanverified · 92%
sudo pacman -S sqlite-analyzerArch Linux sync databases · sqlite-analyzer · source: geo.mirror.pkgbuild.com
Windows
Chocolateyverified · 92%
choco install sqlite.analyzerChocolatey community package catalog · sqlite.analyzer · source: community.chocolatey.org
overview
Package summary
Analyze how space is allocated inside an SQLite file
Project links
Commands and aliases
- sqlite3_analyzer
history
Project history and usage
sqlite3_analyzer is a command-line utility from the SQLite project for inspecting how space is used inside an SQLite database file. It is packaged separately in several systems because database maintainers often want the analysis tool without treating it as an everyday shell command.
Project history
The SQLite documentation presents sqlite3_analyzer as a utility program that measures and reports how efficiently tables and indexes use space in a database file. It belongs to the broader SQLite toolchain rather than being a separate upstream project.
Adoption history
Package-manager records in the input show sqlite-analyzer packaged by Homebrew and several Linux distributions. That split packaging reflects a common packaging pattern around SQLite: the core library and shell are ubiquitous, while specialist diagnostics are available as add-on utilities.
How it is used
Users run `sqlite3_analyzer database.sqlite` to generate a human-readable text report about database-file space utilization. The output is useful when tuning page usage, index bloat, or the storage impact of table design.
Why package nerds care
Package nerds care because sqlite3_analyzer exposes SQLite internals in a portable CLI form. It is the kind of diagnostic binary that database-heavy developers install from a package manager when they need to understand why a single-file database grew or how its indexes consume space.
Timeline
- Current: SQLite documents sqlite3_analyzer as the official command-line utility for database space-utilization reports.
- Current: Homebrew packages the utility as `sqlite-analyzer`.
Related projects
- SQLite provides the database engine, source tree, command-line shell, and related utilities such as sqlite3_analyzer.
Sources
- https://www.sqlite.org/sqlanalyze.html - official sqlite3_analyzer documentation.
- https://www.sqlite.org/src - official SQLite source repository.
- source_facts.package-manager - package-manager availability supplied in input.
security posture
No protected-tool coverage found yet
No matching local secret-handling manifest was found for sqlite-analyzer. Nucleus package metadata is still published here so future coverage has a stable package URL.
Install behavior
- No Homebrew post-install hook is recorded in formula metadata.
- Homebrew bottle metadata is available for 6 platform targets.
- Installs with 2 runtime dependencies.
Recommended review
Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.
executables
Installed executables
| Command | Kind | Exposure | Note |
|---|---|---|---|
sqlite3_analyzer | cli | global executable |
freshness
Version and freshness
These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.
page generated2026-07-08
manager version3.53.3
manager updated2026-06-27
local dataok
upstreamnot checked
latest detectednot detected
- infoRelease/tag comparison is only available for GitHub repositories.https://www.sqlite.org/none confidence
install metadata
Package metadata
| Package key | brew:sqlite-analyzer |
|---|---|
| Version | 3.53.3 |
| Package manager | Homebrew |
| Package manager page | https://formulae.brew.sh/formula/sqlite-analyzer |
| Homepage | https://www.sqlite.org/ |
| Repository | https://www.sqlite.org/src |
| Upstream docs | https://www.sqlite.org/sqlanalyze.html |
| License | blessing |
| Source archive | https://www.sqlite.org/2026/sqlite-src-3530300.zip |
| Last updated | 2026-06-27T14:08:56Z |
| Pulse | updated |
| Dependencies | libtommath, tcl-tk |
| Bottle | available (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux) |
| Homebrew post-install | not defined |
| Service | none declared |
registry facts
Source database details
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | sqlite-analyzer |
| Version Scheme | 0 |
| Revision | 0 |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | no |
| URL Keys |
|
source database matches
Other package-manager records
Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.
apk95%
sqlite-analyzer 3.53.2-r0
Analyze space utilization of SQLite database files
sudo apk add sqlite-analyzer- License: blessing
- Architecture: x86_64
- Source Package: sqlite-tools
- 1 dependencies
- 1 provides
- normalized package name match
- Matched by: Sqlite Analyzer
dnf95%
sqlite-analyzer 3.53.2-1.fc45
An analysis program for sqlite3 database files
sudo dnf install sqlite-analyzer- License: blessing
- Category: Unspecified
- Architecture: x86_64
- Source Package: sqlite
- 7 dependencies
- 1 provides
- normalized package name match
- Matched by: Sqlite Analyzer
pacman95%
sqlite-analyzer 3.53.2-1
An analysis program for sqlite3 database files
sudo pacman -S sqlite-analyzer- License: LicenseRef-Sqlite
- Architecture: x86_64
- 3 dependencies
- normalized package name match
- Matched by: Sqlite Analyzer
Chocolatey95%
sqlite.analyzer
choco install sqlite.analyzer- normalized package name match
- Matched by: Sqlite Analyzer
source trail
Generated from repository data
This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.
Combined YAML source
View the package source record on GitHub.
Used sources
- Geiger risk classifier
- Nucleus package database
- av.db category and tag curation
- cross-ecosystem install command graph
- curated package history
- external package-manager database matches
- package relationship graph
- package version freshness
- package-page enrichment