SQLShack

SQL formatter tools

March 8, 2018 by

This collection of content will provide an overview of SQL formatter tools, with product page links for each of the tools. If you noticed a SQL formatter tool we missed, please let us know in the comments below.

We looked at a lot of SQL Query formatter tools that make pretty SQL code, but we created a list of the top desktop tools only. We did not include SQL formatter online variants. The list includes tools that format T-SQL both as stand alone tools but also as SSMS add-ins. They include both free tools as well as commercially licensed SQL tools.

The SQL formatter tools are ordered alphabetically.



ApexSQL Refactor
Atom Beautify
dbForge SQL Complete
FSQLF
Poor Man’s T-SQL formatter
Rapid Database Extractor
RazorSQL
SQL Assistant
SqlBeautifier
SQL Beautify
SQL Enlight
SQLinForm
SQL PraRup
SQL Pretty Printer
SQL Prompt
SSMSBoost
Tidycode T-Sql Formatter


ApexSQL Refactor

Product page: ApexSQL Refactor
Alexa ranking: 92,223
Status: Active
First release: Jan-2009
Last update: Dec-2017
Add-in support: Visual Studio, SSMS
Author: ApexSQL
License: Commercial license
Price: Free
Free edition: N/A
ApexSQL Refactor - sql formatter tool

Atom Beautify

Product page: Atom Beautify
Alexa ranking: 9,005
Status: Active
First release: Mar-2014
Last update: Nov-2017
Add-in support: No
Author: Glavin Wiechert
License: MIT Licence
Price: Free
Free edition: N/A

dbForge SQL Complete

Product page: dbForge SQL Complete
Alexa ranking: 63,773
Status: Active
First release: Nov-2010
Last update: Nov-2017
Add-in support: Visual Studio, SSMS
Author: Devart
License: Commercial license
Price: $149.95
Free edition: Yes

FSQLF

Product page: FSQLF
Alexa ranking: Unknown
Status: Active
First release: Apr-2011
Last update: Aug-2017
Add-in support: No
Author: Unknown
License: GNU Lesser General Public License v3.0
Price: Free
Free edition: N/A

Poor Man’s T-SQL formatter

Product page: Poor Man’s T-SQL formatter
Alexa ranking: 2,076,351
Status: Active
First release: Apr-2011
Last update: Nov-2017
Add-in support: Visual Studio, SSMS
Author: Tao Klerks
License: GNU Affero General Public License v3.0
Price: Free
Free edition: N/A

Rapid Database Extractor

Product page: Rapid Database Extractor
Alexa ranking: 90,149
Status: Dormant
First release: Unknown
Last update: Nov-2016
Add-in support: No
Author: Idera
License: Commercial license
Price: Free
Free edition: N/A

RazorSQL

Product page: RazorSQL
Alexa ranking: 127,443
Status: Active
First release: Sep-2006
Last update: Jan-2018
Add-in support: No
Author: Richardson Software, LLC
License: Commercial license
Price: $99.95
Free edition: No

SQL Assistant

Product page: SQL Assistant
Alexa ranking: 825,782
Status: Active
First release: Aug-2012
Last update: Jan-2018
Add-in support: Visual Studio
Author: SoftTree Technologies, Inc
License: Commercial license
Price: $214.56 – $352.80
Free edition: No

SqlBeautifier

Product page: SqlBeautifier
Alexa ranking: Unknown
Status: Dormant
First release: Jun-2014
Last update: Aug-2014
Add-in support: No
Author: Ziang Song
License: MIT Licence
Price: Free
Free edition: N/A

SQL Beautify

Product page: SQL Beautify
Alexa ranking: Unknown
Status: Dormant
First release: Unknown
Last update: Nov-2016
Add-in support: Visual Studio
Author: Cody Rigney
License: MIT Licence
Price: Free
Free edition: N/A

SQL Enlight

Product page: SQL Enlight
Alexa ranking: 4,680,700
Status: Active
First release: Jul-2007
Last update: Nov-2017
Add-in support: SSMS
Author: Ubitsoft
License: Commercial license
Price: $195 – $295
Free edition: N/A

SQLinForm

Product page: SQLinForm
Alexa ranking: 1,434,190
Status: Active
First release: Sep-2007
Last update: Nov-2017
Add-in support: Visual Studio, SSMS
Author: Guido Thelen
License: Commercial license
Price: $36.64
Free edition: Yes

SQL PraRup

Product page: SQL PraRup
Alexa ranking: Unknown
Status: Dormant
First release: Apr-2013
Last update: Unknown
Add-in support: No
Author: Vishal Pawar
License: GNU Lesser General Public License (LGPL)
Price: Free
Free edition: N/A

SQL Pretty Printer

Product page: SQL Pretty Printer
Alexa ranking: 142,878
Status: Active
First release: Oct-2011
Last update: May-2017
Add-in support: Visual Studio, SSMS
Author: Gudu Software
License: Commercial license
Price: $120
Free edition: No

SQL Prompt

Product page: SQL Prompt
Alexa ranking: 22,765
Status: Active
First release: Jan-2007
Last update: Nov-2017
Add-in support: Visual Studio, SSMS
Author: Redgate
License: Commercial license
Price: $369
Free edition: No

SSMSBoost

Product page: SSMS boost
Alexa ranking: 1,043,213
Status: Active
First release: 2012
Last update: Jan-2017
Add-in support: SSMS
Author: Solutions Crew GmbH
License: Commercial license
Price: $150
Free edition: Yes

Tidycode T-Sql Formatter

Product page: Tidycode T-Sql Formatter
Alexa ranking: 12,936,457
Status: Dormant
First release: Aug-2010
Last update: Aug-2012
Add-in support: No
Author: Equinoxbase
License: Commercial license
Price: $40
Free edition: No

See more

Seamlessly integrate a powerful, free SQL formatter into SSMS and/or Visual Studio with ApexSQL Refactor. ApexSQL Refactor is a SQL query formatter but it can also obfuscate SQL, refactor objects, safely rename objects and more – with nearly 200 customizable options.





 

SQLShack

SQLShack

SQL Shack was created as a community service from ApexSQL, with the goal to share SQL Server knowledge through articles written by SQL Server professionals and community members
SQLShack

Latest posts by SQLShack (see all)

Lists, T-SQL

About SQLShack

SQL Shack was created as a community service from ApexSQL, with the goal to share SQL Server knowledge through articles written by SQL Server professionals and community members

665 Views