SQLCheck vs SQLFluff

SQLCheck is a free command-line utility that scans SQL files for common anti-patterns associated with slow queries. It groups findings into logical database design, physical database design, query, and application development categories. Users can choose to check all patterns, medium- and high-risk patterns, or only high-risk patterns. The command line accepts a SQL file name and offers color and verbose output modes. The project identifies Microsoft SQL Server, MySQL, Oracle, PostgreSQL, and SQLite3 as supported dialects, and says it targets all major SQL dialects. Downloads are listed for Debian, RPM, macOS DMG, Windows EXE, and ZIP. Release notes for v1.3 list line numbers and a status code of 1 when anti-patterns are found. SQLCheck does not automatically fix findings and has no editor extensions or configuration file. Source-build instructions name g++ 4.9 or later and CMake. The repository identifies the license as Apache-2.0 and welcomes issues, pull requests, and documentation contributions.

SQLFluff is an open-source, dialect-flexible SQL linter designed for ELT applications. It reports style and syntax issues, parses SQL without database access and can automatically fix many violations with one command. Documentation describes support for more than 25 dialects, including T-SQL, PostgreSQL, BigQuery and Snowflake, alongside more than 70 rules for style, structure and best practices. Jinja templating and dbt are supported, and CI/CD integration includes GitHub Actions output for pull-request annotations. SQLFluff is free under the MIT License and installs from PyPI with pip or another Python package manager. It does not execute SQL itself, but templating macros such as dbt's run_query may execute arbitrary SQL. The Jinja templater uses Jinja2 SandboxedEnvironment to limit unsafe code execution. The dbt templater requires the relevant adapter and sqlfluff-templater-dbt package; models accessing a database during compilation require database access. Community support includes documentation, GitHub, Slack and Stack Overflow.