Generate Test Data from a CREATE TABLE (500k Rows)

Paste your table definition, then generate up to 500,000 rows of realistic data for tests and demos.

Hand-made test data is slow to write and often does not match your real tables. Your CREATE TABLE statement already says what each column holds, so it can describe the data for you.

The Schema Data Generator reads your table definition and builds rows that fit it. It uses each column type and size, NOT NULL, PRIMARY KEY, UNIQUE, auto-increment ids and CHECK (status IN (...)) lists. Nullable columns get some empty values, and names such as email, first_name, city or phone get realistic values. It works with PostgreSQL, MySQL, SQL Server, Oracle and SQLite.

You can edit the Min and Max of every number and date column, and choose an exact number of rows or a random number between two limits. The rows are made in your browser, up to 500,000, with no key and no upload. Download CSV, JSON, Parquet or Excel. You can also paste a JSON Schema instead.

Open the Schema Data Generator

How to use the Schema Data Generator: step by step

  1. Open the Schema Data Generator.
  2. Paste your CREATE TABLE statement, or edit the sample.
  3. Adjust the Min and Max of any number or date column.
  4. Choose how many rows (up to 500,000) and click Generate data.
  5. Check the preview, then download CSV, JSON, Parquet, Excel or nested JSON.

When to use the Schema Data Generator

  • Filling a test database from your CREATE TABLE
  • Testing an API with valid sample payloads
  • Load testing with many records
  • Creating examples for documentation

Tip: Add CHECK (status IN (...)) to a column to control its allowed values.