Skip to content
SPECIFICTION
Get listed

PgSanity vs Poor SQL

PgSanity

github.com

Poor SQL

poorsql.com

Side by side

FigurePgSanityPoor SQL
Price fromFreeFree
Free planYesYes
Free trial——
Open source—Yes
Web—Yes
Windows—Yes
LinuxYesYes
API—Yes
Self-hostedYes—
Plans published11
Spec score · SQL Linters and Formatters7.9 (#11)9.0 (#1)
SupportThe README points users to the GitHub project page to report problems.Users are directed to contact Tao Klerks by email or file issues in the GitHub issue tracker.

Plans

PgSanity

  • FreeFree

PgSanity pricing →

Poor SQL

  • FreeFree

Poor SQL pricing →

In their own words

PgSanity

PgSanity has no write-up on Specifiction yet; its figures are above.

Visit github.com

Poor SQL

Poor SQL reformats and colorizes T-SQL according to settings such as indentation, tab spacing, maximum width, and where statements and clauses break. It can expand comma lists, boolean and CASE expressions, and JOIN ON sections. Formatting runs in the browser, including offline, and the site says submitted SQL is not sent to an external service. Output views include input SQL, formatted SQL, and HTML source. An obfuscation and minification option can vary colors, line lengths, and keyword case, or substitute keywords. Downloads include plugins for SQL Server Management Studio, Visual Studio, and WinMerge, plus a command-line bulk formatter. The open-source Poor Man’s T-SQL Formatter library is AGPL-licensed and supports Microsoft.NET and Mono; its JavaScript library works in browsers and contexts such as Node.js. The project describes its parsing as coarse rather than full, especially for DDL. The free plan is free. Settings are remembered with a cookie; blocking cookies restores defaults on each visit.

Visit poorsql.com