Automic VaultAutomic Vault

brew

Install sqlite-utils with Homebrew, apt, Nix

CLI utility for manipulating SQLite databases. Version 4.0 via Homebrew; verified 2026-07-08.

Install commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install sqlite-utils

local Homebrew formula metadata

overview

Package summary

CLI utility for manipulating SQLite databases

Commands and aliases

  • sqlite-utils

history

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.

security posture

Risk level: blue

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

Risk classifier

blue risk · medium confidence · tool

Why

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

Signals

  • text:database,sql

Install behavior

  • No Homebrew post-install hook is recorded in formula metadata.
  • Homebrew bottle metadata is available for 1 platform targets.
  • Installs with 1 runtime dependencies.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

executables

Installed executables

CommandKindExposureNote
sqlite-utilscliglobal executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-07-08
manager version4.0
manager updated2026-07-08
local dataok
upstreamnot checked
latest detectednot detected

https://sqlite-utils.datasette.io/

install metadata

Package metadata

Package keybrew:sqlite-utils
Version4.0
Package managerHomebrew
Package manager pagehttps://formulae.brew.sh/formula/sqlite-utils
Homepagehttps://sqlite-utils.datasette.io/
Repositoryhttps://github.com/simonw/sqlite-utils
Upstream docshttps://sqlite-utils.datasette.io/
LicenseApache-2.0
Source archivehttps://files.pythonhosted.org/packages/7d/8e/0e2fa87b197b3d0f8dd57856c07da77fa0c7130aaa894ee9d330c715f37c/sqlite_utils-4.0.tar.gz
Last updated2026-07-08T16:49:51Z
Pulseupdated
Dependenciespython@3.14
Bottleavailable (on all)
Homebrew post-installnot defined
Servicenone declared

registry facts

Source database details

Source DatabaseHomebrew formula API
Taphomebrew/core
Full Namesqlite-utils
Version Scheme0
Revision0
Bottle Stable Root URLhttps://ghcr.io/v2/homebrew/core
Deprecatedno
Disabledno
Keg Onlyno
URL Keys
  • stable

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

Debian apt95%

sqlite-utils 3.38-1

CLI tool and Python utility functions for manipulating SQLite

https://github.com/simonw/sqlite-utils

sudo apt install sqlite-utils
  • Section: utils
  • Architecture: all
  • 8 dependencies
  • normalized package name match
  • Matched by: Sqlite Utils
Debian stable package indexes · deb.debian.org · Debian stable package indexes: sqlite-utils from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz
Nix95%

sqlite-utils

nix profile install nixpkgs#sqlite-utils
  • normalized package name match
  • Matched by: Sqlite Utils
nixpkgs package indexes · raw.githubusercontent.com · nixpkgs package indexes: sqlite-utils from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix
Ubuntu apt95%

sqlite-utils 3.35.2-1

CLI tool and Python utility functions for manipulating SQLite

https://github.com/simonw/sqlite-utils

sudo apt install sqlite-utils
  • Section: universe/utils
  • Architecture: all
  • 8 dependencies
  • normalized package name match
  • Matched by: Sqlite Utils
Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: sqlite-utils from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

Related tools

Same workflow

  • gdbmShares av.db curated category or tags: cli, data, database, library.
  • kyoto-cabinetShares av.db curated category or tags: cli, data, database, library.
  • lazysqlShares av.db curated category or tags: cli, data, database, sqlite.
  • rqliteShares av.db curated category or tags: cli, data, database, sqlite.
  • sqliteShares av.db curated category or tags: cli, data, database, sqlite.
  • sqlite-analyzerShares av.db curated category or tags: cli, data, database, sqlite.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Used sources

  • Geiger risk classifier
  • Nucleus package database
  • av.db category and tag curation
  • cross-ecosystem install command graph
  • curated package history
  • external package-manager database matches
  • package relationship graph
  • package version freshness
  • package-page enrichment