JSQLFormatter

7.1easy start · #4 of 26
in SQL Linters and Formatters

Free to practise onyes
Free trialnot on record
Well documentedyes
Runs where you workyes

Runs on Linux, Mac, self-hosted, Windows.

JSQLFormatter is ranked #4 of 26 in SQL linters and formatters on The Geeks Club. It runs on Linux, macOS, Self-hosted, Windows. There is a free plan.

JSQLFormatter plans and pricing

All plans

JSQLFormatter Free Apache 2.0 licensed from version 5.4; available as Java library and command-line executable manticore-projects.com · 4 Oct 2026

Compared on SQL linters and formatters

Supported SQL dialects: Oracle, SQL Server, MySQL, MariaDB, PostgreSQL, H2, DuckDB, BigQuery, Redshift, Databricks, Snowflake
Editor extensions: Yes

Best JSQLFormatter alternatives

See all 20

sqlfmt 0 of 4 in the starter kit Lesson 17.3 Poor SQL 0 of 4 in the starter kit Lesson 27.2 TSQLLint 0 of 4 in the starter kit Lesson 37.2 Sqruff 0 of 4 in the starter kit Lesson 57.0 Sleek 0 of 4 in the starter kit Lesson 66.9 SQL Formatter 0 of 4 in the starter kit Lesson 76.9

The record

Purpose: JSQLFormatter is a platform independent SQL formatter, beautifier and pretty printer.
Parsing: It parses SQL into an abstract syntax tree using a real grammar rather than regular expressions.
Database coverage: The site lists Oracle, SQL Server, MySQL, MariaDB, PostgreSQL, H2, DuckDB, BigQuery, Redshift, Databricks and Snowflake.
Statement coverage: It supports SELECT, INSERT, MERGE, UPDATE, DELETE, CREATE and ALTER statements, including WITH clauses and nested sub-selects.
Comments: It preserves comments, including comments between keywords or inside join conditions, and leaves comment-like string literals alone.
Output formats: It supports ANSI terminal highlighting and HTML and RTF output for documents and wikis.
Java source: It can import SQL strings from Java source while preserving variables and export them as String, StringBuilder or MessageFormat.
Configuration: Indent width, comma placement, and keyword, function and object casing can be configured per invocation, file or statement.
Interfaces: The product is offered as a Java library JAR from Maven Central and as an executable JAR for command-line use.
IDE integrations: The site says a NetBeans plugin is a platform target and lists Eclipse, JEdit, Squirrel SQL and DBeaver as planned.
Native libraries: The installation page labels native dynamic libraries as “Coming soon.”
License: JSQLFormatter is licensed under Apache 2.0 from version 5.4 onwards; releases through 5.3 were AGPL.
Security and privacy: The product page describes local Java and command-line use but does not state a security certification or compliance claim.
Maker: Manticore Projects describes itself as a consulting company for financial valuation, reporting and credit risk management.
Price from: Free

Where it ranks on The Geeks Club

Best SQL Linters and Formatters in 2026#4 of 26

Is JSQLFormatter yours?

Claim it for free: prove the domain, then correct facts, plans and screenshots. An editor reviews every change.

Claim it free Promote JSQLFormatter

Sources

manticore-projects.com/JSQLFormatter/index.html· checked 4 Oct 2026
manticore-projects.com/JSQLFormatter/install.html· checked 4 Oct 2026
manticore-projects.com/VBox/company.html· checked 4 Oct 2026