Skip to content
| Marketplace
Sign in
Visual Studio Code>Formatters>SQL BeautifyNew to Visual Studio Code? Get it now.

SQL Beautify

clarkyu

|
176,813 installs
| (24) | Free
More Powerful extension that beautifies SQL/一键美化你的SQL
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

SQL Beautify

😀格式化你杂乱无章的sql/hql代码😀

VS Code extension that beautifies SQL(HQL).

📸 安装 Installation

VSCode Plugin Market

💥 特点 Features

1. Beautify SQL

一键美化你的SQL!请确保你使用的语言是SQL,选择需要优化的代码块,按下Alt+Shift+f即可使用!

Beautify your SQL! Make sure the language is set to SQL,then select your sql code and press Alt+Shift+f just like you normally would.

demo

2. Beautify SQL DDL (Only for hive-sql)

一键美化你的DDL!请确保你使用的语言是SQL,选择需要优化的代码块,按下Alt+Shift+l即可使用!

Beautify your SQL DDL! Make sure the language is set to SQL,then select your sql code and press Alt+Shift+l.

demo

3. Extract SQL DDL (Only for hive-sql)

一键从你的Insert语句中提取的DDL!请确保你使用的语言是SQL,选择需要优化的代码块,按下Alt+Shift+;即可使用!

Extract ddl from insert sql ! Make sure the language is set to SQL,then select your sql code and press Alt+Shift+;.

demo

4. Customize your own style 🐱‍🏍

你可以在vscode中文件-首选项-设置-扩展中找到一些自定义内容。详细的说明,可以阅读wiki-功能说明!

Customize your own sql-beautify style in [settings-extension]. For more detail, please read wiki Features to get more details about features of this extension

customize

💡 注意 Attention

  • 这个插件在hql语句上更加兼容,因为它是我的主要工作语言。如果你在其他类型sql上使用,请小心使用,尤其是你的代码比较复杂的时候。This extension is more compatible in Hive SQL than in other sql language. If you develop on other sql language, it may cause some problems when the code is complex.

  • 请小心使用本插件,建议对代码一段段进行格式化,而不是对整个文件一次性进行格式化。 Please be careful when use this plugin. Do not use it for the whole file. Recommend using it on code blocks one by one.

  • 如果你真的遇到什么问题了,请先Ctrl+z恢复你的代码,然后可以联系我修复可能存在的问题。If you have some problems, try to use Ctrl+z to recover your code and contact me to fix the bug if you wish.

😎 更迭日志 Release Notes

0.3.9 (2022/05/27)

  • 调整了引号内的格式化逻辑,修正以前的错误问题(看起来很难遇到的“大优化”)
  • Adjusted logic for formatting "string" inside quotes

0.3.6 (2022/05/17)

  • 修复了一些错误,感谢@BryceQin, @timegambler和@thx-god
  • Fixed some bugs,Thanks for @BryceQin, @timegambler and @thx-god

More Release Notes

🎅 联系我 Contact Me

如果有任何问题,欢迎在Issues上留言提问题给我。也可以通过我的微信和我联系

If you have any problem,welcome to submit issues or You can contact me via wechat.

wechat

  • Contact us
  • Jobs
  • Privacy
  • Terms of use
  • Trademarks
© 2022 Microsoft