Side by side
pgFormatter vs Poor SQL
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 APILinuxSelf-hosted+1
pgFormatter offers configurable SQL formatting through console and CGI use, with editor and pre-commit options. The online demo has a query-length limit, and other databases may require custom function or keyword lists.
Visit pgFormatter Free plan Open source APIExtensionLinux+2
Poor SQL offers a broad set of formatting controls and several ways to use the formatter, at no charge. Its coarse parsing and cookie-dependent settings may matter for some workflows.
Visit Poor SQLThe facts
| pgFormatter | Poor SQL | |
|---|---|---|
| Free plan | Yes | Yes |
| Open source | Not published | Yes |
| Runs on | API, Linux, Self-hosted, Web | API, Extension, Linux, Web, Windows |
| Lowest paid plan | Free or on request | Free or on request |
| Plans published | 1 | 1 |
| Maker | Not published | Not published |
| Website | github.com | poorsql.com |
| On sql linters and formatters | #4 of 26 | #1 of 26 |
pgFormatter: what it does well
- Free software under the PostgreSQL Licence.
- Offers case, indentation, wrapping, and comma controls.
- Can obscure query literals before formatting.
- Supports console, CGI, and JSON responses.
- Documents editor and pre-commit integrations.
What to know first
- Online demo limits queries to ten thousand characters.
- Other-database functions and keywords need custom lists.
Poor SQL: what it does well
- Formats T-SQL online or offline.
- Formatting is processed in the browser.
- Offers controls for indentation and line breaks.
- Includes plugins and a command-line formatter.
- Open-source library is AGPL-licensed.
What to know first
- Parsing is coarse rather than full, especially for DDL.
- Blocking cookies resets settings to defaults each visit.
- Supported SQL dialect is T-SQL.
Alternatives to pgFormatter Alternatives to Poor SQL The whole list