SQL INSERT Generator

Your data never leaves your browser

Generate SQL INSERT statements with random test data from column definitions.

Brie — Bug Reporting Tool

Found a bug while testing?

Brie captures screenshots, console logs, network data, and session replays in one click — so developers get the full context without the back-and-forth.

Install Brie — It's FreeLearn more →

About SQL INSERT Generator

Define your table columns in the format "column_name:type" — one per line — and instantly get complete SQL INSERT statements populated with realistic random data. Supported column types are string, number, boolean, date, email, and uuid. Set the table name and the number of rows to generate, and the tool produces ready-to-run SQL that you can paste directly into your database client or test fixtures. Ideal for seeding development databases, writing integration tests, and generating data migration scripts.

How to use

  1. Enter column definitions in the input panel, one per line, using the format "column_name:type" (e.g. "email:email").
  2. Set the table name using the "Table Name" option.
  3. Set the number of rows to generate using the "Row Count" option.
  4. Copy the generated INSERT statements from the output panel.

More QA & Testing Tools

Fake User Data Generator

Generate realistic fake user profiles with names, emails, addresses, and more.

UUID Generator

Generate random UUIDs (v4) for unique identifiers.

Test Email Generator

Generate batches of valid-format test email addresses in random, sequential, or plus-tag patterns.

Frequently Asked Questions

FAQs about SQL INSERT Generator

Which column types are supported?

Six types are supported: string (generates a random full name), number (random integer), boolean (TRUE or FALSE), date (random date between 2020 and 2025), email (realistic firstname.lastname@domain address), and uuid (random version 4 UUID).

How should I format column definitions?

Each line must follow the "column_name:type" format, for example "user_id:number" or "created_at:date". Column names are sanitised — spaces and special characters are replaced with underscores.

What SQL dialect does the output use?

The output uses standard SQL syntax compatible with PostgreSQL, MySQL, and SQLite. String values are single-quoted, boolean values use TRUE/FALSE literals, and dates are formatted as YYYY-MM-DD.

Can I generate INSERT statements for multiple tables?

The tool generates statements for one table per run. To generate data for multiple tables, run the tool once per table with the appropriate column definitions and table name.

How many rows can I generate at once?

You can generate up to 50 rows per run to keep the output manageable. For larger datasets, run the generator multiple times and combine the output.