A simple command-line SQL linter that checks syntax against ANSI and PostgreSQL standards.
SQLint is a simple command-line SQL linter that reads SQL files and reports syntax errors and warnings. It checks SQL against ANSI syntax standards using the PostgreSQL parser, helping developers ensure their SQL code is syntactically correct and compliant.
Developers, database administrators, and data engineers who write SQL and want to catch syntax errors early, especially those working with ANSI SQL or PostgreSQL.
SQLint offers a lightweight, focused alternative to complex SQL validation tools, with straightforward CLI usage, editor integrations, and pre-commit support for seamless workflow integration.
Simple SQL linter supporting ANSI and PostgreSQL syntaxes
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Validates SQL against ANSI syntax standards, ensuring code adheres to core SQL grammar and reducing syntax errors before execution.
Uses the PostgreSQL SQL parser for reliable syntax checking, which minimizes false positives and provides accurate error reports for PostgreSQL-specific code.
Supports Emacs, VIM, and SublimeText via popular linting plugins like Flycheck and Syntastic, enabling seamless inline error highlighting during development.
Easily integrates with pre-commit frameworks for automated checks, helping enforce SQL code quality in version control workflows without manual intervention.
Only supports ANSI SQL and PostgreSQL; non-standard variants like MySQL are not covered, as admitted in the README, making it unsuitable for heterogeneous database projects.
Requires Ruby and gem installation, which can be a barrier in environments not using Ruby or where adding Ruby toolchains is undesirable.
Focuses solely on syntax errors and warnings, lacking features like style enforcement, best practice checks, or optimization hints found in more comprehensive linters.