Skip to content

SQL Formatter

Runs in your browser

Paste a query to indent it clause by clause, or pack it onto one line. Ten SQL dialects, and your queries never leave the tab.

Options

Input

Output

Formatting…

How this one works

Paste a query on the left and the formatted version appears on the right as you type. Each clause — SELECT, FROM, JOIN, WHERE, GROUP BY — starts on its own line, with its columns and conditions indented beneath it. Pick your database from the dialect menu so its own syntax, quoting and keywords are recognised.

Minify does the opposite: one line, comments removed, and string literals kept exactly as written — handy for pasting a query into code, a log search or a config file.

Questions

Is it safe to paste production queries here?
Yes. Formatting happens in your browser with JavaScript bundled into the page — the query is never sent to a server, logged or stored. Close the tab and it’s gone.
Which SQL dialects are supported?
Standard SQL, MySQL, MariaDB, PostgreSQL, SQLite, SQL Server (T-SQL), Oracle (PL/SQL), BigQuery, Redshift and Snowflake. Choosing the right one matters for things like backtick or bracket identifiers, dollar-quoted strings and dialect-specific keywords.
Does formatting change what my query does?
No. Only whitespace, line breaks and (if you choose) the case of keywords change. Table names, column names and string values are left exactly as you wrote them.

Keyboard shortcuts

Global

  • Show this shortcuts dialogShift?
  • Toggle light / dark themeCtrlShiftL
  • Close dialogsEsc

Formatter & Validator

  • Format JSONCtrlEnter
  • Minify JSONCtrlShiftM
  • Copy outputCtrlShiftC
  • Download output as .jsonCtrlShiftS
  • Clear input and outputCtrlShiftX

Tree Viewer

  • Focus the search box/
  • Expand all nodesCtrlShiftE
  • Collapse all nodesCtrlShiftR

Diff

  • Swap document A and BCtrlShiftS

JSON tools

JSON FormatterPretty-print or minify
JSON ValidatorCheck strict JSON validity
JSON Tree ViewerBrowse JSON as a tree
JSON DiffCompare two documents
JSON Path FinderExplore JSONPath expressions
JSON → CSVFlatten JSON into rows
CSV → JSONTurn rows back into objects

JWT tools

JWT DecoderRead header, payload, claims
JWT VerifierCheck an HMAC signature
JWT Expiry Checkeriat, nbf and exp in local time
JWT GeneratorBuild a signed test token
Base64URL EncoderEncode or decode a segment

Code formatters

SQL FormatterBeautify or minify SQL
HTML FormatterBeautify or minify HTML
CSS FormatterBeautify or minify CSS
JavaScript FormatterBeautify or minify JS
Markdown to HTMLConvert with a live preview

Pages

JSON toolsFormat, validate, compare and convert JSON.
JWT toolsDecode, verify and generate JSON Web Tokens.
Code formattersBeautify and minify SQL, HTML, CSS and JavaScript.
HomePopular tools and categories
All categoriesBrowse tools by category
AboutWhat ToolJar is and why
PrivacyWhat is and is not collected

Theme

Switch to light theme
Switch to dark theme