Skip to content
SPECIFICTION
Get listed

Public Tools SQL Formatter vs SQLFluff

Public Tools SQL Formatter

public.tools

SQLFluff

sqlfluff.com

Side by side

FigurePublic Tools SQL FormatterSQLFluff
Price fromFreeFree
Free planYesYes
Free trial——
Open source——
WebYes—
Windows—Yes
macOS—Yes
Linux—Yes
API—Yes
Self-hosted—Yes
Plans published11
Spec score · SQL Linters and Formatters7.4 (#18)8.0 (#10)
Dialect supportSupports 20 dialects, including PostgreSQL, MySQL, SQL Server, Oracle PL/SQL, BigQuery, Snowflake, Redshift, Spark, Trino, DuckDB, ClickHouse, Db2, N1QL, SingleStore and TiDB.The documentation says SQLFluff supports more than 25 SQL dialects, including T-SQL, PostgreSQL, BigQuery, and Snowflake.
PurposeFormats SQL queries by changing whitespace and keyword casing.SQLFluff is an open source, dialect-flexible SQL linter designed with ELT applications in mind.

Plans

Public Tools SQL Formatter

  • FreeFree

Public Tools SQL Formatter pricing →

SQLFluff

  • SQLFluffFree

SQLFluff pricing →

In their own words

Public Tools SQL Formatter

Public Tools SQL Formatter has no write-up on Specifiction yet; its figures are above.

Visit public.tools

SQLFluff

SQLFluff is an open-source, dialect-flexible SQL linter designed for ELT applications. It reports style and syntax issues, parses SQL without database access and can automatically fix many violations with one command. Documentation describes support for more than 25 dialects, including T-SQL, PostgreSQL, BigQuery and Snowflake, alongside more than 70 rules for style, structure and best practices. Jinja templating and dbt are supported, and CI/CD integration includes GitHub Actions output for pull-request annotations. SQLFluff is free under the MIT License and installs from PyPI with pip or another Python package manager. It does not execute SQL itself, but templating macros such as dbt's run_query may execute arbitrary SQL. The Jinja templater uses Jinja2 SandboxedEnvironment to limit unsafe code execution. The dbt templater requires the relevant adapter and sqlfluff-templater-dbt package; models accessing a database during compilation require database access. Community support includes documentation, GitHub, Slack and Stack Overflow.

Visit sqlfluff.com