Complete Guide to SQL Formatting: Beautify, Minify, and Debug Tips

Why Format SQL?

-- ❌ Crushed into one line—hard to read
SELECT u.id,u.name,o.total FROM users u JOIN orders o ON u.id=o.user_id WHERE o.status='paid' AND o.created_at>'2024-01-01' ORDER BY o.total DESC LIMIT 10;

-- ✅ Formatted—structure is clear
SELECT
  u.id,
  u.name,
  o.total
FROM users u
JOIN orders o ON u.id = o.user_id
WHERE o.status = 'paid'
  AND o.created_at > '2024-01-01'
ORDER BY o.total DESC
LIMIT 10;

Formatting makes the SELECT → FROM → JOIN → WHERE → ORDER BY flow obvious at a glance.

---

Using the ToolsKu SQL Formatter

Steps

1. Open the SQL Formatter
2. Paste your SQL
3. Auto-beautify (uppercase keywords, aligned indentation)
4. Switch to minify mode to strip whitespace

Supported SQL dialects

Dialect	Notes
SQL	Standard SQL
MySQL	MySQL-specific syntax
PostgreSQL	PostgreSQL-specific syntax
SQLite	Lightweight database
T-SQL	SQL Server
PL/SQL	Oracle

---

Formatting Conventions

Uppercase keywords

SELECT, FROM, WHERE, JOIN, ON, AND, OR, ORDER BY, GROUP BY, HAVING, LIMIT

Indentation rules

SELECT
  column1,
  column2,
  CASE
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    ELSE default_result
  END AS calculated
FROM table1
  JOIN table2 ON table1.id = table2.ref_id
WHERE status = 'active'
  AND created_at >= '2024-01-01'
GROUP BY column1, column2
HAVING COUNT(*) > 5
ORDER BY column1 DESC;

Subquery indentation

SELECT *
FROM (
  SELECT
    user_id,
    SUM(amount) AS total
  FROM orders
  WHERE status = 'paid'
  GROUP BY user_id
) AS user_totals
WHERE total > 1000;

---

Practical Scenarios

1. Debugging SQL from logs

Production logs often print minified SQL:

[2024-06-01 10:00:00] QUERY: SELECT * FROM users WHERE email='test@example.com' AND deleted_at IS NULL

Copy into the SQL Formatter to analyze clearly.

2. ORM-generated SQL

// Sequelize / TypeORM SQL is often unformatted
console.log(query.getSql());
// → SELECT `User`.`id`, `User`.`name` FROM `users` AS `User` WHERE ...

Format it to see what the ORM actually runs.

3. JSON to SQL

An API returns a JSON array—you need INSERT statements:

[
  {"name": "Alice", "age": 30},
  {"name": "Bob", "age": 25}
]

Use JSON to SQL to generate:

INSERT INTO users (name, age) VALUES ('Alice', 30);
INSERT INTO users (name, age) VALUES ('Bob', 25);

4. Minify SQL (save bandwidth)

Formatted SQL is for reading; minified SQL is for transport:

-- Formatted: 15 lines, 380 characters
-- Minified: 1 line, 195 characters (49% smaller)

---

Common SQL Formatting Issues

Keywords inside strings stay lowercase

-- ✅ Correct: 'select' inside a string is unchanged
SELECT * FROM logs WHERE message LIKE '%select%'

Comments preserved

SELECT id, name  -- username
FROM users       /* active user count */
WHERE status = 1

The formatter keeps -- line comments and /* */ block comments.

---

Summary

SQL formatting is a high-leverage habit for database developers. The ToolsKu SQL Formatter supports multiple dialects and runs locally in the browser—pair it with JSON to SQL for a full data-to-SQL workflow.