Skip to content
Data Maestro Download
Workspace

Data Generator

Design a schema of named, typed columns, preview the output live, then export it to a file or push it straight into a database. Five tabs, left to right.

Schema Config

Add, reorder (drag), and delete fields. Each field has a type, and per-field noise settings — a null rate, a blank rate, a distinct/uniqueness rate, and a custom null sentinel if you don't want the default marker.

Data Preview

10 live rows that update as you edit the schema — the fastest way to sanity-check a field type or formula before exporting anything.

Export to File

Pick a format and row count (and a table name, for SQL formats), see a live 5-row preview, then save via the standard macOS save panel.

Export to Database

Stream rows straight into one or more saved connections at once, with a per-connection enable toggle and live push status.

Insights

A refreshable data-quality report over the current generated set — distribution and completeness stats per field, useful for spotting a schema that's producing too many duplicates or nulls before you export a large run.

Field types

Grouped into categories in the field-type picker: Identity, Person, Contact & Location, Finance, Internet, Business, Commerce, and general Data types, plus a handful of structured types that reference other fields or your own data:

  • Custom List — pick a value at random from a list you type in directly on the field.
  • Custom Dataset — pick from a reusable named list managed in Custom Datasets.
  • Template / Formula — a token template (e.g. {{firstName}} {{lastName}}) or an expression referencing other fields (e.g. this['price'] * 1.08).
  • Database Relation — pull values from a parent table/column in a saved connection, for foreign-key-style consistency.
  • JSON Object / Array — nest other field types inside a structured value, up to 3 levels deep.

One ordering rule matters: put Full Name / First Name / Last Name fields above any Email or Username field in the list — the generator uses the name it just produced for that row to build a matching email or username, so if email comes first it'll use the previous row's name instead.

Export formats

Everything the CLI supports is available here too: delimited text (CSV/TSV/SSV/PSV), structured/config formats (JSON/YAML/XML/TOML/INI/plist/Java Properties), every SQL dialect (ANSI, MySQL, PostgreSQL, SQLite, Oracle, MSSQL), NoSQL and graph formats (Cassandra CQL, MongoDB/DynamoDB/Firebase JSON, Redis commands, Neo4j Cypher), NDJSON, and the binary/ML formats (Parquet, Avro, MessagePack, BSON, OpenAI Chat fine-tuning, Alpaca). Binary formats show a text summary in the preview instead of raw bytes.

Free tier

Without a Pro license, both Export to File and Export to Database clamp to 100 rows regardless of the row count you request — an "Upgrade to Pro" alert explains the cap rather than failing silently. See Licensing & Settings.