Newer
Older
[![Build Status](https://travis-ci.org/purcell/sqlint.png?branch=master)](https://travis-ci.org/purcell/sqlint)
## 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](https://github.com/flycheck/flycheck)
- VIM, via [Syntastic](https://github.com/scrooloose/syntastic)
- SublimeText, via the SublimeLinter package ([submission pending](https://github.com/SublimeLinter/SublimeLinter3/issues/297))
This software was written by [Steve Purcell](https://github.com/purcell)
and [Kieran Trezona-le Comte](https://github.com/trezona-lecomte)
with the support of our awesome employer
[Powershop](http://www.powershop.co.nz/).
### License and copyright
Copyright Powershop NZ Ltd. MIT license.