RevealTheme logo

SQL格式化工具

格式化并美化SQL查询:在关键字处换行,对列清单进行缩进。

如何使用本工具

  1. 1

    Paste or type your SQL query into the input box.

  2. 2

    The formatted version appears instantly in the read-only panel below — there is no separate Format button.

  3. 3

    Select the output text and copy it manually into your editor or query tool.

什么是SQL格式化工具?

阅读压缩成一行的SQL令人痛苦。本格式化工具会在主要关键字(SELECT、FROM、WHERE、JOIN等)处换行,并对列清单进行缩进,以便于阅读。其输出在功能上与输入完全相同:格式化不会改变语义。

常见使用场景

  • Untangling a one-line SQL query copied out of an application log or ORM debug output so you can read it.

  • Quickly making a SELECT with a long column list scannable before reviewing it in a pull request.

  • Normalizing keyword casing to uppercase across an ad-hoc query you wrote in lowercase.

  • Pasting a minified query from a config file or migration into a readable shape for documentation.

  • Teaching or explaining a query's clause structure by breaking SELECT, FROM, WHERE, and JOIN onto their own lines.

  • Doing a fast cleanup before a query is too short to justify opening a full IDE formatter.

常见问题

这会重写我的查询吗?
不会:格式化纯粹是为了美观。如果你想要进行正确性检查,请将输出结果交给linter处理。

相关工具