Skip to content
SPECIFICTION
Get listed

Primova SQL Formatter & Linter vs sqlfmt

Primova SQL Formatter & Linter

primova.app

sqlfmt

github.com

Side by side

FigurePrimova SQL Formatter & Lintersqlfmt
Price fromFreeFree
Free planYesYes
Free trial——
Open source——
WebYesYes
Linux—Yes
API—Yes
Self-hosted—Yes
Plans published11
Spec score · SQL Linters and Formatters7.5 (#16)8.5 (#3)
PurposeFormats SQL across eight dialects and lints queries for risky patterns.sqlfmt is a gofmt-style command-line formatter for PostgreSQL SQL.

Plans

Primova SQL Formatter & Linter

  • FreeFree

Primova SQL Formatter & Linter pricing →

sqlfmt

  • Browser formatterFree

sqlfmt pricing →

In their own words

Primova SQL Formatter & Linter

Primova SQL Formatter & Linter has no write-up on Specifiction yet; its figures are above.

Visit primova.app

sqlfmt

sqlfmt is a free formatter for PostgreSQL SQL, available as a command-line tool and as a browser formatter running through WebAssembly. Its river-aligned style pads clause keywords so they share a column. The CLI reads SQL from files or stdin and writes formatted SQL to stdout; it can also rewrite files in place, list files needing changes, and show unified diffs. Its explain subcommand formats PostgreSQL plan text and can provide advice, canonicalized output, or structural comparisons. Plan advice describes join order, join and access methods, and parallelism, without costs, row estimates, or timing. The explain diff operation returns exit code 0 for structurally identical plans and 1 when structures differ, so it can be used in scripts and CI. A Go subpackage provides formatting for Go programs, and the project includes Emacs and Vim integrations. The browser build exposes formatting and version functions to JavaScript. Deeply nested subqueries and less common upsert or DDL forms remain best-effort areas. sqlfmt is intended for standalone formatting and SQL used in The Art of PostgreSQL book and courses.

Visit github.com