MyBatis SQL Restore
Restore MyBatis log placeholders and parameters into complete, formatted SQL
Usage
Paste the Preparing and Parameters lines from the same MyBatis DEBUG log, choose a database dialect (auto-detect by default) and run. The tool first validates log structure and SQL syntax, then restores parameters and formats the result in standard vertical style. Incomplete logs, broken syntax or multiple log segments only return clear errors without output. Supports MySQL, Oracle, PostgreSQL, SQL Server, SQLite and standard SQL, with a 500KB log limit. All processing runs locally in your browser.
FAQ
- 1.
Which MyBatis log lines are required?
Copy the Preparing and Parameters lines from the same execution. Only one log segment is supported per run; split multiple segments before pasting.
- 2.
What if the log looks complete but syntax validation fails?
Check that the Preparing line is not truncated and that the selected database dialect matches your database. The tool refuses output when the log is incomplete or the dialect is wrong.
- 3.
What if a string parameter contains commas or quotes?
A comma-containing value with a type suffix remains one parameter, and single quotes are escaped using SQL string rules.
- 4.
Which database dialects are supported?
Auto detection plus MySQL, Oracle, PostgreSQL, SQL Server, SQLite and standard SQL.