SqlBeautifier
A sublime plugin to format SQL. It supports both sublime 2 and 3.
Details
Installs
- Total 121K
- Win 66K
- Mac 40K
- Linux 16K
May 18 | May 17 | May 16 | May 15 | May 14 | May 13 | May 12 | May 11 | May 10 | May 9 | May 8 | May 7 | May 6 | May 5 | May 4 | May 3 | May 2 | May 1 | Apr 30 | Apr 29 | Apr 28 | Apr 27 | Apr 26 | Apr 25 | Apr 24 | Apr 23 | Apr 22 | Apr 21 | Apr 20 | Apr 19 | Apr 18 | Apr 17 | Apr 16 | Apr 15 | Apr 14 | Apr 13 | Apr 12 | Apr 11 | Apr 10 | Apr 9 | Apr 8 | Apr 7 | Apr 6 | Apr 5 | Apr 4 | Apr 3 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Windows | 16 | 28 | 27 | 9 | 4 | 30 | 35 | 33 | 28 | 24 | 5 | 22 | 19 | 30 | 22 | 23 | 14 | 3 | 8 | 23 | 44 | 30 | 30 | 30 | 21 | 11 | 34 | 28 | 35 | 28 | 23 | 5 | 2 | 25 | 25 | 28 | 50 | 24 | 8 | 13 | 22 | 33 | 32 | 23 | 24 | 6 |
Mac | 8 | 26 | 21 | 5 | 0 | 17 | 13 | 21 | 29 | 22 | 5 | 8 | 28 | 24 | 19 | 13 | 7 | 1 | 7 | 22 | 24 | 30 | 24 | 23 | 9 | 7 | 19 | 28 | 34 | 26 | 14 | 6 | 6 | 18 | 17 | 29 | 29 | 31 | 7 | 5 | 23 | 21 | 32 | 14 | 13 | 2 |
Linux | 2 | 6 | 1 | 1 | 1 | 1 | 4 | 4 | 4 | 1 | 2 | 1 | 4 | 4 | 11 | 3 | 2 | 4 | 0 | 2 | 7 | 4 | 6 | 4 | 2 | 3 | 3 | 10 | 3 | 5 | 5 | 2 | 1 | 2 | 5 | 3 | 6 | 2 | 1 | 0 | 4 | 6 | 8 | 5 | 1 | 0 |
Readme
- Source
- raw.githubusercontent.com
SqlBeautifier
This is a SQL formatter plugin using python-sqlparse for both Sublime 2 and 3.
Enjoy!
Installation
Please install Sublime Package Control first. Then inside Package Control: Install Package, type SqlBeautifier and then click to confirm.
Settings
The default key binding for Mac is
{ "keys": ["super+k", "super+f"], "command": "sql_beautifier" }
- Kindly note that the
super
key here is generally replaced byCommand (⌘)
key
The default key binding for Windows / Linux is
{ "keys": ["ctrl+k", "ctrl+f"], "command": "sql_beautifier" }
Options for formatter
To change the options, click through Package Settings -> Sql Beautifier -> Settings User and add the overrided options in JSON like this
{
"indent_tabs": true,
"indent_width": 1
}
This overrides the default option at Package Settings -> Sql Beautifier -> Settings Default.
Here is the list of options the formatter supports:
keyword_case: Changes how keywords are formatted. Allowed values are “upper”, “lower” and “capitalize” and null (leaves case intact).
identifier_case: Changes how identifiers are formatted. Allowed values are “upper”, “lower”, and “capitalize” and null (leaves case intact).
strip_comments: If True comments are removed from the statements.
reindent: If True the indentations of the statements are changed.
indent_tabs: If True tabs instead of spaces are used for indentation.
indent_width: The width of the indentation, defaults to 2.