Customize Value Ranges in Generated Seed Data

Understand the default value ranges for numeric, date, and text columns. Learn strategies to adjust ranges for specific testing needs.

Advanced

Detailed Explanation

Default Value Ranges

The seed generator uses sensible default ranges for each data type and column name pattern. Understanding these ranges helps you evaluate whether the generated data fits your testing needs.

Numeric Ranges

Column Pattern Type Range
age INTEGER 18–80
price / amount / cost DECIMAL 1.00–999.99
quantity / count INTEGER 1–100
rating / score DECIMAL 1.0–5.0
Generic INTEGER INTEGER 1–10,000
Generic FLOAT FLOAT 1.00–999.99
Generic DECIMAL DECIMAL 1.00–9,999.99

Date Ranges

Type Range
DATE 2020-01-01 to 2025-12-28
TIMESTAMP / DATETIME 2020-01-01 00:00:00 to 2025-12-28 23:59:59
TIME 00:00:00 to 23:59:59

String Lengths

Column Pattern Typical Length
first_name / last_name 3–12 characters
email 20–40 characters
title / subject 3–7 words
description / body 10–25 words
Generic VARCHAR/TEXT 2–6 words

Adjusting Ranges

The tool does not expose range configuration in the UI (keeping the interface simple), but you can adjust generated data through these strategies:

  1. Post-process the output: Generate JSON data, then use a script to modify specific column values
  2. Multiple generations: Generate different row counts with different seeds and combine the results
  3. Manual override: Generate the bulk of the data, then manually edit specific rows that need precise values

Column Naming Strategy

Since the generator uses column name heuristics, you can influence the generated data by choosing descriptive column names:

  • unit_price generates decimal values (matches "price")
  • birth_date generates dates (matches DATE type)
  • user_email generates email addresses (matches "email")

Rename your columns descriptively before generating, then rename them back if needed.

Use Case

You are testing an application where prices must fall within a specific range (0.01 to 50.00) for compliance testing. You need to understand the default ranges the generator uses and plan a strategy to adjust the output to match your requirements.

Try It — Database Seed Generator

Open full tool