Skip to main content
Help us improve Python packaging – donate today!

A library for parsing SQL statements.

Project Description

A highly experimental attempt to have a sane parser library to parse MySQL statements.

At the moment - use it at your own risk!


  • Parses SOME SQL strings.


Some properties that can be accessed.

>>> import mysqlparse
>>> sql = mysqlparse.parse("""
...     ALTER TABLE `django_user` ADD COLUMN `notes` LONGTEXT NOT NULL
... """)
>>> print(sql.statements[0].statement_type)
>>> print(sql.statements[0].table_name)
>>> print(sql.statements[0].ignore)
>>> print(sql.statements[0].alter_specification[0].alter_action)
>>> print(sql.statements[0].alter_specification[0].column_name)
>>> print(sql.statements[0].alter_specification[0].data_type)
>>> print(sql.statements[0].alter_specification[0].null)
>>> print(sql.statements[0].alter_specification[0].column_position)

Checking that the alter statement is backwards compatible with a previous version of SOME code, which does not know how to save notes as NOT NULL:

for statement in sql.statements:
    if statement != 'ALTER':
    for column in statement.alter_specification:
        if column.data_type == 'LONGTEXT':
            if column.null is False and column.default != 'NULL':
                print "{s.table_name}.{c.column_name} is `LONGTEXT NOT NULL` which may break the production system. Use `LONGTEXT DEFAULT NULL` instead.".format(

How can you help?

A short list of things that would help (from relatively easiest):

  • Raise an issue with an edge case statement that should parse, but doesn’t.
  • Raise an issue with how you would like to use this library.
  • Document the available properties in the parsed object.
  • Add a missing test case or suggest a way to avoid so much repetition in tests checking the same statement, but with variations.
  • Suggest how to use pyparsing to do statement validation.
  • Maybe it is possible to generate pyparsing parser from the MySQL source code?
  • Add ability to unparse the parse (sub)trees back into valid SQL.


Out of frustration for lack of a better tool.



  • (Insert new release notes below this line)

0.1.6 (2017-06-16)

0.1.5 (2016-08-23)

  • Change the licence from AGPLv3 to MIT licence.

0.1.4 (2016-02-28)

  • Brought back HISTORY.rst.
  • Add mysqlparse.parse function.
  • Add six as a dependency to make writing Py2 and Py3 compatible code easier.
  • Add support for ALTER TABLE .. MODIFY [COLUMN] statements.
  • Add support for ALTER TABLE .. DROP * statements.
  • Move version string from into mysqlparse.

0.1.3 (2016-02-20)

  • Updated README.rst.
  • Add support for ALTER TABLE ... ADD INDEX statements.

0.1.2 (2016-02-16)

  • A little tidy up.
  • Removed defaultValue parse action.
  • Improved NULL handling.
  • Updated tests to pass.

0.1.1 (2016-02-15)

  • Fixed packaging configuration.

0.1.0 (2016-02-15)

  • First release with code parsing some of ALTER TABLE ... ADD COLUMN statements.

Release history Release notifications

This version
History Node


History Node


History Node


History Node


History Node


History Node


History Node


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
mysqlparse-0.1.6.tar.gz (12.2 kB) Copy SHA256 hash SHA256 Source None Jun 16, 2017

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page