JSQLFormatter vs Prettier SQL
JSQLFormatter
manticore-projects.comPrettier SQL
github.comSide by side
| Figure | JSQLFormatter | Prettier SQL |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | — |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · SQL Linters and Formatters | 8.3 (#5) | 7.6 (#14) |
| License | JSQLFormatter is licensed under Apache 2.0 from version 5.4 onwards; releases through 5.3 were AGPL. | The package is distributed under the MIT license. |
| Maker | Manticore Projects describes itself as a consulting company for financial valuation, reporting and credit risk management. | The package metadata names JounQin as its author, and the repository describes itself as a collection of Prettier plugins. |
| Purpose | JSQLFormatter is a platform independent SQL formatter, beautifier and pretty printer. | prettier-plugin-sql adds SQL formatting support to Prettier. |
Plans
In their own words
JSQLFormatter
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.
Prettier SQL
Prettier SQL has no write-up on Specifiction yet; its figures are above.