Format your SQL!

Paste one-line SQL or a MyBatis log to get it line-broken and indented, with real values filled into the ? placeholders!
params
input
result
 

Format your SQL!

Paste one-line SQL or a MyBatis log to get it line-broken and indented, with real values filled into the ? placeholders!

Use Cases

- Read SQL from logs - Splits a long one-line query into SELECT, FROM and WHERE blocks. - Run MyBatis/JDBC logs as-is - Fills the ? in "Preparing:" with the "Parameters:" values by type (strings quoted, numbers as-is) so you can run the query directly. - Paste into code or docs - Normalize keyword case and indentation, or squeeze the query into one line for a code string.