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

Align Token

Output

Comments

Whitespaces

SQL

Select

Subselect/CTE

JOIN

Ins/Upd/Del

Merge

Lists

My Lists

Conditions

Analytics

CASE

ANSI DDL

Extract & Generate

Invisible

▼

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 ID002 (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

▼

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

Line Length

▼

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

▼

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

Align & Indent Sub-SELECT Statement

ID255

Align Subquery to Opening Bracket

ID028

Indent Sub-SELECT Statement

Sub-SELECT Brackets

ID087

Linebreak Before Open '('

ID016

Linebreak After Open '('

ID089

Linebreak Before Close ')'

ID090

Linebreak After Close ')'

▼

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 ('||')

ID058

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

▼

Invisible

ID000

RELEASE_GUI

ID004

GEN_NBR_SP_TAB

ID006

EDIT_DEL_SPACES

ID008

IND_DOUBLEMASTERKEYWORD

ID009

GEN_ALWAYS_EXTRACT

ID010

GEN_ALWAYS_GENERATE

ID011

LB_DOUBLEUNION

ID014

LBB_AND

ID015

LBA_AND

ID019

EDIT_GENERATE_CODE

ID020

SRCE_IS_ENCLOSED

ID023

COLOR_SQL

ID029

EDIT_USE_TABS_INDENT

ID030

IND_BEGIN_END

ID051

ALI_DECLARATION

ID064

SP_LB_NBR_COMMASPERLINE

ID075

WHSP_NONE_SQUARE_BRACKET

ID078

SP_LBB_COMMA

ID079

SP_LBA_COMMA

ID080

LB_NBR_COMMASINLIST

ID081

EDIT_REPL_HOSTVARIABLE

ID082

EDIT_REMOVEBRACKETS

ID083

LB_ONELINESQL

ID084

IND_AUTO_1STLINE

ID093

SP_LBB_OPENCONDITIONBR

ID094

SP_LBA_OPENCONDITIONBR

ID097

SP_IND_CONDITIONBR

ID098

SP_LBB_CLOSECONDITIONBR

ID099

SP_LBA_CLOSECONDITIONBR

ID100

SP_LBB_OPENPARMBRACKET

ID101

SP_LBA_OPENPARMBRACKET

ID102

SP_IND_PARMBRACKET

ID103

SP_LBB_CLOSEPARMBRACKET

ID104

SP_LBA_CLOSEPARMBRACKET

ID114

VARIABLETYPES

ID123

WHSP_1AFTERCOMMA

ID124

COLOR_MASTERKEYWORD_RGB

ID125

COLOR_LINECOMMENT_RGB

ID126

COLOR_BLOCKCOMMENT_RGB

ID127

COLOR_CASE_RGB

ID128

COLOR_LITERAL_RGB

ID129

COLOR_RESERVEDWORD_RGB

ID130

COLOR_STRUCTUREKEYWORD_RGB

ID132

COMMENTHOSTVARIABLE

ID133

COLOR_WHITESPACES

ID134

COLOR_IF_RGB

ID137

ALI_ASSOCIATIONOPERATOR

ID138

SP_LBB_HEADER

ID139

SP_ALI_EQUAL

ID140

SP_ALI_ASSIGNMENT

ID141

EDIT_REPL_SINGLEQUOTE

ID155

LBA_SEMIKOLON_DOUBLE

ID156

ALI_JOINON_AND_TO_ON

ID162

FIRSTLINESUFFIX

ID165

LASTLINEPREFIX

ID167

LBB_LASTLINESUFFIX

ID168

DELIMITER2

ID169

DELIMITER3

ID170

NOFORMATWHOLESQL

ID171

COLOR_STANDARD_RGB

ID243

SP_LBB_COMMA_STATEMENT

ID244

SP_LBA_COMMA_STATEMENT

ID245

SP_ALI_MOVE_COMMALEFT_PARM

ID246

SP_ALI_MOVE_COMMALEFTONE_PARM

ID247

SP_ALI_MOVE_COMMALEFT_STMT

ID248

SP_ALI_MOVE_COMMALEFTONE_STMT

ID253

IND_NOFORMAT

ID254

IND_CASE_ANDOR

Input SQL

Formatted Output

General Options

Upper/Lower Keywords

Alignment

Output Format

Comments

White Spaces

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

Invisible

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?