RegSQL vs SQL Formatter

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).

SQL Formatter is a free, MIT-licensed JavaScript library for pretty-printing SQL queries, with a browser demo and command-line tool. Formatting options include indentation; keyword, data type, function, and identifier case; logical operator placement; expression width; query spacing; and operator spacing. It supports dialects including BigQuery, ClickHouse, DB2, DuckDB, Hive, MariaDB, MySQL, TiDB, Couchbase N1QL, Oracle PL/SQL, PostgreSQL, Redshift, SingleStoreDB, Snowflake, Spark, SQL Server Transact-SQL, and Trino/Presto. The command-line tool accepts SQL from standard input or a file, can produce formatted output, and can update a file in place. The project also lists VS Code and Vim extensions, a Prettier plugin, and an ESLint integration. Its JSON Schema supports configuration-file autocompletion and IntelliSense, with usage guides for VS Code and Zed. The library can replace prepared-statement placeholders when parameter values are supplied. It does not support stored procedures or changing the delimiter from a semicolon. Templating syntax is not directly supported; a parameter-type workaround may not cover every construct. The maintainer describes the project as being in maintenance mode, with feasible bug fixes and likely no new features.