pgFormatter vs RegSQL

pgFormatter is free software for formatting PostgreSQL SQL queries and PL/pgSQL code. It supports SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL syntax, and the project says it also works with other databases. You can run it as a console program or CGI application that returns text or HTML; a CGI request with an application/json Accept header can return JSON. Formatting controls cover keyword, function, identifier and type case, indentation, query wrapping and comma placement. The --anonymize option hides query literals before formatting. The project documents source installation with Perl Makefile.PL, make and make install, Docker use, Vim and (Neo)Vim integration, Atom and Visual Studio Code links, and a pre-commit hook for SQL files. An online demo limits queries to ten thousand characters. It is distributed under the PostgreSQL Licence at free.

RegSQL is a web SQL workspace combining browser-local formatting with optional AI assistance. Formatting runs in a browser worker without an account or server round trip. It adjusts whitespace and casing while preserving query logic, aliases, and comments, and accepts multi-statement input up to 1 MB. Listed dialects are PostgreSQL, MySQL, MariaDB, SQLite, BigQuery, SQL Server, Snowflake, and Oracle PL/SQL. AI tools can generate SQL from a description, explain an existing query, or suggest a repair. Formatting may reveal parsing problems, but RegSQL does not connect to a database or verify tables, columns, permissions, data types, or runtime behavior. SQL, prompts, and schema text are sent to the AI provider only after Generate, Explain, or Repair is chosen. The Free plan is free, billed Forever, with unlimited local formatting and 20 AI requests monthly. Indie costs $8 a month or $72 billed yearly ($6/month).