Developer Tools

SQL Formatter Basic with Worked Examples

Put each main SQL clause on its own line to make a query easier to read. Enter sql and read the result straight away. “select id, name from users where active = 1 order by name” is split into lines starting with select, from, where and order by.

01

Your inputs

Start with the example, or enter your own values.

Processed in your browser. Your inputs stay on this device.

02

Your result

A little clarity, coming right up.

Make room for the answer.

Enter your values and run the tool. Your result will appear here.

How to use the SQL Formatter Basic

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

Examples

  • With the default values
    select id, name 
    from users 
    where active = 1 
    and role = 'admin' 

Limitations and assumptions

Confirm assumptions, units and applicable local rules before relying on results. Detailed content, accessibility and edge-case review remains ongoing.

Frequently asked questions

What does the SQL Formatter Basic do?

Put each main SQL clause on its own line to make a query easier to read.

How does the SQL Formatter Basic work?

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

What should I keep in mind when using the SQL Formatter Basic?

Confirm assumptions, units and applicable local rules before relying on results.

Can I see an example of the SQL Formatter Basic?

“select id, name from users where active = 1 order by name” is split into lines starting with select, from, where and order by.

Is the SQL Formatter Basic free to use?

Yes. It is free, needs no account and runs in your browser.