SQL Formatter

Format, beautify, and indent SQL queries across PostgreSQL, MySQL, SQLite, and T-SQL.

Dialect

Keyword Casing

Indentation

Raw SQL Query296 chars

Formatted SQL326 chars

SELECT
  u.id,
  u.username,
  u.email,
  count(o.id) AS total_orders,
  sum(o.amount) AS total_spent
FROM
  users u
  LEFT JOIN orders o ON u.id = o.user_id
WHERE
  u.status = 'active'
  AND u.created_at >= '2025-01-01'
GROUP BY
  u.id,
  u.username,
  u.email
HAVING
  count(o.id) > 5
ORDER BY
  total_spent DESC
LIMIT
  50;

How to use SQL Formatter

1Paste or type your raw, minified, or unformatted SQL query into the input editor.
2Select your target SQL dialect (Standard SQL, PostgreSQL, MySQL, SQLite, Transact-SQL, PL/SQL, etc.).
3Choose keyword capitalization preferences (UPPERCASE or lowercase keywords).
4Click 'Format SQL' to apply clean hierarchical indentation and clause separation.
5Click 'Copy' to paste your formatted query directly into DBeaver, pgAdmin, DataGrip, or your source code.

Key Features & Highlights

•Comprehensive SQL Dialect Support: Formats Standard SQL, PostgreSQL, MySQL, MariaDB, SQLite, Transact-SQL (T-SQL), and Oracle PL/SQL.
•Dialect-Aware Parser: Powered by the industry-standard sql-formatter engine for accurate AST reconstruction.
•Keyword Case Control: Automatically converts SQL reserved keywords (SELECT, FROM, WHERE, JOIN) to uppercase or lowercase.
•Zero Database Connections: Formats purely syntactically without connecting to databases or requiring credentials.
•100% Client-Side Privacy: Your proprietary schemas, tables, and internal queries never leave your local browser.

How Online SQL Formatting & Beautification Works

Complex Structured Query Language (SQL) statements involving multiple subqueries, window functions, and nested joins quickly become unreadable when written on a single line or formatted inconsistently across team members.

Lexical Parsing and Clause Indentation

The BrivTools SQL Formatter leverages the robust sql-formatter lexical engine to parse SQL statements into a structured token stream. It enforces standard indentation rules for major clauses (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY), aligns joined conditions, and preserves string literals and comments intact.

Zero Network Transmission for Database Security

In enterprise environments, database queries contain proprietary column names, business metrics, and sensitive filtering predicates. Our formatter executes 100% locally within your browser sandbox. No queries, credentials, or schema definitions are transmitted across the internet.

Frequently Asked Questions

Does this tool execute my SQL query or connect to a database?

No. The SQL Formatter is strictly a cosmetic syntax beautifier. It never connects to any database server, executes statements, or logs schema data.

Which SQL dialects are supported?

Supported dialects include Standard ANSI SQL, PostgreSQL, MySQL, MariaDB, SQLite, Transact-SQL (SQL Server), Oracle PL/SQL, Redshift, and BigQuery.

Can I capitalize SQL keywords automatically?

Yes! You can toggle between UPPERCASE keywords (e.g. SELECT, WHERE, INNER JOIN) and lowercase keywords to adhere to your engineering team's style guide.

Is my query data uploaded or stored anywhere?

No. All parsing and formatting occur 100% client-side in your web browser. No queries are uploaded or logged.

What happens if my SQL has a syntax error?

If a statement contains unsupported syntax or unclosed quotes, the formatter gracefully alerts you without corrupting your query.

Related Free Tools

Explore complementary utilities to boost your workflow

View all free tools →

dev

JSON Formatter

Format, validate, beautify, and repair JSON with configurable indentation, recursive key sorting, and instant syntax diagnostics.

Open Tool→

dev

HTML Formatter & Minifier

Beautify, indent, format, and minify HTML markup with W3C void element handling, comment controls, and sandboxed live rendered preview.

Open Tool→

dev

Text Diff Checker

Compare two texts and highlight additions, deletions, and modifications line-by-line or word-by-word.

Open Tool→

dev

YAML to JSON

Convert YAML configurations to formatted or minified JSON with instant validation.

Open Tool→