SQL Test Data Generator
Automatically generate bulk INSERT test data based on table structure (DDL), supports MySQL, PostgreSQL, SQL Server, etc.
Input Table Structure (DDL Create Table)
Documentation
What is SQL Test Data Generator?
SQL Test Data Generator is a multi-database tool that automatically generates random test data from table structures. It supports MySQL, PostgreSQL, SQL Server, Oracle, and SQLite syntax. It parses DDL statements or JSON format table definitions, identifies primary keys, foreign keys, and data types, and generates INSERT statements that conform to database-specific syntax.
How to Use
- 1. Enter table DDL statement or JSON format table structure
- 2. Click 'Parse Structure' button to analyze table structure
- 3. Select target database type (MySQL/PostgreSQL/SQL Server/Oracle/SQLite)
- 4. If there are foreign keys, configure available value sets for foreign keys
- 5. Set row count, start ID, and other options
- 6. Click 'Generate Data' button to generate INSERT statements
- 7. Copy or download the generated SQL statements
Key Features
Terminology
DDL (Data Definition Language): SQL statements used to define database structure such as CREATE, ALTER, and DROP.
Primary key: A column or set of columns that uniquely identifies each row and cannot be NULL.
Foreign key: A column that references another table’s primary key to establish relationships.
Auto increment: The database automatically generates increasing unique values for new rows.
Best Practices
- 1. Define parent and child tables together - the tool will handle dependencies automatically
- 2. Generated parent IDs are passed to child tables as foreign key values
- 3. For foreign keys that reference tables not defined in the input, provide allowed values manually
- 4. Validate the generated data against your business rules
- 5. Generate multiple times to get different random datasets
FAQ
What is SQL Test Data Generator?
It helps developers generate random INSERT statements from table structures (DDL). It’s ideal for filling databases with mock data during development and testing.
How are foreign key relationships handled?
If your DDL includes multiple tables with FOREIGN KEY constraints, the tool attempts to resolve relationships automatically. You can also provide a comma-separated list of valid IDs for foreign key columns.
Which databases are supported?
The generated SQL is compatible with MySQL, PostgreSQL, SQL Server (T-SQL), Oracle (PL/SQL), and SQLite.
Can I generate data for multiple tables at once?
Yes. Paste all CREATE TABLE statements into the input. The tool parses all tables and lets you generate data for each.
Is my table structure secure?
Yes. Parsing and data generation run entirely in your browser. No schema data is sent to any server.
Which data types are supported?
Common types such as INT, VARCHAR, TEXT, DECIMAL, FLOAT, DATE, TIMESTAMP, BOOLEAN and dialect variants are supported.
Is this tool free to use?
Yes, the SQL Test Data Generator is completely free to use.
Can I define tables using JSON format?
Yes. You can provide a JSON object with the table name and column definitions. The input placeholder contains a full JSON example.