SQL Formatter & Analyzer

SQLinForm puts your SQL in form – and informs you about it. It formats SQL into clean, consistent code and explains SQL you did not write – with the Data Flow Explorer, the Navigator and the Usage Inspector, included in the free version. Your SQL never leaves your computer.

sqlinform 1000x562 7

200+ formatting options

Indentation, alignment, keyword case, line breaks, comments – change any option on the left and format again. For 28 SQL dialects, from Oracle and SQL Server to Snowflake and BigQuery.

Data Flow Explorer NEW

Understand SQL you did not write: query blocks, tables, joins and the path of the data through CTEs, sub-queries and UNIONs as a diagram. Click a box to highlight its lines.

Navigator and Usage Inspector

Tame monster SQL: the Navigator shows its structure as a graph and a searchable tree. The Usage Inspector shows every line in which a name is used – ideal for finding a variable that is declared but never used.

Your SQL stays private

Everything runs locally in your browser with WebAssembly. Your SQL never leaves your computer – no registration, no data collection.

▼

General Options

?
▼

Upper/Lower Keywords

?
Lower/Upper Case Options
My Lower/Upper Case Keywords
▼

Alignment

?
Comma Alignment
Alias Alignment
Equal Sign & Operators
▼

Output Format

?
NO-FORMATTING Sections
Line Length
▼

Comments

?
Line Comments
Block Comments
Delete Comments
▼

White Spaces

?
White Spaces Options
Shift Complete SQL Statement by Spaces
▼

SQL

?
Small SQL Linebreaks (Pro)
Align Master Keywords (Pro)
Linebreak Delimiter (Pro)
▼

SELECT

?
▼

FROM

▼

INTO

▼

WHERE

WHERE
WHERE Condition
▼

HAVING

HAVING
HAVING Condition
▼

GROUP BY

▼

ORDER BY

▼

Sub-Select & CTE

?
Align & Indent Sub-SELECT Statement
Sub-SELECT Brackets
▼

JOIN

?
JOIN Statement
ON Condition
JOIN Condition
▼

INSERT

?
INSERT Brackets
Columns and Values
Commas
▼

UPDATE, DELETE

UPDATE
DELETE
▼

MERGE

?
MERGE
USING
ON
ON Condition
WHEN Condition
THEN
▼

Comma Separated Lists in SQL Statemets

?
Linebreak After Comma
Linebreak Before Comma
Concat Operator ('||')
▼

My List for SQL Functions 1

?
▶

My List for SQL Functions 2

▶

My List for SQL Functions 3

▼

Conditions in Brackets

?
▼

Analytic Expressions - OVER

?
Brackets
PARTITION BY / ORDER BY
Stack & Indenting
▼

CASE Keywords

?
CASE / END
WHEN
THEN
ELSE
▼

CASE Conditions

Brackets
AND/OR
▼

Small CASE Statements

▼

ANSI DDL

?
Linebreak Before Comma
Linebreak After Comma
Brackets
Indenting
My CREATE Keywords
▼

IF THEN ELSE

?
IF
THEN
ELSE
▼

Extract SQL from Code

?
▼

Generate SQL Code

Pre-Defined Programming Language
My Output Format - Settings
▼

Invisible

NEW

Works where you work

Free, in your browser. Nothing to install.

For Windows, macOS and Linux.

IntelliJ IDEA, DataGrip, PyCharm and more.

SSMS 18 to 22, x64 and ARM64.

Visual Studio 2022 and 2026.

x86, x64 and ARM64.

Native plugin with its own view.

The VS Code extension, for Antigravity.

Windows, portable – runs from a USB stick.

Format. Understand. Standardize.

Free in every edition: Data Flow Explorer, Navigator and Usage Inspector are included in the free version of SQLinForm.

Format with 200+ options

From a short query to a stored procedure with thousands of lines: SQLinForm controls indentation, alignment, keyword case, line breaks and comments. A live preview shows every change at once.

See the formatting options

formatsettingpanel 1024x996 5
Npp Dataflow 1024x594 3

Data Flow Explorer NEW

Understand SQL you did not write. The diagram shows every query block with its tables, columns and filters, the joins between the tables, and the path of the data through CTEs, sub-queries and UNIONs. Click a box to select its lines in the editor.

Navigator and Usage Inspector

Tame monster SQL. The Navigator shows your SQL as an overview graph and a searchable tree of statements, sub-queries, CTEs, joins and clauses. Click a node to jump to that part of the code, or export the graph as PDF or SVG.

The Usage Inspector lists every line in which a table, column or variable is used.

navigator2 3
shareprofiles 3

One style for the whole team

Save your style in up to 5 profiles. All SQLinForm products on your computer use the same profiles, and a Team Folder gives your whole team the same coding standard. How profile sharing works

28

SQL dialects

200+

formatting options

12

languages of the user interface

100%

local – no upload

More reasons to use SQLinForm

Fault-tolerant parser

Formats partial statements and SQL with syntax errors, and helps you find a missing bracket or comma.

SQL in program code

Extracts SQL from Java, C#, PHP or VB strings and generates the code again after formatting.

Private by design

SQLinForm works offline. Your SQL never leaves your computer, and no database driver is needed.

One license, all devices

The Single User License covers all your computers and all SQLinForm products.

Free analyzer tools

Data Flow Explorer, Navigator and Usage Inspector are included in the free version.

28 SQL dialects

Choose your database in the option Your Database, and its specific syntax is formatted correctly.

  • ANSI SQL
  • Athena
  • Aurora
  • Azure SQL
  • BigQuery
  • ClickHouse
  • Databricks SQL
  • DB2 (z/OS & UDB)
  • DuckDB
  • Greenplum
  • Informix
  • MariaDB
  • MS Access
  • MySQL
  • Netezza
  • Oracle
  • PostgreSQL
  • Presto
  • Redshift
  • SAP HANA
  • Snowflake
  • SQL Server
  • SQLite
  • Sybase
  • Teradata
  • Trino
  • Vertica
  • Yellowbrick

Free or Pro?

Free

Pro

To upgrade, enter your license in the License tab. There is nothing to reinstall.

FAQ

A tool that rearranges SQL code into a readable, consistent layout – without changing what the code does.

28 SQL dialects, including Oracle, SQL Server, MySQL, PostgreSQL, DB2, Snowflake, BigQuery and Redshift.

VS Code, the JetBrains IDEs, SSMS, Visual Studio, Notepad++, DBeaver and Antigravity. There is also a desktop app for Windows and the online formatter.

No. All products work locally. The online formatter runs in your browser with WebAssembly.