# Install sqlite-analyzer with Homebrew, apk, dnf, pacman, chocolatey

Analyze how space is allocated inside an SQLite file. Version 3.53.4 via Homebrew; verified 2026-07-25. Also installable with apk: sudo apk add sqlite-analyzer.

## 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/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-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','sphinx'

## Package facts

- **Package key:** brew:sqlite-analyzer
- **Package manager:** Homebrew
- **Version:** 3.53.4
- **Source summary:** Analyze how space is allocated inside an SQLite file
- **Homepage:** <https://www.sqlite.org/>
- **Last updated:** 2026-07-25T14:38:49Z
- **Generated:** 2026-08-03T19:37:03+00:00

## Executables

- sqlite3_analyzer (alias)

## Install behavior

- Bottle: not available

## Freshness

- Page generated: 2026-08-03
- Package-manager version: 3.53.4
## 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 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.


## Other Package-Manager Records

- apk - sqlite-analyzer - 3.53.4-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.4-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/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | An analysis program for sqlite3 database files | http://www.sqlite.org/
- pacman - sqlite-analyzer - 3.53.4-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','sphinx'


## Combined YAML source

View the package source record on GitHub. [combined/sqlite-analyzer.yml](https://github.com/mxcl/pkgdb/blob/main/combined/sqlite-analyzer.yml)


## Sources

- pkg.so package database
- Geiger risk classifier
- curated package history
- pkgdb category and tag curation
- external package-manager database matches
- cross-ecosystem install command graph