sqlfmt

7.3easy start · #1 of 26
in SQL Linters and Formatters

Free to practise onyes
Free trialnot on record
Well documentedyes
Runs where you worknot on record

Runs on api, Linux, self-hosted, Web.

sqlfmt is ranked #1 of 26 in SQL linters and formatters on The Geeks Club. It runs on API, Linux, Self-hosted, Web. There is a free plan.

sqlfmt plans and pricing

All plans

Browser formatter Free runs in browser via WebAssembly · no install required github.com · 2 Oct 2026

Compared on SQL linters and formatters

Free plan: Yes
Supported SQL dialects: PostgreSQL
Automatic fixes: Yes
Editor extensions: Yes
CI/CD integration: Yes

Best sqlfmt alternatives

See all 20

Poor SQL 0 of 4 in the starter kit Lesson 27.2 TSQLLint 0 of 4 in the starter kit Lesson 37.2 JSQLFormatter 0 of 4 in the starter kit Lesson 47.1 Sqruff 0 of 4 in the starter kit Lesson 57.0 Sleek 0 of 4 in the starter kit Lesson 66.9 SQL Formatter 0 of 4 in the starter kit Lesson 76.9

The record

Purpose: sqlfmt is a gofmt-style command-line formatter for PostgreSQL SQL.
Formatting style: It implements a river-aligned style that right-pads clause keywords to the same column.
Browser use: The PostgreSQL SQL Formatter runs sqlfmt in a browser through WebAssembly and is free to use without installation.
CLI input/output: The command reads SQL from files or stdin and writes formatted SQL to stdout, with options for in-place rewriting, listing differences, and unified diffs.
EXPLAIN tools: The explain subcommand formats PostgreSQL plan text and can produce plan advice or structural diffs.
Plan comparison: Explain diff exits 0 for structurally identical plans and 1 when their structures differ.
Canonicalization: The -canonical option normalizes ordering and schema-qualification differences when comparing advice from different sources.
Go library: The format subpackage exposes Format(io.Reader) (string, error) for formatting SQL in Go programs.
Editor integrations: The repository provides an Emacs sqlfmt-mode and Vim ftplugin integration through formatprg and equalprg.
WebAssembly API: The WebAssembly build exposes sqlfmt.format(sql) and sqlfmt.version to browser JavaScript.
WebAssembly size: The TinyGo and wasm-opt build is about 330 KB, compared with about 2.9 MB for the standard Go WebAssembly target.
Compatibility limits: Deeply nested subqueries and exotic upsert or DDL forms remain best-effort formatting areas.
Source corpus: The formatting style was derived from 343 SQL files in The Art of PostgreSQL query corpus.
License: sqlfmt is released under the PostgreSQL Licence.
Price from: Free

Where it ranks on The Geeks Club

Best SQL Linters and Formatters in 2026#1 of 26

Is sqlfmt yours?

Claim it for free: prove the domain, then correct facts, plans and screenshots. An editor reviews every change.

Claim it free Promote sqlfmt

Sources

github.com/dimitri/sqlfmt· checked 30 Sept 2026
theartofpostgresql.com· checked 30 Sept 2026
github.com/dimitri· checked 2 Oct 2026