Why this SQL INSERT generator?
- Generate Postgres/MySQL/SQLite INSERTs from a schema.
- Preview 20 lines and export .sql.
- Seeded mode enables reproducible test data.
- Share settings only—no SQL in URLs.
Quick presets
Load a preset table to start quickly.
Generate
Random SQL INSERT generator
Define a table schema, then generate INSERT statements as SQL.
Dialect notes
- Identifiers can be quoted with "" (Postgres/SQLite) or backticks (MySQL).
- Boolean literals are output as TRUE/FALSE.
- Timestamps are emitted as 'YYYY-MM-DD HH:MM:SS'.
How to use Random SQL INSERT Generator well
Start by fixing the table name, SQL dialect, and row count. Once that baseline looks right, adjust one option at a time so you can tell whether changes come from insert mode, quoting, or random generation.
Choose the table shape first
Define column names and data types before you worry about file size. The preview is most useful when the schema already matches the table you expect to import.
Pick the INSERT mode for your next step
Use multi-row INSERTs when you want smaller files and faster imports. Use single-row INSERTs when you need clearer diffs, line-by-line debugging, or compatibility with stricter loaders.
Decide quoting and seeded mode deliberately
Turn on quoted table and column names when your schema uses reserved words, mixed case, or dashes. Use seeded mode only when you need reproducible test fixtures; secure mode is better for less predictable samples.
Preview before you export
- Check a few preview lines before generating a large file.
- Confirm timestamp ranges, enum values, and escaping rules in the chosen dialect.
- Remember that share URLs keep settings only and never include the generated SQL output.
See also
FAQ
Is my data uploaded?
No. Everything runs locally in your browser.
What does quote table/column names do?
It wraps table and column names in quotes so reserved words, mixed case, or dashes are handled correctly.
Is seeded mode secure?
No. Seeded mode is for reproducibility only.
When should I use multi-row vs single-row INSERT mode?
Use multi-row when you want smaller files and faster imports. Use single-row when you need easier diffs, line-by-line debugging, or compatibility with a loader that expects one INSERT per row.
What is included in the share URL?
The share URL stores settings only, such as dialect, row counts, schema, and optional seed flags. It never includes generated SQL output.