# 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 ```sh sudo av install brew:sqlite-analyzer ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install sqlite-analyzer ``` Evidence: local Homebrew formula metadata ### Linux - apk (92%): ```sh sudo apk add sqlite-analyzer ``` Evidence: Alpine Linux edge package indexes: sqlite-analyzer from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz - dnf (92%): ```sh sudo dnf install sqlite-analyzer ``` Evidence: Fedora Rawhide package metadata: sqlite-analyzer from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst - pacman (92%): ```sh sudo pacman -S sqlite-analyzer ``` Evidence: Arch Linux sync databases: sqlite-analyzer from https://geo.mirror.pkgbuild.com/core/os/x86_64/core.db.tar.gz ### Windows - Chocolatey (92%): ```sh choco install sqlite.analyzer ``` Evidence: Chocolatey community package catalog: sqlite.analyzer from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','sql2008r2.cmdline' ## Package facts - **Package key:** brew:sqlite-analyzer - **Package manager:** Homebrew - **Package manager page:** - **Version:** 3.53.3 - **Source summary:** Analyze how space is allocated inside an SQLite file - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** blessing - **Source archive:** - **Last updated:** 2026-06-27T14:08:56Z - **Generated:** 2026-07-08T18:08:21+00:00 ## Executables - sqlite3_analyzer (cli) - sqlite3_analyzer (alias) ## Dependencies - libtommath - tcl-tk ## Install behavior - Post-install hook: not defined - Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux ## Freshness - Page generated: 2026-07-08 - Package-manager version: 3.53.3 - Package-manager updated: 2026-06-27 - Local data: ok - Upstream repository: https://www.sqlite.org/ - info: Release/tag comparison is only available for GitHub repositories. ## 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 - - - source_facts.package-manager - package-manager availability supplied in input. ## Security Notes 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. ## Source Database Details - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** sqlite-analyzer - **Version Scheme:** 0 - **Revision:** 0 - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** stable ## Other Package-Manager Records - apk - sqlite-analyzer - 3.53.2-r0: normalized package name match | Alpine Linux edge package indexes: sqlite-analyzer from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | Analyze space utilization of SQLite database files | https://www.sqlite.org/ - dnf - sqlite-analyzer - 3.53.2-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-analyzer from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | An analysis program for sqlite3 database files | http://www.sqlite.org/ - pacman - sqlite-analyzer - 3.53.2-1: normalized package name match | Arch Linux sync databases: sqlite-analyzer from https://geo.mirror.pkgbuild.com/core/os/x86_64/core.db.tar.gz | An analysis program for sqlite3 database files | https://www.sqlite.org/ - Chocolatey - sqlite.analyzer: normalized package name match | Chocolatey community package catalog: sqlite.analyzer from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','sql2008r2.cmdline' ## Related links - [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [Networking and protocol packages](https://www.automicvault.com/pkg/networking-protocol-tools/) - Matched network, protocol, or remote-service metadata. - [Database and data packages](https://www.automicvault.com/pkg/database-data-tools/) - Matched database, SQL, migration, or data-store metadata. - [tcl-tk](https://www.automicvault.com/pkg/brew/tcl-tk/) - Runtime dependency declared by Homebrew. - [sqlite-rsync](https://www.automicvault.com/pkg/brew/sqlite-rsync/) - Shares the same upstream homepage. - [berkeley-db](https://www.automicvault.com/pkg/brew/berkeley-db/) - Shares av.db curated category or tags: cli, data, database, storage. - [lazysql](https://www.automicvault.com/pkg/brew/lazysql/) - Shares av.db curated category or tags: cli, data, database, sqlite. - [rqlite](https://www.automicvault.com/pkg/brew/rqlite/) - Shares av.db curated category or tags: cli, data, database, sqlite. - [sqlite](https://www.automicvault.com/pkg/brew/sqlite/) - Shares av.db curated category or tags: cli, data, database, sqlite. - [sqlite-utils](https://www.automicvault.com/pkg/brew/sqlite-utils/) - Shares av.db curated category or tags: cli, data, database, sqlite. - [whodb-cli](https://www.automicvault.com/pkg/brew/whodb-cli/) - Shares av.db curated category or tags: cli, data, database, sqlite. - [automysqlbackup](https://www.automicvault.com/pkg/brew/automysqlbackup/) - Shares av.db curated category or tags: cli, data, database. ## Combined YAML source View the package source record on GitHub. [combined/sqlite-analyzer.yml](https://github.com/automic-vault/db/blob/main/combined/sqlite-analyzer.yml) ## Sources - Nucleus package database - Geiger risk classifier - package-page enrichment - curated package history - package version freshness - av.db category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph