What are the best SQL formatting tools?

asked by Ekaterina Sklyarova
60 contributors
9 solutions
  1. 14

    #1ApexSQL Refactor

    ApexSQL Refactor

    ApexSQL Refactor is a free software capable of formatting SQL with over 160 options, aside from encapsulating it into procedures. It can also safely rename and format SQL objects and change procedure parameters.

    Software

    Windows

    Free

    Moisés Salinas
    Written on August 10, 2018
    "For a free software, the features in this one are already fantastic. 160 options are more than enough for a coder's needs. And for all this talk that I have talked, I will be giving ApexSQL 5 stars!"
  2. 9

    #2Atom Beautify

    Atom Beautify

    Atom Beautify is a free software first released in 2014 and was created by Glavin Wiechert. The software is capable of improving the overall appearance of HTML, JavaScript, PHP, SQL, and more.

    Software

    Windows, Mac

    Free

    Anna Kelley
    Written on August 10, 2018
    "I've never thought that we can also improve the overall appearance of our worktools. Not only that, but it is also usable for others such as Javascript, which I am also working with aside from SQL."
  3. 8

    #3FSQLF

    FSQLF

    FSQLF is a open-source software that is free for users to download. It was first released in 2011 and helps users in formatting SQL codes and other SQL-related problems.

    Software

    Windows

    Free

    Joshua Ramos
    Written on August 10, 2018
    "This is the only tool that SQL coders need. As for me, it is really helpful for my longtime work. And also, it is a free to download tool, so grab away guys!"
  1. 8

    #4Poor Man's T-SQL Formatter

    Poor Man's T-SQL Formatter

    Poor Man's T-SQL Formatter is a free and open-source formatting tool for SQL and Transact-SQL (T-SQL). It was written in C# and provides options for formatting that caters to various formatting styles or standards.

    Software

    Windows

    Free

    Kenneth Ramos
    Written on August 10, 2018
    "Good thing that this tool is written in C# because, in a way, it made me a little bit familiar with the tool's framework. Although I haven't tested this on T-SQL yet, I am sure it will work as smooth as how it was in my SQL."
  2. 5

    #5Rapid Database Extractor

    Rapid Database Extractor

    Rapid Database Extractor is a free software offered to users by IDERA. It is capable of managing Oracle data sources and SQL server and editing SQL code interactively. The software can also export data to common formats.

    Software

    Windows

    Free

    Henry Little
    Written on August 10, 2018
    "I first used this tool in Oracle and when I knew that the extractor also supports SQL, I did not hesitate and think twice about using it to the database I am working on."
  3. 3

    #6dbForge SQL Complete

    dbForge SQL Complete

    dbForge SQL Complete is an SQL Server Management Studio and Visual Studio add-in which helps for speeding up of SQL code writing. It also provides context-based smart suggestions, automatic formatting and refactoring, and more.

    Software

    Windows

    $199.95- Free trial available

    Jack Sims
    Written on August 10, 2018
    "I would like to give this 5 stars only if this tool is free. LOL. But even if this is a paid one, I think the price justifies dbForge's functions. I think its just fair, but I'll just give them 4 stars because of this. "
  4. 2

    #7SoftTree SQL Assistant

    SoftTree SQL Assistant

    SoftTree SQL Assistant is a software being offered by SoftTree Technologies. It's a database development for Oracle, SQL Server, MySQL, and more. The software offers a 14-day trial and is compatible with Microsoft Windows operating systems.

    Software

    Windows

    $214.56- Varies by plan

    Jane Boyd
    Written on August 10, 2018
    "Has anyone already tried this? My free trial was already over but I didn't got the chance to try this because I was too busy and bad luck hit me when my computer got a virus. :( so I am hoping for your feedback guys. Thanks! :*"
  5. 1

    #8RazorSQL

    RazorSQL

    RazorSQL is a software compatible for computers running Microsoft Windows, macOS, and Linux operating systems. It includes an SQL editor and tool for queries, and a database administration tool and browser.

    Software

    Windows, Mac, Linux

    $99.95- Varies by plan

    Pranav Chauhan
    Written on August 10, 2018
    "For a coder like me who uses a Mac operating system, I think this is the best editing tool for SQL. I don't know if this is just for me or there are others that also agree with me. Again, for me, this tool is the best one for Mac users."
  6. 1

    #9SQLinForm

    SQLinForm

    SQLinForm is a SQL formatting software for professionals. This can format plain SQL, and even those embedded in program codes. It will also enable you to control more than 100 formatting options. 

    Software

    Windows

    Varies by plan

    Guido Thelen
    Written on July 17, 2019
    "It has many optipns and a great Notepad++ plugin with code folding feature and supports many databases. It formats SQL snippets and SQL with syntax errors."

Summary

Best What are the best SQL formatting tools
RankSolutionsTypeVotesPrice
1ApexSQL RefactorSoftware 14 Free
2Atom BeautifySoftware 9 Free
3FSQLFSoftware 8 Free
4Poor Man's T-SQL FormatterSoftware 8 Free
5Rapid Database ExtractorSoftware 5 Free
6dbForge SQL CompleteSoftware 3 Paid
7SoftTree SQL AssistantSoftware 2 Paid
8RazorSQLSoftware 1 Paid
9SQLinFormSoftware 1 Paid
Close

This action requires you to be logged in

Quickly sign in with your social media account:

What interests you most? (Select at least 3)

This will help us to keep things fresh and relevant!

Close

Now that you’ve found a solution...

Why not join our community of sharp minds and pro-active posters?

Be part of a rewarding interactive knowledge exchange!
Close

Join These Inquisitive Minds

Engage, learn and share with a friendly community versed in a massive range of trending topics.