SQL Formatter
SQLFormat and beautify SQL queries with support for multiple dialects and customizable options
All processing happens locally in your browser — your data never leaves your machine.
Loading tool...
Examples
Simple SELECT with JOIN
Input
SELECT u.id, u.name, o.total FROM users u INNER JOIN orders o ON u.id = o.user_id WHERE o.status = 'completed' ORDER BY ...Output
SELECT
u.id,
u.name,
o.total
FROM
users u
INNER JOIN orders o ON u.id = o.user_id
WHERE
o.status = 'complete...Complex Query with Subquery
Input
SELECT d.name, COUNT(e.id) AS employee_count, AVG(e.salary) AS avg_salary FROM departments d LEFT JOIN employees e ON d....Output
SELECT
d.name,
COUNT(e.id) AS employee_count,
AVG(e.salary) AS avg_salary
FROM
departments d
LEFT JOIN employe...INSERT with Multiple Values
Input
INSERT INTO products (name, price, category, in_stock) VALUES ('Widget', 9.99, 'Tools', true), ('Gadget', 24.99, 'Electr...Output
INSERT INTO
products (name, price, category, in_stock)
VALUES
('Widget', 9.99, 'Tools', true),
('Gadget', 24.99, '...Frequently Asked Questions
- What SQL dialects are supported?
- The formatter supports Standard SQL, MySQL, PostgreSQL, T-SQL (SQL Server), and PL/SQL (Oracle). Each dialect handles syntax nuances specific to that database engine, ensuring accurate formatting.
- Can I control how SQL keywords are capitalized?
- Yes. You can choose to format keywords as UPPER case, lower case, or preserve the original casing from your input. Upper case keywords are the most common convention for SQL readability.
- Is my SQL data safe when using this formatter?
- Absolutely. All formatting is performed locally in your browser using JavaScript. Your SQL queries never leave your machine and are never sent to any server.