SQLint
SQLint is a free SQL parser and linter for Standard SQL (BigQuery), aimed at developers who want to check query style and format statements.
What SQLint is
SQLint is a free SQL parser and linter for Standard SQL (BigQuery), aimed at developers who want to check query style and format statements. Its checks cover 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. SQLint can be run from the command line or used through its Python API, which exposes `parse`, `check`, and `format`. The project documents a configuration file, CI/CD integration, and instructions for building and running it with Docker. Installation is documented through `pip install sqlint` or a repository clone. The package is MIT-licensed and intended for developers, and its classifier marks it as Alpha. Its listed release is version 0.2.4, dated October 22, 2019. Package files include a source distribution and a platform-independent Python 3 wheel. The stated supported dialect is Standard SQL (BigQuery), and the repository provides an Issues tracker for questions and reports.
Good
- Checks common SQL formatting conventions.
- Formats queries with the `-f` option.
- Offers command-line and Python interfaces.
- Documents configuration and CI/CD integration.
Watch out
- The package is classified as Alpha.
- The listed release is version 0.2.4 from 2019.
- The documented dialect is Standard SQL (BigQuery).
Who it suits
SQLint suits developers working with Standard SQL (BigQuery) who want command-line or Python-based query linting and formatting. Its documented CI/CD support may also suit developers incorporating checks into a build workflow.
Verdict
SQLint provides style checks, formatting, and Python access for BigQuery Standard SQL. Its Alpha classification and listed release date are worth considering before choosing it.
Plans and prices
From SQLint's own pricing page, checked 4 Oct 2001.
| Plan | Price | What it gives you |
|---|---|---|
| sqlint | Free | MIT-licensed Python package · Standard SQL (BigQuery) parser and linter |
The facts
Each one read from SQLint's own pages, with the date it was checked.
What it does
- Container use
- The README includes instructions for building and running SQLint with Docker.checked 4 Oct 2001
- Formatting
- With the `-f` option, SQLint formats SQL queries.checked 4 Oct 2001
- Install
- The README documents installation with `pip install sqlint` or from a repository clone.checked 4 Oct 2001
- Integration
- The project documents command-line and Python use; it does not list third-party integrations on the opened page.checked 4 Oct 2001
- Intended audience
- The package classifiers identify developers as the intended audience.checked 4 Oct 2001
- Latest release
- PyPI lists version 0.2.4, released October 22, 2019.checked 4 Oct 2001
- License
- The repository and PyPI list the MIT license.checked 4 Oct 2001
- Lint rules
- Checks include indentation, repeated spaces and blank lines, keyword casing, comma placement, bracket spacing, operator spacing, and join formatting.checked 4 Oct 2001
- Maturity
- The package is classified as Alpha.checked 4 Oct 2001
- Package files
- PyPI lists a source distribution and a platform-independent `py3-none-any` wheel for version 0.2.4.checked 4 Oct 2001
- Purpose
- SQLint is a SQL parser and linter for Standard SQL (BigQuery).checked 4 Oct 2001
- Python API
- The README shows Python imports for `parse`, `check`, and `format`.checked 4 Oct 2001
- Security
- The opened project pages do not state security certifications or compliance claims.checked 4 Oct 2001
- Support
- The opened repository page exposes an Issues tracker for project questions and reports.checked 4 Oct 2001
Alternatives to SQLint
- 1
Poor SQL
Free planOpen sourceWebAPIExtensionLinux7.3Free plan - 2
SQLFormat.org
Free planOpen sourceWebAPIExtensionSelf-hosted7.1Free plan - 3
sqlfmt
Free planWebAPILinuxSelf-hosted6.7Free plan - 4
RegSQL
Free planWeb6.5From $8 a month - 5
SQLCheck
Free planLinuxmacOSWindows6.5Free plan - 6
sqlfmt
Free planWebAPI6.5From $9 a month
