pkg.soopen package index

brew / rank 4849

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 commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install sqlparse

local Homebrew formula metadata

Linux

Debian aptverified · 92%
sudo apt install python-sqlparse-doc

Debian stable package indexes · python-sqlparse-doc · source: deb.debian.org

overview

Package summary

Non-validating SQL parser

Commands and aliases

  • sqlformat

history

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.

security posture

Risk level: blue

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

Risk classifier

blue risk · medium confidence · tool

Why

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

Signals

  • text:sql

Install behavior

  • No Homebrew bottle metadata was recorded.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

executables

Installed executables

CommandKindExposureNote
sqlformatexecutableindexed executableDiscovered from the local executable index.

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-08-03
manager version0.5.5
manager updated2026-06-14
local dataunknown
upstreamnot available
latest detectednot detected
  • okNo freshness warnings were generated.

install metadata

Package metadata

Package keybrew:sqlparse
Version0.5.5
Package managerHomebrew
Homepagehttps://github.com/andialbrecht/sqlparse
Last updated2026-06-14T15:13:50+02:00
Pulseupdated
Bottlenot recorded
Servicenone declared

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

Debian apt95%

python-sqlparse-doc 0.5.3-1

documentation for non-validating SQL parser in Python

https://github.com/andialbrecht/sqlparse

sudo apt install python-sqlparse-doc
  • Section: doc
  • Architecture: all
  • Source Package: sqlparse
  • 1 dependencies
  • normalized package name match
  • Matched by: Sqlparse
Debian stable package indexes · deb.debian.org · Debian stable package indexes: python-sqlparse-doc from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz
Debian apt95%

python3-sqlparse 0.5.3-1

non-validating SQL parser for Python 3

https://github.com/andialbrecht/sqlparse

sudo apt install python3-sqlparse
  • Section: python
  • Architecture: all
  • Source Package: sqlparse
  • 1 dependencies
  • 1 optional deps
  • normalized package name match
  • Matched by: Sqlparse
Debian stable package indexes · deb.debian.org · Debian stable package indexes: python3-sqlparse from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz
Debian apt95%

sqlformat 0.5.3-1

SQL formatting utility

https://github.com/andialbrecht/sqlparse

sudo apt install sqlformat
  • Section: text
  • Architecture: all
  • Source Package: sqlparse
  • 2 dependencies
  • normalized package name match
  • Matched by: Sqlparse
Debian stable package indexes · deb.debian.org · Debian stable package indexes: sqlformat from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz
Ubuntu apt95%

python-sqlparse-doc 0.4.4-1

documentation for non-validating SQL parser in Python

https://github.com/andialbrecht/sqlparse

sudo apt install python-sqlparse-doc
  • Section: doc
  • Architecture: all
  • Source Package: sqlparse
  • 1 dependencies
  • normalized package name match
  • Matched by: Sqlparse
Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: python-sqlparse-doc from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz
Ubuntu apt95%

python3-sqlparse 0.4.4-1

non-validating SQL parser for Python 3

https://github.com/andialbrecht/sqlparse

sudo apt install python3-sqlparse
  • Section: python
  • Architecture: all
  • Source Package: sqlparse
  • 1 dependencies
  • 1 optional deps
  • normalized package name match
  • Matched by: Sqlparse
Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: python3-sqlparse from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz
Ubuntu apt95%

sqlformat 0.4.4-1

SQL formatting utility

https://github.com/andialbrecht/sqlparse

sudo apt install sqlformat
  • Section: universe/text
  • Architecture: all
  • Source Package: sqlparse
  • 2 dependencies
  • normalized package name match
  • Matched by: Sqlparse
Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: sqlformat from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Used sources

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