sqlparse: A Non-Validating SQL Parser for Python

0.5.5 · active · verified Sat Mar 28

sqlparse is a non-validating SQL parser for Python, providing support for parsing, splitting, and formatting SQL statements. The current version is 0.5.5, released on March 28, 2026, with a release cadence of approximately every 6 months.

Warnings

breaking Ensure that sqlparse is installed in your environment to avoid ImportError.
Fix: Install sqlparse using pip: pip install sqlparse

Install

pip install sqlparse Install sqlparse

Imports

sqlparse
```
import sqlparse
```
Ensure the module is installed in your environment

Quickstart

A quickstart guide demonstrating how to split, format, and parse SQL statements using sqlparse.

import sqlparse

# Split a string containing two SQL statements:
raw = 'SELECT * FROM foo; SELECT * FROM bar;'
statements = sqlparse.split(raw)

# Format the first statement and print it out:
first = statements[0]
print(sqlparse.format(first, reindent=True, keyword_case='upper'))

# Parsing a SQL statement:
parsed = sqlparse.parse('SELECT * FROM foo')[0]
print(parsed.tokens)

view raw JSON →