PHP-SQLlint

Command line tool to validate (syntax check) SQL files. Primarily for MySQL .sql files.

Can be used in git pre-commit hooks to catch errors. Use it from your shell, offline and without any SQL server.

You can also use it to format SQL queries.

Usage

Syntax check:

$ php-sqllint tests/files/create-missingcomma.sql
Checking SQL syntax of tests/files/create-missingcomma.sql
 Line 3, col 5 at "pid": A comma or a closing bracket was expected.
 Line 3, col 13 at "11": Unexpected beginning of statement.
 Line 3, col 17 at "DEFAULT": Unrecognized statement type.

Emacs mode:

$ php-sqllint -r emacs tests/files/create-noname.sql
tests/files/create-noname.sql:1.12:Error: The name of the entity was expected.
tests/files/create-noname.sql:1.13:Error: A closing bracket was expected.
tests/files/create-noname.sql:1.13:Error: At least one column definition was expected.

Formatting:

$ php-sqllint --format tests/files/select-unformatted.sql
SELECT
  id,
  NAME,
  url
FROM
  users
WHERE
  DATE > NOW() AND id != 0
ORDER BY NAME
LIMIT 10

Syntax highlighting

ANSI colors are applied automatically when not piping; you can use the --highlight option to override the automatism.

--highlight option values:

none: No highlighting. Use it to disable automatic highlighting
ansi: ANSI escape codes for your shell
html: HTML tags

Bugs

Does php-sqllint not detect a syntax error, or doesn't support a certain SQL statement? Then please report a bug at phpmyadmin/sql-parser.

Download

The download files are equipped with all dependencies. Just download and run.

Download the latest release:

0.2.3, 2020-04-14
- php-sqllint-0.2.3.bz2.phar, 234 kiB
  SHA256: 19a5efb0f47b88bc882dbd3ad49cb7cec5a0f085fef11ccbbe2d1d5feb73d287
- php-sqllint-0.2.3.phar, 874 kiB
  SHA256: a02b50ee2bfd20a67da9c6786b72611c9c1bdd969ed1fa1a3565644881b095df

See php-sqllint downloads page for all released versions.

Dependencies

PEAR's Console_Commandline
phpMyAdmin's SqlParser

Dependency installation

$ composer install

Now you can use ./bin/php-sqllint without building the phar yourself.

Building

Preparation

Write new version number into VERSION

Create the release

You'll need phing, the PHP build tool:

$ phing

The result are .phar files in dist/ directory that you can execute:

$ ./dist/php-sqllint-0.0.1.phar tests/files/create-noname.sql
Checking SQL syntax of tests/files/create-noname.sql
 Line 1, col 12 at "(": The name of the entity was expected.

About PHP-SQLlint

License

php-sqllint is licensed under the AGPL v3 or later.

Homepage

Home page

http://cweiske.de/php-sqllint.htm

Source code

http://git.cweiske.de/php-sqllint.git

Mirror: https://github.com/cweiske/php-sqllint

Author

Written by Christian Weiske, cweiske+php-sqllint@cweiske.de