uroborosql-fmt

Japanese

Enter the SQL source you want to format in the left editor and press the 'format' button, the result of the formatting will be displayed in the right box.

Supports

Option (detail)
Column names are auto-completed with the same name
e.g. COL1 → COL1 AS COL1
e.g. /* foo */ → /*foo*/
e.g. LEFT JOIN → LEFT OUTER JOIN
e.g. SELECT COLUMN1 COL1 → SELECT COLUMN1 AS COL1
e.g. FROM TABLE1 AS TBL1 → FROM TABLE1 TBL1
e.g. (((1 = 1))) → (1 = 1)
e.g. SELECT COL1 → SELECT /* _SQL_ID_ */ COL1
e.g. SELECT ''::JSONB → SELECT CAST('' AS JSONB)
e.g. STUDENT_ID <> 2 → STUDENT_ID != 2
tab size: Tab size used for formatting
case of keyword: upper: unify upper case
lower: unify lower case
preserve: preserve original case
case of table name and column name: upper: unify upper case
lower: unify lower case
preserve: preserve original case
max number of characters per line: If the total number of characters in the function name and arguments exceeds this number, the arguments are formatted with new lines
Ctrl+Shift+F