Free Online SQL Formatter

Q: Is the Online SQL Formatter free?

Yes, the SQLinForm Online SQL Formatter is completely free to use. You can format unlimited SQL statements without registration or payment. A Pro version with additional features is available for the desktop plugins.

Q: Is my SQL code secure? Do you store my data?

Your SQL never leaves your computer. The formatter runs entirely in your browser using WebAssembly technology. No data is sent to any server, and nothing is stored. Your code remains 100% private.

Q: Which databases are supported?

SQLinForm supports all major databases including Oracle, SQL Server, MySQL, PostgreSQL, DB2, SQLite, Redshift, Sybase, Access, and MDX. The formatter automatically recognizes database-specific syntax.

Q: What formatting options are available?

SQLinForm offers over 200 formatting options including: indentation settings, keyword case conversion (UPPER/lower/Capitalized), alignment styles (River Style, Axis Style), comment handling, line breaks, and specialized options for SELECT, JOIN, WHERE, INSERT, UPDATE, and stored procedures.

Q: Can I use SQLinForm in my IDE or editor?

Yes! SQLinForm is available as a plugin for Notepad++, Visual Studio Code, Visual Studio 2022-2026, SQL Server Management Studio (SSMS), and DBeaver. All plugins share the same powerful formatting engine with 200+ options.

Q: What is the difference between Free and Pro?

The free version includes all essential formatting options. The Pro version adds advanced features like team formatting profiles, additional alignment options, source code extraction/generation, and priority support.

General

Upper/Lower

Alignment

Comments

Whitespaces

Output

SQL

Select

Subselect

JOIN

Ins/Upd/Del

Merge

Lists

My Lists

Conditions

Analytics

CASE

ANSI DDL

IF THEN ELSE

Extract & Generate

▼

General Options

ID033

Your Database

ID002

General Number of Spaces for Indention

ID005

Select the indention for SELECT, UPDATE, DELETE, INSERT Master Keywords. If you choose 'Use General Number of Spaces for Indention' then the Values specified for ID003 (next setting) will be taken.

ID071

Use the Backslash Character as Escape Character

ID018

Decimal Point is Comma. In some regions the comma is used as decimal point. This option helps to avoid unwanted linebreaks in decimal numbers.

ID160

Statement Delimiter Character

ID007

Quote Character

▼

Upper/Lower Keywords

Lower/Upper Case Options

ID157

Select CASE for complete SQL Statement. If UPPER or LOWER is selected, it overrides the selection for Keywords and non-Keywords.

ID003

Select CASE for Keywords.

ID158

Select CASE for Non-Keywords.

My Lower/Upper Case Keywords

ID113

My Lower/Upper Case Keywords. Add One Keyword per Line for Lower/Upper Case Formatting

▼

Alignment

Comma Alignment

ID066

Align Commas

Alias Alignment

ID049

Align ALIAS

Equal Sign & Operators

ID073

Align ALIAS at the Position specified in the next Option ID074. If this option is not selected, the ALIAS position will be calculated dynamically.

ID074

Specify Position to align ALIAS. (see previous option ID073)

ID031

Align Equal Signs ( '=', '==', '<', '>', etc. )

ID032

Align Operators ( '+', '-', '*', ... )

ID060

Align '||' Concat Operator

▼

Comments

Line Comments

ID076

Add Linebreak Before Line Comments

Block Comments

ID077

Add Linebreak Before/After Block Comments

ID050

Align Line Comments

ID115

Align Block Comments

ID116

Indent Line Comments

ID057

Convert Line Comments into Block Comments

ID154

Convert Block Comments into Line Comments

Delete Comments

ID035

Delete Comments

▼

White Spaces

White Spaces Options

ID040

White Spaces Around Commas

ID036

White Spaces Around Brackets

ID045

White Spaces Around Operators

ID072

Keep Blank Lines

Shift Complete SQL Statement by Spaces

ID070

Shift SQL by this Amount of Spaces

▼

Output Format

NO-FORMATTING Sections

ID105

No Formatting between '-- FORMAT_OFF' (iD106) and '-- FORMAT_ON' (iD107)

ID106

