- Home
- SQL Linters and Formatters
- Public Tools SQL Formatter
Public Tools SQL Formatter
What it is
Public Tools SQL Formatter is a free web tool that reformats SQL by changing whitespace and keyword casing. It supports 20 dialects, including Standard SQL, PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Oracle PL/SQL, BigQuery, Snowflake, Redshift, Spark, Hive, Trino, DuckDB, ClickHouse, Db2, N1QL, SingleStore, and TiDB. Users can choose uppercase, lowercase, or as-typed keywords, plus two-space, four-space, or tab indentation. Semicolon-separated statements appear sequentially with blank lines between them. Processing runs in the browser; the page says no network requests occur after loading, so queries remain on the user’s machine and formatting can continue offline. The tool identifies the line and column of unbalanced parentheses or unclosed quotes. It does not validate query logic, inspect schemas, optimize, or lint SQL. Stored procedures and vendor-specific scripting blocks are known weak spots. No sign-up or email is required, and the free plan has no query-length or daily limit.
For and against
For
- Supports 20 SQL dialects
- Offers three keyword-casing choices
- Provides multiple indentation styles
- Works offline after loading
- No query-length or daily limit
Against
- Does not validate query correctness
- Does not optimize or lint SQL
- Stored procedures are a weak spot
- Web platform only
The verdict
Public Tools SQL Formatter focuses on presentation rather than SQL analysis. Its broad dialect coverage, local processing, and unrestricted free plan make it practical for formatting work.
Who it suits
This formatter suits people preparing SQL for editors or migrations, especially across supported dialects. It also fits users who need browser-local and offline formatting.
Plans and prices
Free
No sign up · no limit on query length · no daily limit
Read 8 Oct 2026 · public.tools
On the record
- Audience
- The page describes copying formatted queries back into an editor or migration, making it suitable for people working with SQL queries and migrations.public.tools · read 8 Oct 2026
- Dialect support
- Supports 20 dialects, including PostgreSQL, MySQL, SQL Server, Oracle PL/SQL, BigQuery, Snowflake, Redshift, Spark, Trino, DuckDB, ClickHouse, Db2, N1QL, SingleStore and TiDB.public.tools · read 8 Oct 2026
- Formatting options
- Users can choose uppercase, lowercase or as-typed casing, and two-space, four-space or tab indentation.public.tools · read 8 Oct 2026
- Limitations
- It does not validate query correctness, understand the user's schema, optimize queries or lint them; stored procedure bodies and vendor-specific scripting blocks are a known weak spot.public.tools · read 8 Oct 2026
- Multiple statements
- Semicolon-separated statements are formatted one after another with a blank line between them.public.tools · read 8 Oct 2026
- Offline use
- The page says users can disconnect after it loads and continue formatting queries.public.tools · read 8 Oct 2026
- Parsing errors
- The formatter parses the statement and reports the line and column when it encounters an unbalanced parenthesis or unclosed quote.public.tools · read 8 Oct 2026
- Private processing
- The formatter runs in the browser and the page says it makes no network requests after loading, so queries stay on the user's machine.public.tools · read 8 Oct 2026
- Purpose
- Formats SQL queries by changing whitespace and keyword casing.public.tools · read 8 Oct 2026
- Supported use
- The page says it is safe for production queries and requires no sign-up or email address.public.tools · read 8 Oct 2026