# sqlparse を Homebrew, apt でインストール sqlparse のインストール経路、実行ファイル、メタデータ、AI エージェント向けセキュリティノートを確認します。 ## インストール ```sh sudo av install brew:sqlparse ``` 追加のインストールコマンド: ### macOS - Homebrew (100%): ```sh brew install sqlparse ``` 証拠: local Homebrew formula metadata ### Linux - Debian apt (92%): ```sh sudo apt install python-sqlparse-doc ``` 証拠: Debian stable package indexes: python-sqlparse-doc from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz ## パッケージ情報 - **パッケージキー:** brew:sqlparse - **パッケージマネージャ:** Homebrew - **パッケージマネージャページ:** - **バージョン:** 0.5.5 - **ソース概要:** Non-validating SQL parser - **ホームページ:** - **リポジトリ:** - **ライセンス:** BSD-3-Clause - **ソースアーカイブ:** - **最終更新:** 2026-06-14T15:13:50+02:00 - **生成日時:** 2026-08-04T22:13:35+00:00 ## 実行可能ファイル - sqlformat (cli) - sqlformat (エイリアス) ## 依存関係 - python@3.14 ## インストール挙動 - post-install フック: 未定義 - Bottle: 利用可能 対象 all ## バージョンと鮮度 - ページ生成日: 2026-08-04 - マネージャ版: 0.5.5 - マネージャ更新日: 2026-06-14 - ローカルデータ: OK - 上流リポジトリ: https://github.com/andialbrecht/sqlparse - 情報: No cached GitHub release or tag data was available. ## プロジェクトの歴史と使われ方 sqlparse is a Python package and companion sqlformat command for non-validating SQL parsing, statement splitting, and SQL formatting. ### プロジェクトの歴史 The official documentation describes sqlparse as a non-validating SQL parser for Python with support for parsing, splitting, and formatting SQL statements. The official changelog records release 0.1.0 on April 8, 2009, making it one of the older small SQL tooling packages in the Python ecosystem. The changelog shows steady maintenance across Python packaging eras: Python 3 compatibility work in release 0.1.6 on January 1, 2013, Python 2.7 and Python 3.3+ support boundaries in release 0.2.0 on July 20, 2016, and modern security and runtime updates such as 0.4.4 in 2023 and 0.5.0 in 2024. ### 採用の歴史 sqlparse has remained useful because many tools need SQL tokenization and pretty-printing without connecting to a database or validating against a specific dialect. The supplied package-manager facts show it packaged by Homebrew and Debian/Ubuntu documentation packages, in addition to its Python packaging identity. ### 使われ方 Developers use sqlparse as a library for parse, split, and format operations, and use the installed sqlformat executable for command-line formatting. Its non-validating design is important: it handles SQL text as tooling input rather than acting as a database-specific compiler. ### パッケージ好きにとっての重要性 Package nerds care about sqlparse because it is a small, durable dependency behind SQL-aware developer tooling. It also has the classic shape of a package-manager-friendly utility: a library, a CLI, a permissive license, documentation, and no need for a running database. ### タイムライン - 2009: Release 0.1.0 published. - 2013: Release 0.1.6 added Python 3 compatibility work. - 2016: Release 0.2.0 set Python 2.7 and Python 3.3+ support boundaries. - 2023: Release 0.4.4 fixed a parser regular-expression security issue. - 2024: Release 0.5.0 added Python 3.12 support and fixed a recursion denial-of-service issue. ### Related projects - The official docs and repository tie sqlparse to Python developer tooling and the sqlformat command rather than to a single database server. ### ソース - - - - source_facts.package-manager ## セキュリティノート 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:** sqlparse - **Version Scheme:** 0 - **Revision:** 0 - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** stable ## 他のパッケージマネージャ記録 - Debian apt - python-sqlparse-doc - 0.5.3-1: normalized package name match | Debian stable package indexes: python-sqlparse-doc from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | documentation for non-validating SQL parser in Python | https://github.com/andialbrecht/sqlparse - Debian apt - python3-sqlparse - 0.5.3-1: normalized package name match | Debian stable package indexes: python3-sqlparse from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | non-validating SQL parser for Python 3 | https://github.com/andialbrecht/sqlparse - Debian apt - sqlformat - 0.5.3-1: normalized package name match | Debian stable package indexes: sqlformat from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | SQL formatting utility | https://github.com/andialbrecht/sqlparse - Ubuntu apt - python-sqlparse-doc - 0.4.4-1: normalized package name match | Ubuntu 24.04 LTS package indexes: python-sqlparse-doc from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | documentation for non-validating SQL parser in Python | https://github.com/andialbrecht/sqlparse - Ubuntu apt - python3-sqlparse - 0.4.4-1: normalized package name match | Ubuntu 24.04 LTS package indexes: python3-sqlparse from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | non-validating SQL parser for Python 3 | https://github.com/andialbrecht/sqlparse - Ubuntu apt - sqlformat - 0.4.4-1: normalized package name match | Ubuntu 24.04 LTS package indexes: sqlformat from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | SQL formatting utility | https://github.com/andialbrecht/sqlparse ## 関連リンク - [Source-control packages](https://pkg.so/ja/source-control-tools/) - Belongs to a source-control command family. - [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. - [python@3.14](https://pkg.so/ja/brew/python-3-14/) - Runtime dependency declared by Homebrew. - [md4c](https://pkg.so/ja/brew/md4c/) - Shares pkgdb curated category or tags: cli, developer-tools, library, parser. - [pybind11](https://pkg.so/ja/brew/pybind11/) - Shares pkgdb curated category or tags: cli, developer-tools, library, python. - [uriparser](https://pkg.so/ja/brew/uriparser/) - Shares pkgdb curated category or tags: cli, developer-tools, library, parser. - [urdfdom](https://pkg.so/ja/brew/urdfdom/) - Shares pkgdb curated category or tags: cli, developer-tools, library, parser. - [pygments](https://pkg.so/ja/brew/pygments/) - Shares pkgdb curated category or tags: cli, developer-tools, library, python. - [fonttools](https://pkg.so/ja/brew/fonttools/) - Shares pkgdb curated category or tags: cli, developer-tools, library, python. - [pymupdf](https://pkg.so/ja/brew/pymupdf/) - Shares pkgdb curated category or tags: cli, developer-tools, library, python. - [python-markdown](https://pkg.so/ja/brew/python-markdown/) - Shares pkgdb curated category or tags: cli, developer-tools, parser, python. - [python-tabulate](https://pkg.so/ja/brew/python-tabulate/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, developer, developer-tools, formatting, python. - [darker](https://pkg.so/ja/brew/darker/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, developer, developer-tools, formatting, python. - [djhtml](https://pkg.so/ja/brew/djhtml/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, developer, developer-tools, formatting, python. ## Combined YAML source View the package source record on GitHub. [combined/sqlparse.yml](https://github.com/mxcl/pkgdb/blob/main/combined/sqlparse.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