SQL Formatter for Visual Studio

Download this extension from the Visual Studio Marketplace or get the CI build

Formats T-SQL code to a consistent and readable layout.

Invoke the Format Document command or CTRL+K, CTRL+D to format the document using the settings specified in the options. If no settings has been modified, the default settings will be used.

Powered by the Poor Man's T-SQL Formatter library.

Before:

After:

Format strings

In C# and other languages, you can invoke the formatter by selecting the text and right-click to select Format SQL. Or you can simply hit Ctrl+K, Ctrl+Q.

.editorconfig support

You can specify the configuration options in an .editorconfig file. Here's an example:

[*.sql]
keyword_standardization = true
spaces_per_tab = 4
expand_comma_lists = true
trailing_commas = true
space_after_expanded_comma = true
uppercase_keywords = false
break_join_on_sections = false
expand_boolean_expressions = true
expand_between_conditions = false
expand_case_statements = true
expand_in_lists = true
max_line_width = 999
indent_string = "   "
new_clause_line_breaks = 1
new_statement_line_breaks = 2

When there are no .editorconfig files or the [*.sql] section is missing, the global options will be used.

Global options

How can I help?

If you enjoy using the extension, please give it a ★★★★★ rating on the Visual Studio Marketplace.

Should you encounter bugs or if you have feature requests, head on over to the GitHub repo to open an issue if one doesn't already exist.

Pull requests are also very welcome, since I can't always get around to fixing all bugs myself. This is a personal passion project, so my time is limited.

Another way to help out is to sponsor me on GitHub.