PgSanity
5.7#22 in sql linters and formattersFree planFree planLinuxSelf-hosted
Visit| Fact | PgSanity | SQLFormat.org |
|---|---|---|
| File input | It accepts one or multiple filenames and reports syntax errors with file and line information. | The web interface includes an upload-file control for bringing SQL into the formatter. |
| License | PyPI lists the project’s license expression as MIT. | The site says the sqlparse module is released under the New BSD License. |
| Purpose | PgSanity checks the syntax of PostgreSQL SQL files. | SQLFormat is a free online formatter for SQL statements. |
PgSanity suits developers, IT professionals, and system administrators who want to check PostgreSQL SQL files in a command-line or pre-commit workflow.
SQLFormat.org suits people who want to format SQL in a browser or through a lightweight API. Its linked Python module may interest developers who want to use sqlparse in their own applications.