SQL Formatter

How to Beautify Your SQL Queries

1. Paste Your SQL: Enter your query directly into the left panel, or drag and drop a .sql file.
2. Choose Your Dialect: Open the Options panel and select the database engine your query targets (MySQL, PostgreSQL, SQLite, SQL Server, or Oracle).
3. Configure Formatting:
   • Keyword Case: Choose UPPERCASE, lowercase, or Preserve to control how SQL keywords appear.
   • Indentation: Pick 2 spaces, 4 spaces, or tabs for nesting.
   • Comma Position: Place commas at the end of lines (standard) or at the start of lines (SQL style guide preference).
4. Format: Click the Convert button or press Ctrl + Enter. Your beautifully formatted SQL appears on the right.
5. Analyze: Check the query analysis banner above the editor to understand your query's complexity.

SQL Formatting Examples

Before: Unformatted SQL

SELECT u.id,u.name,u.email,o.order_id,o.total FROM users u INNER JOIN orders o ON u.id=o.user_id LEFT JOIN products p ON o.product_id=p.id WHERE u.active=1 AND o.created_at>'2024-01-01' ORDER BY o.total DESC LIMIT 100;

After: Formatted (UPPERCASE, 2 Spaces)

SELECT
  u.id,
  u.name,
  u.email,
  o.order_id,
  o.total
FROM
  users u
  INNER JOIN orders o ON u.id = o.user_id
  LEFT JOIN products p ON o.product_id = p.id
WHERE
  u.active = 1
  AND o.created_at > '2024-01-01'
ORDER BY
  o.total DESC
LIMIT
  100;

After: Minified

SELECT u.id,u.name,u.email,o.order_id,o.total FROM users u INNER JOIN orders o ON u.id=o.user_id LEFT JOIN products p ON o.product_id=p.id WHERE u.active=1 AND o.created_at>'2024-01-01' ORDER BY o.total DESC LIMIT 100;

Frequently Asked Questions

Does formatting change my query's behavior?

No. SQL formatting only changes whitespace and keyword casing. The logical structure and execution plan of your query remain identical.

Which SQL dialect should I choose?

Choose the database engine you're writing for. Each dialect has slightly different syntax rules. For example, SQL Server uses TOP instead of LIMIT, and Oracle uses ROWNUM. Selecting the right dialect ensures proper formatting of vendor-specific syntax.

What does the query analyzer count?

The analyzer detects tables referenced in FROM, JOIN, INSERT, UPDATE, and DELETE clauses. It counts JOINs of all types (INNER, LEFT, RIGHT, FULL, CROSS). Subqueries are detected by finding (SELECT ...) patterns.

Can I format multiple queries at once?

Yes! Separate your queries with semicolons. The formatter will process each statement and add blank lines between them for readability.

Is my SQL sent to any server?

Never. All processing runs in your browser using JavaScript. Your queries, including any sensitive table names or data, never leave your machine.