SQL Formatter
Format and beautify SQL queries online for free. Supports MySQL, PostgreSQL, SQLite, and more.
Input SQL
Formatted
SELECT u.id, u.name, u.email, COUNT(o.id ) AS order_count, SUM(o.total ) AS total_spent FROM users u LEFT JOIN orders o ON u.id = o.user_id WHERE u.created_at >= '2024-01-01' AND u.status = 'active' GROUP BY u.id, u.name, u.email HAVING COUNT(o.id ) > 0 ORDER BY total_spent DESC LIMIT 50;
Minified
275 charsSELECT u.id,u.name,u.email,COUNT (o.id) as order_count,SUM (o.total) as total_spent FROM users u LEFT JOIN orders o ON u.id=o.user_id WHERE u.created_at>='2024-01-01' AND u.status='active' GROUP BY u.id,u.name,u.email HAVING COUNT (o.id)>0 ORDER BY total_spent DESC LIMIT 50;
关于此工具
Format and beautify SQL queries for better readability. Supports SELECT, INSERT, UPDATE, DELETE, CREATE, and complex queries with subqueries, JOINs, and CTEs. Configurable indentation and keyword casing.
如何使用
Paste SQL
Paste your SQL query.
Set Options
Choose indentation, keyword case, and SQL dialect.
Format
Click Format and copy the beautified query.
使用场景
Code Review
Format minified or poorly indented SQL before reviewing or committing.
常见问题
Which SQL dialects are supported?
The formatter handles standard SQL syntax compatible with MySQL, PostgreSQL, SQLite, and SQL Server.