SQL 格式化 / 压缩

美化与压缩 SQL，支持多种方言（MySQL / PostgreSQL / Oracle / SQL Server 等）。

本地处理

方言

关键字

缩进

输入

select id, name, email from users u left join orders o on o.user_id = u.id where u.active = 1 and o.amount > 100 order by o.created_at desc limit 10;

输出

SELECT
  id,
  name,
  email
FROM
  users u
  LEFT JOIN orders o ON o.user_id = u.id
WHERE
  u.active = 1
  AND o.amount > 100
ORDER BY
  o.created_at DESC
LIMIT
  10;

SELECT
  id,
  name,
  email
FROM
  users u
  LEFT JOIN orders o ON o.user_id = u.id
WHERE
  u.active = 1
  AND o.amount > 100
ORDER BY
  o.created_at DESC
LIMIT
  10;

相关工具