# Install sqlparse with Homebrew, apt Non-validating SQL parser. Version 0.5.5 via Homebrew; verified 2026-06-14. ## Install ```sh sudo av install brew:sqlparse ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install sqlparse ``` Evidence: local Homebrew formula metadata ### Linux - Debian apt (92%): ```sh sudo apt install python-sqlparse-doc ``` Evidence: Debian stable package indexes: python-sqlparse-doc from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz ## Package facts - **Package key:** brew:sqlparse - **Package manager:** Homebrew - **Package manager page:** - **Version:** 0.5.5 - **Source summary:** Non-validating SQL parser - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** BSD-3-Clause - **Source archive:** - **Last updated:** 2026-06-14T15:13:50+02:00 - **Generated:** 2026-07-08T07:18:31+00:00 ## Executables - sqlformat (cli) - sqlformat (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: 0.5.5 - Package-manager updated: 2026-06-14 - Local data: ok - Upstream repository: https://github.com/andialbrecht/sqlparse - info: No cached GitHub release or tag data was available. ## Project history and usage sqlparse is a Python package and companion sqlformat command for non-validating SQL parsing, statement splitting, and SQL formatting. ### Project history 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. ### Adoption history 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. ### How it is used 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. ### Why package nerds care 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. ### Timeline - 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. ### Sources - - - - source_facts.package-manager ## 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:** sqlparse - **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 - 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 ## Related links - [Source-control packages](https://www.automicvault.com/pkg/source-control-tools/) - Belongs to a source-control command family. - [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. - [python@3.14](https://www.automicvault.com/pkg/brew/python-3-14/) - Runtime dependency declared by Homebrew. - [btparse](https://www.automicvault.com/pkg/brew/btparse/) - Shares av.db curated category or tags: cli, developer-tools, library, parser, parsing. - [cpp-peglib](https://www.automicvault.com/pkg/brew/cpp-peglib/) - Shares av.db curated category or tags: cli, developer-tools, library, parser, parsing. - [htmlcxx](https://www.automicvault.com/pkg/brew/htmlcxx/) - Shares av.db curated category or tags: cli, developer-tools, library, parser, parsing. - [urdfdom](https://www.automicvault.com/pkg/brew/urdfdom/) - Shares av.db curated category or tags: cli, developer-tools, library, parser, parsing. - [htmlcleaner](https://www.automicvault.com/pkg/brew/htmlcleaner/) - Shares av.db curated category or tags: cli, developer-tools, parser, parsing. - [libfyaml](https://www.automicvault.com/pkg/brew/libfyaml/) - Shares av.db curated category or tags: cli, developer-tools, parser, parsing. - [sleek](https://www.automicvault.com/pkg/brew/sleek/) - Shares av.db curated category or tags: cli, developer-tools, sql. - [sql-lint](https://www.automicvault.com/pkg/brew/sql-lint/) - Shares av.db curated category or tags: cli, developer-tools, sql. - [python-tabulate](https://www.automicvault.com/pkg/brew/python-tabulate/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, developer, developer-tools, formatting, python. - [darker](https://www.automicvault.com/pkg/brew/darker/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, developer, developer-tools, formatting, python. - [djhtml](https://www.automicvault.com/pkg/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/automic-vault/db/blob/main/combined/sqlparse.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