PgSanity vs Prettier SQL
PgSanity
github.comPrettier SQL
github.comSide by side
| Figure | PgSanity | Prettier SQL |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Linux | Yes | — |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · SQL Linters and Formatters | 7.9 (#11) | 7.6 (#14) |
| How it works | It wraps bare SQL as embedded SQL in a C-like file and uses ecpg, which uses PostgreSQL’s parser, to report syntax errors. | The plugin uses sql-formatter or node-sql-parser to format SQL files. |
| License | PyPI lists the project’s license expression as MIT. | The package is distributed under the MIT license. |
| Purpose | PgSanity checks the syntax of PostgreSQL SQL files. | prettier-plugin-sql adds SQL formatting support to Prettier. |
Plans
In their own words
Prettier SQL
Prettier SQL has no write-up on Specifiction yet; its figures are above.