brew / 排名 2934

使用 Homebrew, apt, Nix 安装 sqlite-utils

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

安装命令安全说明

安装

其他安装命令

macOS

Homebrew已验证 · 100%

brew install sqlite-utils

local Homebrew formula metadata

Linux

Debian apt已验证 · 92%

sudo apt install sqlite-utils

Debian stable package indexes · sqlite-utils · 来源: deb.debian.org

Nix已验证 · 92%

nix profile install nixpkgs#sqlite-utils

nixpkgs package indexes · sqlite-utils · 来源: raw.githubusercontent.com

概览

软件包摘要

CLI utility for manipulating SQLite databases

项目链接

命令和别名

sqlite-utils

历史

项目历史与用法

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.

项目历史

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.

采用历史

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.

使用方式

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.

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

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.

时间线

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.

来源

安全态势

风险级别：blue

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

风险分类器

blue 风险 · 中置信度 · tool

原因

broad file, network, media, or database tool signal

信号

text:database,sql

安装行为

未记录 Homebrew bottle 元数据。

建议审查

在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。

可执行文件

已安装的可执行文件

命令	类型	暴露范围	备注
`sqlite-utils`	可执行文件	已索引可执行文件	从本地可执行文件索引发现。

新鲜度

版本和新鲜度

这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。

页面生成时间2026-08-03

管理器版本4.1.1

管理器更新时间2026-07-13

本地数据未知

上游不可用

检测到的最新版本未检测到

OK没有生成新鲜度警告。

安装元数据

软件包元数据

软件包键	brew:sqlite-utils
版本	4.1.1
软件包管理器	Homebrew
主页	https://sqlite-utils.datasette.io/
仓库	https://github.com/simonw/sqlite-utils
最后更新	2026-07-13T22:15:18Z
Pulse	updated
Bottle	未记录
服务	未声明

源数据库匹配

其他软件包管理器记录

匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。

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 依赖
normalized package name match
匹配方式：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
匹配方式：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