# Installer sqlite-utils avec Homebrew, apt, Nix

Consultez les chemins d'installation, exécutables, métadonnées et notes de sécurité de sqlite-utils pour les workflows d'agents IA.

## installation

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

Commandes d'installation supplémentaires:

### macOS

- Homebrew (100%):

```sh
brew install sqlite-utils
```

  Preuve: local Homebrew formula metadata

### Linux

- Debian apt (92%):

```sh
sudo apt install sqlite-utils
```

  Preuve: Debian stable package indexes: sqlite-utils from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz

- Nix (92%):

```sh
nix profile install nixpkgs#sqlite-utils
```

  Preuve: nixpkgs package indexes: sqlite-utils from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix

## Faits du paquet

- **Clé du paquet:** brew:sqlite-utils
- **Gestionnaire de paquets:** Homebrew
- **Version:** 4.1.1
- **Résumé source:** CLI utility for manipulating SQLite databases
- **Page d'accueil:** <https://sqlite-utils.datasette.io/>
- **Dépôt:** <https://github.com/simonw/sqlite-utils>
- **Dernière mise à jour:** 2026-07-13T22:15:18Z
- **Généré:** 2026-08-03T19:37:03+00:00

## exécutables

- sqlite-utils (alias)

## Comportement d'installation

- Bouteille: non disponible

## Version et fraîcheur

- page générée: 2026-08-03
- version du gestionnaire: 4.1.1
## Historique du projet et usages

sqlite-utils is a Python library and CLI for creating, loading, querying, and transforming SQLite databases. It is closely associated with the Datasette ecosystem and with command-line data work.

### Historique du projet

The official documentation describes sqlite-utils as both a CLI tool and Python library for manipulating SQLite databases, especially for creating databases from existing data. Its changelog records an initial PyPI release in July 2018.

The project developed into a broad utility surface around SQLite: import JSON, CSV, and TSV; create and transform tables; manage indexes and foreign keys; enable full-text search; analyze tables; and install plugins.

### Historique d'adoption

The official installation docs document Homebrew, pip, and pipx installation paths. The input also lists Debian, Ubuntu, and Nix package names, showing that the tool moved beyond Python-only packaging into general system package channels.

### Modes d'utilisation

CLI users run `sqlite-utils` for one-off data loading, SQL querying, schema inspection, database transformations, and automation around SQLite files. Python users import `sqlite_utils` when they want scriptable helpers without writing raw sqlite3 boilerplate for common database-building tasks.

### Pourquoi les passionnés de paquets s'y intéressent

Package nerds care because sqlite-utils turns SQLite into a shell-friendly data toolkit. It packages the SQLite file format, Python's bundled sqlite3 module, and Datasette-style publishing workflows into a CLI that can be installed with Homebrew, pipx, or distro packages.

### Chronologie

- 2018: 0.2 changelog entry records the initial PyPI release.
- 2020: 2.0 release line appears in official release metadata and changelog history.
- 2020: 3.0 line appears in the changelog history.
- 2025: 3.39 appears in official documentation as a current stable release entry.

### Related projects

- The official docs describe sqlite-utils as a useful complement to Datasette.
- The installation docs discuss pysqlite3 and sqlean.py as optional replacements for Python's bundled sqlite3 module when newer SQLite features or extension loading are needed.

### Sources

- <https://github.com/simonw/sqlite-utils - official source repository.>
- <https://sqlite-utils.datasette.io/ - official project documentation and overview.>
- <https://sqlite-utils.datasette.io/en/stable/changelog.html - official changelog.>
- <https://sqlite-utils.datasette.io/en/stable/installation.html - official installation documentation.>


## Notes de sécurité

broad file, network, media, or database tool signal.

- **Risque Geiger:** blue / moyen
- broad file, network, media, or database tool signal

## Autres enregistrements de gestionnaires de paquets

- Debian apt - sqlite-utils - 3.38-1: normalized package name match | Debian stable package indexes: sqlite-utils from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | CLI tool and Python utility functions for manipulating SQLite | https://github.com/simonw/sqlite-utils
- Nix - sqlite-utils: normalized package name match | nixpkgs package indexes: sqlite-utils from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix
- Ubuntu apt - sqlite-utils - 3.35.2-1: normalized package name match | Ubuntu 24.04 LTS package indexes: sqlite-utils from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | CLI tool and Python utility functions for manipulating SQLite | https://github.com/simonw/sqlite-utils


## Combined YAML source

View the package source record on GitHub. [combined/sqlite-utils.yml](https://github.com/mxcl/pkgdb/blob/main/combined/sqlite-utils.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