Side by side
JSQLFormatter vs SQLFluff
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 APILinuxMac+2
SQLFluff offers broad dialect support, configurable rules, and automated fixes without executing SQL itself. Teams using dbt should account for the extra templater requirements and possible compile-time database access.
Visit SQLFluffThe facts
| JSQLFormatter | SQLFluff | |
|---|---|---|
| Free plan | Yes | Yes |
| Open source | Not published | Not published |
| Runs on | Linux, Mac, Self-hosted, Windows | API, Linux, Mac, Self-hosted, 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 | sqlfluff.com |
| On sql linters and formatters | #3 of 26 | #7 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.
SQLFluff: what it does well
- Free under the MIT License
- Supports more than 25 SQL dialects
- Autofixes many linting violations
- Parses SQL without database access
- Supports Jinja, dbt, and CI/CD
What to know first
- dbt templating needs an adapter and additional package
- Compile-time database access may be required for some models
- Some templating macros may execute SQL
Alternatives to JSQLFormatter Alternatives to SQLFluff The whole list