macOS
Homebrewverified ยท 100%
brew install sqlite-analyzerprovider-native install command
brew / rank 2979
Install sqlite-analyzer with Homebrew
Analyze how space is allocated inside an SQLite file. Version 3.53.4 via Homebrew; verified 2026-07-25.
install
Additional install commands
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 bottle metadata was recorded.
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 | executable | indexed executable | Discovered from the local executable index. |
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-08-03
manager version3.53.4
manager updated2026-07-25
local dataunknown
upstreamnot available
latest detectednot detected
- okNo freshness warnings were generated.
install metadata
Package metadata
| Package key | brew:sqlite-analyzer |
|---|---|
| Version | 3.53.4 |
| Package manager | Homebrew |
| Homepage | https://www.sqlite.org/ |
| Last updated | 2026-07-25T14:38:49Z |
| Pulse | updated |
| Bottle | not recorded |
| Service | none declared |
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
- curated package history
- pkgdb category and tag curation