SQL Test Data Generator

Generate INSERT statements with realistic fake data for database testing

Schema Builder

Table Settings

Table Name

SQL Dialect

Number of Rows

Batch INSERT

Generated SQL

Generated SQL will appear here

Generate SQL INSERT statements with realistic fake data. Supports MySQL, PostgreSQL, SQLite, and SQL Server dialects with batch insert syntax.

MySQL, PostgreSQL, SQLite, and SQL Server. Each dialect uses appropriate syntax for quotes, types, and batch inserts.

Yes, select "Auto Increment" as the data type for a column. The generator will produce sequential integers starting from 1.

Check the "Nullable" option for columns that can have NULL values. About 10% of values will randomly be NULL.