SqlBeautifier
A sublime plugin to format SQL. It supports both sublime 2 and 3.
Details
Installs
- Total 142K
- Win 76K
- Mac 49K
- Linux 17K
Mar 29 | Mar 28 | Mar 27 | Mar 26 | Mar 25 | Mar 24 | Mar 23 | Mar 22 | Mar 21 | Mar 20 | Mar 19 | Mar 18 | Mar 17 | Mar 16 | Mar 15 | Mar 14 | Mar 13 | Mar 12 | Mar 11 | Mar 10 | Mar 9 | Mar 8 | Mar 7 | Mar 6 | Mar 5 | Mar 4 | Mar 3 | Mar 2 | Mar 1 | Feb 29 | Feb 28 | Feb 27 | Feb 26 | Feb 25 | Feb 24 | Feb 23 | Feb 22 | Feb 21 | Feb 20 | Feb 19 | Feb 18 | Feb 17 | Feb 16 | Feb 15 | Feb 14 | Feb 13 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Windows | 10 | 19 | 19 | 24 | 13 | 1 | 5 | 13 | 19 | 27 | 19 | 11 | 2 | 2 | 14 | 20 | 24 | 24 | 15 | 3 | 4 | 18 | 11 | 15 | 24 | 19 | 1 | 4 | 15 | 21 | 13 | 18 | 9 | 3 | 1 | 21 | 19 | 21 | 27 | 19 | 7 | 1 | 8 | 3 | 10 | 9 |
Mac | 5 | 18 | 12 | 20 | 18 | 2 | 1 | 13 | 7 | 19 | 21 | 23 | 1 | 4 | 9 | 20 | 13 | 21 | 13 | 3 | 2 | 10 | 15 | 23 | 21 | 18 | 4 | 3 | 12 | 10 | 17 | 11 | 12 | 3 | 3 | 8 | 22 | 23 | 15 | 15 | 7 | 3 | 4 | 7 | 8 | 3 |
Linux | 0 | 2 | 6 | 3 | 2 | 0 | 0 | 2 | 7 | 4 | 4 | 4 | 1 | 2 | 1 | 5 | 5 | 2 | 2 | 2 | 1 | 3 | 3 | 2 | 6 | 3 | 2 | 2 | 1 | 3 | 0 | 3 | 0 | 1 | 1 | 1 | 7 | 2 | 3 | 2 | 1 | 0 | 6 | 7 | 1 | 2 |
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.