---
id: sqlparse
version: "0.5.5"
license: unclear
license_treatment: permissive
maintenance: active
---

# sqlparse — A non-validating SQL parser.

License: permissive · Maintenance: active · Popularity: top 1,000 on PyPI

## Install

pip install sqlparse
uv add sqlparse
poetry add sqlparse

## Description

python-sqlparse - Parse SQL statements
======================================

|buildstatus|_
|coverage|_
|docs|_
|packageversion|_

.. docincludebegin

sqlparse is a non-validating SQL parser for Python.
It provides support for parsing, splitting and formatting SQL statements.

The module is compatible with Python 3.8+ and released under the terms of the
`New BSD license <https://opensource.org/licenses/BSD-3-Clause>`_.

Visit the project page at https://github.com/andialbrecht/sqlparse for
further information about this project.


Quick Start
-----------

.. code-block:: sh

   $ pip install sqlparse

.. code-block:: python

   >>> import sqlparse

   >>> # Split a string containing two SQL statements:
   >>> raw = 'select * from foo; select * from bar;'
   >>> statements = sqlparse.split(raw)
   >>> statements
   ['select * from foo;', 'select * from bar;']

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

   >>> # Parsing a SQL statement:
   >>> parsed = sqlparse.parse('select * from foo')[0]
   >>> parsed.tokens
   [<DML 'select' at...

## AI interpretation — verify before relying

sqlparse is a non-validating SQL parser that splits, parses, and formats SQL statements without executing them. It enables developers to programmatically manipulate SQL syntax for analysis, reformatting, and integration into tools.

Verdict: sqlparse is a mature, well-maintained SQL parsing library with zero dependencies, permissive licensing, and no known vulnerabilities. It is suitable for production use in applications requiring SQL analysis, formatting, or tokenization without validation or execution.

[View on SkillFed](https://skillfed.io/packages/sqlparse) · [View on PyPI](https://pypi.org/project/sqlparse/)