SQL

Developer

SQL Query Formatter

Paste a SQL query and get a cleaner, easier-to-review version with keyword casing and clause breaks.

Edit or Paste Here

Editable work area

Use this area for the source text, query, token, or settings you want to test. The cleaned output appears beside it.

Results report

Current results

Characters238
Formatted lines12
StatusReady

Formatted SQL

sql
SELECT users.id,
  users.email,
  count(orders.id) as order_count 
FROM users 
LEFT 
JOIN orders
  ON orders.user_id = users.id 
WHERE users.created_at >= now() - interval '30 days' 
GROUP BY users.id,
  users.email 
ORDER BY order_count desc 
LIMIT 20;

Query summary

SELECT clauses1
JOIN clauses1
WHERE clauses1
ORDER clauses1

Assumptions

Calculation notes

  • This is a readability formatter, not a SQL parser or query validator.