rdoc-image:https://img.shields.io/gem/v/sqlint.svg rdoc-image:https://img.shields.io/gem/dt/sqlint.svg <a href=“
www.patreon.com/sanityinc”>
alt=“Support me” src=“img.shields.io/badge/Support%20Me-%F0%9F%92%97-ff69b4.svg”>>
SQLint
- a simple SQL linter¶ ↑
About¶ ↑
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. In time, we hope to add support for non-standard SQL variants (e.g. MySQL). Contributions are welcome.
Installation¶ ↑
SQLint
is currently provided as a ruby gem: you can install it using the following command:
gem install sqlint
Usage¶ ↑
To check the syntax of a file containing SQL, simply pass the filename to sqlint
on the command line:
sqlint filename.sql
Editor plugins¶ ↑
Support for sqlint
is provided for the following editors:
-
Emacs, via Flycheck
-
SublimeText, via SublimeLinter
Using with pre-commit¶ ↑
Add this to your .pre-commit-hooks.yaml
:
- repo: https://github.com/purcell/sqlint rev: master hooks: - id: sqlint
Authors¶ ↑
This software was written by Steve Purcell and Kieran Trezona-le Comte.
License and copyright¶ ↑
Copyright Powershop NZ Ltd. MIT license.