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.
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:
- Post-process the output: Generate JSON data, then use a script to modify specific column values
- Multiple generations: Generate different row counts with different seeds and combine the results
- 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_pricegenerates decimal values (matches "price")birth_dategenerates dates (matches DATE type)user_emailgenerates 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.