How to Use the SQL Formatter Basic: Steps and a Worked Example
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
- Open the SQL Formatter Basic tool.
- Fill in SQL.
- 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.
Related tools
If this is not quite what you need, try JavaScript Formatter Basic, JSON Formatter or CSS Formatter.