pilotbase.pro

About testData

Paste your CREATE TABLE statements and get one INSERT ... SELECT per table that fills them with rows shaped like production: amounts and foreign keys skewed so a few customers place most orders, statuses with weights, dates busier on weekdays and growing towards today, times of day with quiet nights, names, example.com emails, unique codes and a NULL rate per column. Each column is guessed from its name and type, and every choice can be changed. The random numbers come from the row number and a seed, so the same seed gives the same rows on every run and on all three engines, and the CSV preview shows exactly what the database will get. Child tables are filled after their parents, with keys that exist. Every query it writes was run on the real engines. Runs in your browser.

Runs entirely in your browser: your SQL and files are not uploaded. Signed-in members can keep a history of runs and results.

From the makers

Pilotbase: one admin app for PostgreSQL, MySQL, MongoDB, Redis and more, with an AI agent built in.

Get Pilotbase free

More free data tools