No. 3 of 26 ·SQL Linters and Formatters

JSQLFormatter

Windows · Mac · Linux · Self-hosted

Freedom report

Three barsScore 6.5

Free tierA free tier is on its own pricing page
Open codeNo open-source code on record
Runs widely3 of 6 device platforms
DocumentedPlans, terms and facts published

JSQLFormatter is ranked #3 of 26 in SQL linters and formatters on Freedom251. 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 12

Two bars SQL Formatter Free tier No. 1Free6.6 Two bars Sqruff Free tier No. 2Free6.6 Two bars Poor SQL Free tier No. 4Free6.5 Two bars Sleek Free tier No. 5Free6.5 One bar sqlfmt Free tier No. 6Free6.5 Two bars TSQLLint Free tier No. 7Free6.5

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 Freedom251

Best SQL Linters and Formatters in 2026#3 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