# 使用 Homebrew, apk, dnf, pacman, chocolatey 安装 sqlite-analyzer

查看 sqlite-analyzer 的安装路径、可执行文件、元数据以及面向 AI 代理工作流的安全说明。

## 安装

```sh
sudo av install brew:sqlite-analyzer
```

其他安装命令:

### macOS

- Homebrew (100%):

```sh
brew install sqlite-analyzer
```

  证据: local Homebrew formula metadata

### Linux

- apk (92%):

```sh
sudo apk add sqlite-analyzer
```

  证据: 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
```

  证据: 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
```

  证据: 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
```

  证据: Chocolatey community package catalog: sqlite.analyzer from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','sphinx'

## 软件包事实

- **软件包键:** brew:sqlite-analyzer
- **软件包管理器:** Homebrew
- **版本:** 3.53.4
- **来源摘要:** Analyze how space is allocated inside an SQLite file
- **主页:** <https://www.sqlite.org/>
- **最后更新:** 2026-07-25T14:38:49Z
- **已生成:** 2026-08-03T19:37:03+00:00

## 可执行文件

- sqlite3_analyzer (别名)

## 安装行为

- Bottle: 不可用

## 版本和新鲜度

- 页面生成时间: 2026-08-03
- 管理器版本: 3.53.4
## 项目历史与用法

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.

### 项目历史

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.

### 采用历史

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.

### 使用方式

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.

### 为什么软件包爱好者会关心

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.

### 时间线

- 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.

### 来源

- <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.


## 安全说明

没有找到 sqlite-analyzer 的匹配本地密钥处理 manifest。Nucleus 软件包元数据仍在此发布，以便未来覆盖拥有稳定的软件包 URL。


## 其他软件包管理器记录

- 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)


## 来源

- 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