# sqlite-utils を Homebrew, apt, Nix でインストール sqlite-utils のインストール経路、実行ファイル、メタデータ、AI エージェント向けセキュリティノートを確認します。 ## インストール ```sh sudo av install brew:sqlite-utils ``` 追加のインストールコマンド: ### macOS - Homebrew (100%): ```sh brew install sqlite-utils ``` 証拠: local Homebrew formula metadata ### Linux - Debian apt (92%): ```sh sudo apt install sqlite-utils ``` 証拠: 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 ``` 証拠: nixpkgs package indexes: sqlite-utils from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix ## パッケージ情報 - **パッケージキー:** brew:sqlite-utils - **パッケージマネージャ:** Homebrew - **パッケージマネージャページ:** - **バージョン:** 4.1.1 - **ソース概要:** CLI utility for manipulating SQLite databases - **ホームページ:** - **リポジトリ:** - **上流ドキュメント:** - **ライセンス:** Apache-2.0 - **ソースアーカイブ:** - **最終更新:** 2026-07-13T22:15:18Z - **生成日時:** 2026-08-04T22:13:35+00:00 ## 実行可能ファイル - sqlite-utils (cli) - sqlite-utils (エイリアス) ## 依存関係 - python@3.14 ## インストール挙動 - post-install フック: 未定義 - Bottle: 利用可能 対象 all ## バージョンと鮮度 - ページ生成日: 2026-08-04 - マネージャ版: 4.1.1 - マネージャ更新日: 2026-07-13 - ローカルデータ: OK - 上流リポジトリ: https://sqlite-utils.datasette.io/ - 情報: Release/tag comparison is only available for GitHub repositories. ## プロジェクトの歴史と使われ方 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. ### ソース - - - - ## セキュリティノート broad file, network, media, or database tool signal. - **Geiger リスク:** blue / 中 - broad file, network, media, or database tool signal ## ソースデータベース詳細 - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** sqlite-utils - **Version Scheme:** 0 - **Revision:** 0 - **Head Version:** HEAD - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** head, stable ## 他のパッケージマネージャ記録 - 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 ## 関連リンク - [Secret-risk packages](https://pkg.so/ja/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals. - [Terminal utility packages](https://pkg.so/ja/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://pkg.so/ja/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [Language runtime packages](https://pkg.so/ja/language-runtime-packages/) - Matched language runtime, compiler, or interpreter metadata. - [python@3.14](https://pkg.so/ja/brew/python-3-14/) - Runtime dependency declared by Homebrew. - [sqlite](https://pkg.so/ja/brew/sqlite/) - Shares pkgdb curated category or tags: cli, data, database, sqlite. - [gdbm](https://pkg.so/ja/brew/gdbm/) - Shares pkgdb curated category or tags: cli, data, database, library. - [libmaxminddb](https://pkg.so/ja/brew/libmaxminddb/) - Shares pkgdb curated category or tags: cli, data, database, library. - [lazysql](https://pkg.so/ja/brew/lazysql/) - Shares pkgdb curated category or tags: cli, data, database, sqlite. - [leveldb](https://pkg.so/ja/brew/leveldb/) - Shares pkgdb curated category or tags: cli, data, database, library. - [rainfrog](https://pkg.so/ja/brew/rainfrog/) - Shares pkgdb curated category or tags: cli, data, database, sqlite. - [rqlite](https://pkg.so/ja/brew/rqlite/) - Shares pkgdb curated category or tags: cli, data, database, sqlite. - [sqlite-analyzer](https://pkg.so/ja/brew/sqlite-analyzer/) - Shares pkgdb curated category or tags: cli, data, database, sqlite. - [mysql-to-sqlite3](https://pkg.so/ja/brew/mysql-to-sqlite3/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, python, python-3-14. - [ccm](https://pkg.so/ja/brew/ccm/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, databases, python. - [datasette](https://pkg.so/ja/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/mxcl/pkgdb/blob/main/combined/sqlite-utils.yml) ## ソース - pkg.so package database - Geiger risk classifier - package-page enrichment - curated package history - package version freshness - pkgdb category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph