SQL formatter

Format SQL for a selected dialect while keeping comments and placeholders.

Privacy: runs in your browser

This tool processes your input in this browser. Inputs and results are excluded from analytics. Recent tools save tool names, visit counts and last-visit times. Favorites store only tool names. Draft saving is optional and stays on this device; delete saved text with the draft controls. Loading text from a URL is optional and contacts that server; its URL and your IP address are visible to the server. When a button sends your result to another tool, it waits in this tab until that tool opens it, for up to a minute, and is then deleted.

Copy link includes the inputs you choose to share in the address. Anyone with that link can reopen them. Files and generated results are excluded. Password and key tools share settings only.

Your result

 

Save a draft on this device

Draft saving is off. Nothing is uploaded.

More
Keyboard shortcuts

Sharing and starting over

A copied link includes what you entered and your settings, so anyone with it can see them. Leave private text out. Files and results are not included; random draws are made again.

Start over puts the tool back to its starting values and closes any open file or device. Drafts you saved stay on this device until you delete them.

Choose the database dialect first

SQL dialects differ. Select the dialect that matches your query, then choose keyword case and indentation. Formatting rearranges whitespace; it does not run the query or connect to a database.

Next: JSON formatter

Worked example

select id,name from octopus_tools where active=true becomes a multiline query with SELECT, FROM and WHERE sections when uppercase keywords are selected.

Before you rely on the result

A neatly formatted query may still fail on your database. This is not a SQL validator or optimizer. Review vendor-specific syntax and placeholders before replacing the original.

Cite this page

ToolOctopus. “SQL formatter.” Updated . https://tooloctopus.com/sql-formatter.

Add an access date if your instructions require one.

Citation formatting uses citeproc-js by Frank Bennett and Citation Style Language styles. License and source code.

Find a tool

Type a task, a unit pair, a sum or a time zone. ↓ to choose, Enter to open.