BenKitSQL Formatter & Generator.
Format queries, build safe value lists, and turn JSON rows into INSERT statements.
Ready when you are.
No SQL generated
Three small SQL chores. One place.
Clean up a query using its actual dialect, turn copied IDs into a quoted IN clause, or paste JSON rows to generate a multi-row INSERT statement. Strings are escaped with doubled single quotes.
The formatter understands common SQL dialects and preserves comments. It keeps MyBatis #{name} placeholders and places each [queryName] query on its own block. Formatting does not repair SQL syntax. Generated INSERT statements use dialect-appropriate identifier quoting and fill missing object fields with NULL.
Want to understand a query's tables and fields? Open SQL Analyzer →
Good to know
Does this run my query?
No. This page only transforms text in your browser. It never connects to a database or checks your schema.
Which SQL dialects are supported?
Standard SQL, PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, BigQuery, Snowflake, Oracle PL/SQL, DuckDB, Spark SQL, and Trino.
Should I review generated SQL?
Yes. Check table names, column order, data types, and permissions before running generated statements against a database.