# Install sqlparse with Homebrew, apt

Non-validating SQL parser. Version 0.5.5 via Homebrew; verified 2026-06-14. Also installable with debian: sudo apt install python-sqlparse-doc.

## 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
- **Version:** 0.5.5
- **Source summary:** Non-validating SQL parser
- **Homepage:** <https://github.com/andialbrecht/sqlparse>
- **Last updated:** 2026-06-14T15:13:50+02:00
- **Generated:** 2026-08-03T19:37:03+00:00

## Executables

- sqlformat (alias)

## Install behavior

- Bottle: not available

## Freshness

- Page generated: 2026-08-03
- Package-manager version: 0.5.5
## 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

- <https://github.com/andialbrecht/sqlparse>
- <https://sqlparse.readthedocs.io/>
- <https://sqlparse.readthedocs.io/en/latest/changes.html>
- 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

## 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


## Combined YAML source

View the package source record on GitHub. [combined/sqlparse.yml](https://github.com/mxcl/pkgdb/blob/main/combined/sqlparse.yml)


## Sources

- pkg.so package database
- Geiger risk classifier
- curated package history
- pkgdb category and tag curation
- external package-manager database matches
- cross-ecosystem install command graph
