How to Use the SQL Formatter Basic: Steps and a Worked Example

By 1 min read

Put each main SQL clause on its own line to make a query easier to read. This guide shows what to enter, a worked example, and the limits to keep in mind. The SQL Formatter Basic tool is free, needs no account and runs in your browser.

What you need

  • SQL

Step by step

  1. Open the SQL Formatter Basic tool.
  2. Fill in SQL.
  3. Read the result, which updates as soon as the inputs change.

Worked example

the tool returns:

select id, name
from users
where active = 1
and role = 'admin'
order by name
limit 10

How it works

Paste a query. SELECT, FROM, WHERE, JOIN, GROUP BY, ORDER BY, LIMIT, AND and OR start new lines.

Things to keep in mind

Check your inputs, units and any local rules before you rely on the result.

If this is not quite what you need, try JavaScript Formatter Basic, JSON Formatter or CSS Formatter.

More from the blog