EVERYTHING XIAOMI
Get listed

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.

Place
#21 of 26
Score
5.8
SQLint's website

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.

All about pricing
PlanPriceWhat it gives you
sqlintFreeMIT-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

All alternatives
  1. 1

    Poor SQL

    Free planOpen sourceWebAPIExtensionLinux
    7.3Free plan
  2. 2

    SQLFormat.org

    Free planOpen sourceWebAPIExtensionSelf-hosted
    7.1Free plan
  3. 3

    sqlfmt

    Free planWebAPILinuxSelf-hosted
    6.7Free plan
  4. 4

    RegSQL

    Free planWeb
    6.5From $8 a month
  5. 5

    SQLCheck

    Free planLinuxmacOSWindows
    6.5Free plan
  6. 6

    sqlfmt

    Free planWebAPI
    6.5From $9 a month