PgSanity vs SQLint
PgSanity
github.comSQLint
github.comSide by side
| Figure | PgSanity | SQLint |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Linux | Yes | Yes |
| Self-hosted | Yes | — |
| Plans published | 1 | 1 |
| Spec score · SQL Linters and Formatters | 7.9 (#11) | 7.3 (#21) |
| Intended audience | PyPI classifies the intended audience as developers, information technology, and system administrators. | The package classifiers identify developers as the intended audience. |
| License | PyPI lists the project’s license expression as MIT. | The repository and PyPI list the MIT license. |
| Purpose | PgSanity checks the syntax of PostgreSQL SQL files. | SQLint is a SQL parser and linter for Standard SQL (BigQuery). |
| Support | The README points users to the GitHub project page to report problems. | The opened repository page exposes an Issues tracker for project questions and reports. |
Plans
In their own words
SQLint
SQLint is a free, MIT-licensed Python parser and linter for Standard SQL (BigQuery), intended for developers on Linux. It checks indentation, repeated spaces and blank lines, keyword casing, comma placement, bracket spacing, operator spacing, and join formatting. The `-f` option formats SQL, and automatic fixes are supported. Command-line use and Python imports for `parse`, `check`, and `format` are documented. The project also describes a configuration file, CI/CD integration, and Docker instructions for building and running the tool. Installation uses `pip install sqlint` or a repository clone. PyPI lists version 0.2.4, released October 22, 2019, with a source distribution and a platform-independent `py3-none-any` wheel. The package is classified as Alpha, and no free trial is listed because the package itself is free. The repository provides an Issues tracker for questions and reports. The documented SQL dialect is Standard SQL (BigQuery), with no third-party integrations listed on the opened page.