Side by side
Prettier SQL 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 Self-hosted
Prettier SQL adds configurable SQL formatting to a self-hosted Prettier setup, with broad listed dialect support. Its development status and Node.js requirement are important considerations.
Visit Prettier SQL
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
| Prettier SQL | SQLFluff | |
|---|---|---|
| Free plan | Yes | Yes |
| Open source | Not published | Not published |
| Runs on | Self-hosted | 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 | github.com | sqlfluff.com |
| On sql linters and formatters | #11 of 26 | #7 of 26 |
Prettier SQL: what it does well
- Free package distributed under the MIT license.
- Supports a wide range of SQL dialects.
- Formatting options include casing and indentation.
- Can format embedded SQL with prettier-plugin-embed.
- Configuration files and automatic fixes are supported.
What to know first
- Requires Node.js v14.18.0 or later.
- README describes the plugin as under development.
- Formatting may not always match Prettier.
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 Prettier SQL Alternatives to SQLFluff The whole list