SQLint is a simple command-line linter which reads your SQL files and reports any syntax errors or warnings it finds.
At this stage, SQLint checks SQL against the ANSI syntax, and uses the PostgreSQL SQL parser to achieve this. SQLint does not have support for non-standard SQL variants (e.g. MySQL), but contributions are welcome.
SQLint is currently provided as a ruby gem: you can install it using the following command:
gem install sqlint
To check the syntax of a file containing SQL, simply pass the filename to sqlint
on the command line:
sqlint filename.sql
In the absence of a filename, sqlint
reads from standard input.
Support for sqlint
is provided for the following editors:
- Emacs, via Flycheck
- VIM, via Syntastic, Neomake or ALE
- SublimeText, via SublimeLinter
Add this to your .pre-commit-hooks.yaml
:
- repo: https://github.com/purcell/sqlint
rev: master
hooks:
- id: sqlint
This software was written by Steve Purcell and Kieran Trezona-le Comte.
Copyright 2015-2018 Powershop NZ Ltd. Copyright 2018-2021 Steve Purcell. MIT license.
💝 Support this project and my other Open Source work via Patreon