Specifiction
For vendors
AdvertiseTop spots, featured rows, home sponsor Get listedAdd a product we don't cover yet Claim a listingFree: verify the domain, then correct your page Vendor dashboardNumbers, orders and placements
List your tool
Vendor dashboard
Tech riderRev. 4 Oct 2026

JSQLFormatter

Ch 067.1of 26 SQL Linters and Formatters
  1. 1Runs onLinux, Mac, self-hosted, Windows
  2. 2CostsFree plan
  3. 3Supported SQL dialectsOracle, SQL Server, MySQL, MariaDB, PostgreSQL, H2, DuckDB, BigQuery, Redshift, Databricks, Snowflake
  4. 4Editor extensionsYes
4 lines stated Written from the maker's own pages: manticore-projects.com
Visit site Alternatives
The JSQLFormatter homepage

Overview

JSQLFormatter is ranked #6 of 26 in SQL linters and formatters on Specifiction. 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, Snowflakemanticore-projects.com
Editor extensions
Yesmanticore-projects.com

Facts

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

Company

Founded
2011manticore-projects.com · 28 Sept 2026

Best JSQLFormatter alternatives

See all 12
All accessCh 01 Squawk AndroidAPI 7.4 All accessCh 02 sqlfmt Free planAPILinux Free to start7.3 All accessCh 03 Poor SQL Free planAPILinux Free to start7.2 All accessCh 04 Sqruff Free planBrowserLinux Free to start7.2 All accessCh 05 TSQLLint Free planBrowserLinux Free to start7.2 All accessCh 07 Sleek Free planBrowserLinux Free to start7.1

Where it ranks on Specifiction

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