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

About SQL Test Data Generator

This tool generates bulk SQL test data from table structures with per-table controls, null probability, and DB-specific settings.

Key Features

Structure Parsing: Parse table definitions from DDL/JSON.
Multi-table Support: Configure each table independently.
Generation Controls: Row count, start ID, null probability, date format.
Database Support: MySQL, PostgreSQL, SQL Server, Oracle, SQLite.
Output Utilities: Copy/download generated SQL.

Steps

Paste table structure and parse.
Configure row count/start ID per table.
Set database type and generation options.
Generate and review SQL output.

Use Cases

Fast test-environment seeding.
Bulk sample generation during integration.
Demo/staging data preparation.

FAQ

Why does parsing fail?

Usually malformed structure input or missing key constraints.

Are foreign-key relations always consistent?

Common cases are handled, but complex constraints should be validated after generation.