JSQLFormatter vs SQLCheck

JSQLFormatter formats SQL for terminal output, documents, and wikis, and is available as a Java library or command-line executable. It parses SQL with a grammar into an abstract syntax tree rather than relying on regular expressions. Supported statements include SELECT, INSERT, MERGE, UPDATE, DELETE, CREATE, and ALTER, including WITH clauses and nested sub-selects. The listed dialects cover Oracle, SQL Server, MySQL, MariaDB, PostgreSQL, H2, DuckDB, BigQuery, Redshift, Databricks, and Snowflake. Formatting can preserve comments between keywords or within join conditions, while leaving comment-like string literals unchanged. Users can configure indentation, comma placement, and the casing of keywords, functions, and objects, with settings applied per invocation, file, or statement. Output options include ANSI terminal highlighting, HTML, and RTF. A Java-source feature imports SQL strings while retaining variables and can export them as String, StringBuilder, or MessageFormat. JSQLFormatter is free. Its license is Apache 2.0 from version 5.4 onward; releases through 5.3 were AGPL. A NetBeans plugin is a platform target, while Eclipse, JEdit, Squirrel SQL, and DBeaver are listed as planned.

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.