How to Use
- Step 1
Enter or select the SQL text required by SQL Formatter
- Step 2
Use the clause line breaks, indentation cleanup,
Use the clause line breaks, indentation cleanup, copyable formatted sql controls that apply to this task.
- Step 3
Run SQL Formatter and inspect the displayed Formatted
Run SQL Formatter and inspect the displayed Formatted SQL text result.
- Step 4
Copy or download the Formatted SQL text only when
Copy or download the Formatted SQL text only when the current workspace provides that action.
About, Features and Practical Uses
What You Can Do
Clause line breaks
SQL Formatter accepts SQL text as its documented input.
Indentation cleanup
The current SQL Formatter implementation produces Formatted SQL text.
Copyable formatted SQL
Formatting is a lightweight textual transformation and does not connect to or validate against a database engine.
Practical Use Cases
SQL Formatter workflow
Use SQL Formatter when you need to adds readable line breaks and indentation around common SQL clauses and tokens.
Result preparation
Create a reviewable Formatted SQL text result while retaining the original SQL text.
How It Works
Formatting is a lightweight textual transformation and does not connect to or validate against a database engine.
Worked Example
Reformat a long SELECT statement before reviewing its JOIN and WHERE clauses.
Helpful Tips
- Keep a copy of the original SQL text while using SQL Formatter.
- Validate the Formatted SQL text in its intended destination context.
Privacy, Formats and Limitations
Privacy and File Processing
Sql Formatter processes SQL text on this device and creates Formatted SQL text for preview or download. Selected file bytes and entered values are not sent to the GXA Toolbox application server by this tool. Where account history is enabled, signed-in operations can save filenames, tool name, size and status to your account.
Supported Inputs and Outputs
Input
- SQL text
Output
- Formatted SQL text
Quality and Fidelity
Formatting is a lightweight textual transformation and does not connect to or validate against a database engine.
Limitations and Important Notes
- Dialect-specific syntax may require manual adjustment.
- It does not prove that a query is safe or executable.
Frequently Asked Questions
Does SQL Formatter execute on the application server?
No. The current SQL Formatter operation runs in the browser.
Is the SQL Formatter transformation always reversible?
Not necessarily. Dialect-specific syntax may require manual adjustment.
What should I verify after using SQL Formatter?
Formatting is a lightweight textual transformation and does not connect to or validate against a database engine.