SQL Beautifier

Format and indent messy SQL queries with keyword casing and clause alignment.

INPUT

BEAUTIFIED

SELECT u.id,u.name,count(o.id) AS orders
FROM users u
LEFT JOIN orders o
ON o.user_id=u.id AND o.status='paid'
WHERE u.active=1 AND u.created_at>='2024-01-01'
GROUP BY u.id,u.name
HAVING count(o.id)>5
ORDER BY orders DESC
LIMIT 20;

Formatting runs entirely in your browser. No query is sent anywhere.