Specify the String to indicate the Start of the Non-Formatting Section. Prefix the String in your SQL with '-- ' to activate this option. Example: '-- FORMAT_OFF'. The Formatter will ignore all SQL Code until it finds the FORMAT_ON String (iD107). You can specify the string also at the line end of your SQL Statement.

ID107

Specify the String to indicate the End of the Non-Formatting Section. Prefix the String in your SQL with '-- ' to activate this option. Example: '-- FORMAT_ON'

Line Length

ID022

▼

SQL

Small SQL Linebreaks (Pro)

ID027

No Linebreak for SQL Statements smaller than this number of characters

Align Master Keywords (Pro)

ID034

Right-Justify Keywords

Linebreak Delimiter (Pro)

ID152

Linebreak Before Statement Delimiter

▼

SELECT

ID148

Linebreak After SELECT

▼

FROM

ID182

Linebreak Before FROM

ID143

Linebreak After FROM

▼

INTO

ID185

Linebreak Before INTO

ID159

Linebreak After INTO

▼

WHERE

ID183

Linebreak Before WHERE

ID142

Linebreak After WHERE

WHERE Condition

ID172

Linebreak Before AND/OR in WHERE Condition

ID173

Linebreak After AND/OR in WHERE Condition

ID174

Indent AND/OR in WHERE Condition

▼

HAVING

ID184

Linebreak Before HAVING

ID153

Linebreak After HAVING

HAVING Condition

ID175

Linebreak Before AND/OR in HAVING Condition

ID176

Linebreak After AND/OR in HAVING Condition

ID177

Indent AND/OR in HAVING Condition

▼

GROUP BY

ID186

Linebreak Before GROUP BY

ID145

Linebreak After GROUP BY

ID135

Stack GROUP BY

▼

ORDER BY

ID187

Linebreak Before ORDER BY

ID144

Linebreak After ORDER BY

ID136

Stack ORDER BY

▼

Sub-Select & CTE

Sub-SELECT Brackets

ID087

Linebreak Before Open '('

ID016

Linebreak After Open '('

ID089

Linebreak Before Close ')'

ID090

Linebreak After Close ')'

Indent Sub-SELECT Statement

ID028

Indent Sub-SELECT Statement

▼

JOIN

JOIN Statement

ID063

Linebreak Before JOIN

ID146

Linebreak After JOIN

ID068

Indent JOIN Statement

ON Condition

ID062

Linebreak Before ON

ID147

Linebreak After ON

ID131

Indent ON Condition

JOIN Condition

ID178

Linebreak Before AND/OR in JOIN Condition

ID179

Linebreak After AND/OR in JOIN Condition

ID180

Indent AND/OR in JOIN Condition

▼

INSERT

INSERT Brackets

ID108

Linebreak Before '('

ID109

Linebreak After '('

ID110

Linebreak Before ')'

ID111

Linebreak After ')'

Columns and Values

ID112

Indent Columns and Values

ID149

Number of Columns or Values per Line.

Commas

ID207

Linebreak Before Comma

ID208

Linebreak After Comma

▼

UPDATE, DELETE

UPDATE

ID150

Linebreak After UPDATE

ID209

Linebreak Before Comma

ID210

Linebreak After Comma

ID211

Linebreak Before SET

ID212

Linebreak After SET

DELETE

ID151

Linebreak After DELETE

▼

Comma Separated Lists in SQL Statemets

ID065

Number of Columns per Line

Linebreak After Comma

ID013

Linebreak After Comma

Linebreak Before Comma

ID012

Linebreak Before Comma

ID122

Move Comma 2 Positions to the left with 1 Space (When ID012 'Linebreak Before Comma' has been selected)

ID242

Move Comma 1 Positions to the left with no space (When ID012 'Linebreak Before Comma' has been selected)

ID181

Move Comma to the left border of the SELECT statement (When ID012 'Linebreak Before Comma' has been selected)

Concat Operator ('||')

ID098

Linebreak Before Concat ('||')

ID059

Linebreak After Concat ('||')

▼

My List for SQL Functions 1

ID194

My SQL Function Keywords GROUP 1. Add One Keyword per Line. Cols / Value Lists inside the SQL Function Brackets will get Linebreaks

ID196

Number of Values in 1st Line

