Paste your SQL statements and beautify with one click. Supports MySQL, PostgreSQL, SQL Server, Oracle, SQLite. Keyword case conversion, custom indent, all processing done locally in your browser.
A SQL Formatter (SQL Beautifier) reformats compressed single-line SQL statements into a readable format with proper indentation and line breaks. During development, SQL copied from logs, code, or database clients is often single-line or poorly formatted, making it hard to read. After formatting, keywords get their own lines, subqueries and JOIN conditions are properly indented, making it easy to quickly understand query logic and troubleshoot issues.
When debugging databases, copy single-line SQL from slow query logs, paste it here and beautify with one click to see which fields are SELECTed, which tables are JOINed, and how WHERE conditions are nested. During code reviews, SQL written by colleagues crammed on one line becomes clear after formatting. When migrating databases, unify SQL keywords to uppercase for team conventions. When learning SQL, formatting complex nested queries makes subquery hierarchy easier to understand.
Step 1: Select the SQL dialect (default MySQL). Switch to PostgreSQL or Oracle if needed. Step 2: Choose keyword case mode — uppercase is recommended as it follows SQL best practices. Step 3: Select indent style — 2 spaces for compactness, 4 spaces for clarity. Step 4: Paste your SQL into the left input box, click "Format SQL", and the formatted result appears on the right immediately. Step 5: Click "Copy Result" to paste directly into code, or "Download .sql" to save as a file.
It automatically reformats single-line or messy SQL statements into a readable format with proper indentation and line breaks. Keywords get their own lines, subqueries and JOIN conditions are properly indented, making it easy to understand query logic, troubleshoot performance issues, and review code.
MySQL, PostgreSQL, SQL Server, Oracle, and SQLite. Different dialects have slightly different keyword sets — selecting the correct dialect gives more accurate formatting results.
SQL keyword case doesn't affect execution, but the industry recommends uppercase keywords (SELECT, FROM, WHERE) to visually distinguish them from table and column names, improving readability. This tool supports uppercase, lowercase, and preserve original case.
No. The formatter recognizes single-quoted string literals and SQL comments (-- single line and /* multi-line */) and preserves their content completely during formatting. Keywords inside strings won't be uppercased or line-wrapped.
Completely free. All SQL formatting happens locally in your browser. No data is uploaded to any server, so you can safely process SQL containing sensitive information.