WerklyTools
Esc
↑↓ navigate↵ open
EN
Buy me a coffee

SQL formatter

Turn a one-line SQL query into clear code with every clause in its place. Choose the dialect, indentation and keyword style. Everything in your browser.

Processed 100% in your browser

Output

Ctrl + Enter runCtrl + C copy result

How to use

  1. 1Paste your SQL query.
  2. 2Pick your database dialect.
  3. 3Adjust keyword casing and indentation.
  4. 4Copy or download the result, or switch to Minify for a single line.

Use cases

  • Understand long queries copied from logs or ORMs.
  • Standardize query style across a team.
  • Prepare readable SQL for documentation or reviews.
  • Minify a query to paste into a command line.

Frequently asked questions

Which dialects are supported?

Standard SQL, PostgreSQL, MySQL, MariaDB, SQLite, SQL Server (T-SQL), Oracle (PL/SQL) and BigQuery.

Does it change what my query does?

No. It only changes whitespace, line breaks and, if you choose, keyword capitalization.

Is my SQL sent to a server?

No. Formatting runs in your browser, so you can paste sensitive queries safely.

What does Minify do?

It removes comments and extra whitespace to put the query on one line.

Related tools

Base64 encoder and decoderConvert text or any file to Base64 and back. Supports the URL-safe variant, line breaks and data URI prefixes, and detects when decoded content is binary.
Code to imageCreate attractive code screenshots for social media, slides, blogs or documentation. Paste your code, pick a language, theme and background, and download a crisp PNG or a scalable SVG.
CSS minifier and beautifierShrink your stylesheets by removing comments, whitespace and empty rules, or do the opposite: turn minified CSS into readable, indented code. You will see the original size, the final size and the gzipped size.
JavaScript minifier and beautifierCompress your JS by stripping comments and whitespace and shortening names, or format a minified script so it is readable. Powered by Terser, right in your browser.
JSON formatter and validatorPaste your JSON to validate it, pretty-print it or minify it. If there is a syntax error, you will see exactly which line and column it is on.
Mock data generatorCreate fictional datasets to test your app, fill a database or prepare a demo. Define the fields, the number of rows and the output format.