# Install sqlite-utils with Homebrew, apt, Nix CLI utility for manipulating SQLite databases. Version 4.0 via Homebrew; verified 2026-07-08. ## Install ```sh sudo av install brew:sqlite-utils ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install sqlite-utils ``` Evidence: local Homebrew formula metadata ### Linux - Debian apt (92%): ```sh sudo apt install sqlite-utils ``` Evidence: 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 ``` Evidence: nixpkgs package indexes: sqlite-utils from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix ## Package facts - **Package key:** brew:sqlite-utils - **Package manager:** Homebrew - **Package manager page:** - **Version:** 4.0 - **Source summary:** CLI utility for manipulating SQLite databases - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** Apache-2.0 - **Source archive:** - **Last updated:** 2026-07-08T16:49:51Z - **Generated:** 2026-07-08T18:08:21+00:00 ## Executables - sqlite-utils (cli) - sqlite-utils (alias) ## Dependencies - python@3.14 ## Install behavior - Post-install hook: not defined - Bottle: available on all ## Freshness - Page generated: 2026-07-08 - Package-manager version: 4.0 - Package-manager updated: 2026-07-08 - Local data: ok - Upstream repository: https://sqlite-utils.datasette.io/ - info: Release/tag comparison is only available for GitHub repositories. ## Project history and usage 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. ### Project history 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. ### Adoption history 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. ### How it is used 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. ### Why package nerds care 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. ### Timeline - 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 - - - - ## Security Notes broad file, network, media, or database tool signal. - **Geiger risk:** blue / medium - broad file, network, media, or database tool signal ## Source Database Details - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** sqlite-utils - **Version Scheme:** 0 - **Revision:** 0 - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** stable ## Other Package-Manager Records - 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 ## Related links - [Secret-risk packages](https://www.automicvault.com/pkg/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals. - [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. - [Language runtime packages](https://www.automicvault.com/pkg/language-runtime-packages/) - Matched language runtime, compiler, or interpreter metadata. - [python@3.14](https://www.automicvault.com/pkg/brew/python-3-14/) - Runtime dependency declared by Homebrew. - [gdbm](https://www.automicvault.com/pkg/brew/gdbm/) - Shares av.db curated category or tags: cli, data, database, library. - [kyoto-cabinet](https://www.automicvault.com/pkg/brew/kyoto-cabinet/) - Shares av.db curated category or tags: cli, data, database, library. - [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-analyzer](https://www.automicvault.com/pkg/brew/sqlite-analyzer/) - Shares av.db curated category or tags: cli, data, database, sqlite. - [sqlite-rsync](https://www.automicvault.com/pkg/brew/sqlite-rsync/) - Shares av.db curated category or tags: cli, data, database, sqlite. - [tinycdb](https://www.automicvault.com/pkg/brew/tinycdb/) - Shares av.db curated category or tags: cli, data, database, library. - [sqlite3-to-mysql](https://www.automicvault.com/pkg/brew/sqlite3-to-mysql/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, python, python-3-14. - [mysql-to-sqlite3](https://www.automicvault.com/pkg/brew/mysql-to-sqlite3/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, python, python-3-14. - [datasette](https://www.automicvault.com/pkg/brew/datasette/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, python, python-3-14. ## Combined YAML source View the package source record on GitHub. [combined/sqlite-utils.yml](https://github.com/automic-vault/db/blob/main/combined/sqlite-utils.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