Side by side
JSQLFormatter vs Poor SQL
Both stand on sql linters and formatters. Which one you can start free with, which one lets you read the code, and what each costs once you pay.
Free plan LinuxMacSelf-hosted+1
JSQLFormatter covers a wide range of SQL dialects and offers both library and command-line interfaces. Note the distinction between its NetBeans target and integrations listed as planned.
Visit JSQLFormatter Free plan Open source APIExtensionLinux+2
Poor SQL offers a broad set of formatting controls and several ways to use the formatter, at no charge. Its coarse parsing and cookie-dependent settings may matter for some workflows.
Visit Poor SQLThe facts
| JSQLFormatter | Poor SQL | |
|---|---|---|
| Free plan | Yes | Yes |
| Open source | Not published | Yes |
| Runs on | Linux, Mac, Self-hosted, Windows | API, Extension, Linux, Web, Windows |
| Lowest paid plan | Free or on request | Free or on request |
| Plans published | 1 | 1 |
| Maker | Not published | Not published |
| Website | manticore-projects.com | poorsql.com |
| On sql linters and formatters | #3 of 26 | #1 of 26 |
JSQLFormatter: what it does well
- Supports eleven listed SQL dialects.
- Preserves comments while formatting SQL.
- Offers configurable indentation, comma placement, and casing.
- Available as a Java library and command-line JAR.
What to know first
- Native dynamic libraries are marked “Coming soon.”
- Eclipse, JEdit, Squirrel SQL, and DBeaver are planned, not available integrations.
Poor SQL: what it does well
- Formats T-SQL online or offline.
- Formatting is processed in the browser.
- Offers controls for indentation and line breaks.
- Includes plugins and a command-line formatter.
- Open-source library is AGPL-licensed.
What to know first
- Parsing is coarse rather than full, especially for DDL.
- Blocking cookies resets settings to defaults each visit.
- Supported SQL dialect is T-SQL.
Alternatives to JSQLFormatter Alternatives to Poor SQL The whole list