Generator Settings
SQL dialect
MySQL / MariaDB
PostgreSQL
SQLite
SQL Server
Oracle
Table name
Start from a template
Users
Products
Orders
Posts
Empty schema
Rows
Seed
Columns
Add column
Statement style
Multi-row INSERT (fastest)
One INSERT per row
Upsert / ON CONFLICT
Insert ignoring duplicates
Rows per statement
100
500
1000
All in one statement
Very large single statements can exceed packet or parameter limits. 500–1000 rows per batch is a safe default.
Include
CREATE TABLE statement
Column types inferred from the field types you chose.
DROP TABLE IF EXISTS
Makes the script re-runnable. Destructive — read before executing.
Wrap in a transaction
All rows land, or none do.
Quote identifiers
Required if a column name collides with a reserved word.
Generated SQL
SQL
Schema
Dialect notes
seed.sql
Copy
Download