SQL INSERT generator
Create escaped SQL INSERT statements from JSON.
SQL INSERT generator
Type or paste to update the result automatically.
Your result appears here
Type, paste, or use an example. Copy your result when it is ready.
如何使用SQL INSERT generator
SQL INSERT generator turns a JSON array of objects into one multi-row INSERT statement with escaped values. Column names come from all object keys and are quoted for PostgreSQL or MySQL. Strings are single-quoted with quotes doubled, null becomes NULL, booleans become TRUE or FALSE, and nested values are stored as JSON text.
- Type or paste your source, or load an example.
- Change the basic settings or open Advanced mode to fine-tune the result.
- Review and copy or download your result. Pause Live results to run manually. Sources or individual settings above 20,000 characters require an explicit run.
工具功能
Create escaped SQL INSERT statements from JSON.
- Table name
- Set this value for your task.
- Identifier quoting
- postgresql · mysql
限制与处理方式
Text operations generally accept up to 2,000,000 characters. Individual parsers, generators and formulas apply additional limits shown by their controls.
输入示例
[{"name":"ToolCabana","count":2},{"name":"Example","count":3}]常见问题
How do I generate SQL INSERT statements from JSON?
Paste a JSON array of objects, enter the table name and choose PostgreSQL or MySQL identifier quoting. The output is a single INSERT INTO statement with one VALUES row per object.
How are missing JSON keys handled in the INSERT?
Every key found in any object becomes a column. When an object lacks a key, NULL is written for that column in its row.
Why is my table name rejected?
The table name must be a simple identifier: letters, digits and underscores, starting with a letter or underscore. Schema-qualified names with a dot are not accepted.
Where is my input processed?
This operation processes its source in your browser. Copy and download are explicit actions; source input is not saved in an account or history.
What are the input limits?
Text operations generally accept up to 2,000,000 characters. Individual parsers, generators and formulas apply additional limits shown by their controls.