ID197

Number of Values in subsequent Lines

ID225

Linebreak Before (

ID228

Linebreak After (

ID198

Align Commas

ID231

Indent Values inside Bracket

▶

My List for SQL Functions 2

ID199

My SQL Function Keywords GROUP 2. Add One Keyword per Line. Cols / Value Lists inside the SQL Function Brackets will get Linebreaks

ID200

Number of Values in 1st Line

ID201

Number of Values in subsequent Lines

ID226

Linebreak Before (

ID229

Linebreak After (

ID202

Align Commas

ID232

Indent Values inside Bracket

▶

My List for SQL Functions 3

ID203

My SQL Function Keywords GROUP 3. Add One Keyword per Line. Cols / Value Lists inside the SQL Function Brackets will get Linebreaks

ID204

Number of Values in 1st Line

ID205

Number of Values in subsequent Lines

ID227

Linebreak Before (

ID230

Linebreak After (

ID206

Align Commas

ID233

Indent Values inside Bracket

▼

Conditions in Brackets

ID088

Linebreak Before '('

ID017

Linebreak After '('

ID091

Linebreak Before ')'

ID092

Linebreak After ')'

ID069

Indent Conditions in Brackets

▼

Analytic Expressions - OVER

Brackets

ID234

Linebreak Before '('

ID235

Linebreak After '('

ID236

Linebreak Before ')'

ID237

Linebreak After ')'

PARTITION BY / ORDER BY

ID240

Linebreak Before PARTITION BY, ORDER BY,...

ID241

Stack Attributes

Stack & Indenting

ID238

Indent Statement Inside Bracket

ID239

Indent Brackt

▼

CASE Conditions

Brackets

ID117

Linebreak Before '('

ID118

Linebreak After '('

ID119

Linebreak Before ')'

ID120

Linebreak After ')'

AND/OR

ID056

Linebreak Before AND/OR

ID061

Linebreak After AND/OR

▼

Small CASE Statements

ID067

No Linebreak for CASE Statement smaller than this number of characters

▼

IF THEN ELSE

ID037

Linebreak After IF

THEN

ID038

Linebreak Before THEN

ID039

Linebreak After THEN

ELSE

ID041

Linebreak After ELSE

ID024

Indent THEN

ID025

Indent ELSE

▼

Extract SQL from Code

ID021

SQL Enclosing Character. This is the character which envelops the SQL Code in your source code. Mostly this is ". When you want to extract the SQL Code from your Source Code, please use the 'Extract & Format SQL from Source Code' or 'Extract, Format & Generate SQL Code' command

▼

Generate SQL Code

Pre-Defined Programming Language

ID001

Specify the Programming Language in which you want to include your formatted SQL Code. Use the 'Format & Generate Source Code' or 'Extract, Format & Generate Source Code' command. In case you have chosen 'My Output Format' you can define you own language using below variables ID161, ID163, ID164, and ID166.

ID054

Specidy the Variable Name which should be used in the above mentioned Programming Language.

My Output Format - Settings

ID161

Specify the first line of your code preceding the actual SQL statement

ID163

Specify the code envelopping your SQL on the left side

ID164

Specify the code envelopping your SQL on the right side

ID166

Specify the code envelopping your SQL on the right side for the last line

Input SQL

Formatted Output

General Options

Upper/Lower Keywords

Alignment

Comments

White Spaces

Output Format

SQL

SELECT

FROM

INTO

WHERE

HAVING

GROUP BY

ORDER BY

Sub-Select & CTE

JOIN

INSERT

UPDATE, DELETE

MERGE

Comma Separated Lists in SQL Statemets

My List for SQL Functions 1

My List for SQL Functions 2

My List for SQL Functions 3

Conditions in Brackets

Analytic Expressions - OVER

CASE Keywords

CASE Conditions

Small CASE Statements

ANSI DDL

IF THEN ELSE

Extract SQL from Code

Generate SQL Code

Frequently Asked Questions

▶Is the Online SQL Formatter free?

▶Is my SQL code secure? Do you store my data?

▶Which databases are supported?

▶What formatting options are available?

▶Can I use SQLinForm in my IDE or editor?

▶What is the difference between Free and Pro?