Features » Random Table and Data Generator – Synthetic Data

Synthetic Data

Aqua Data Studio ships with an integrated Random Table & Data Generator that runs on Windows, macOS, and Linux. This allows you to generate the synthetic data that the modern enterprise data environment demands for security, testing, and scale simulation. The generator opens from the same workspace used for query editing and schema design, providing a straightforward dialog for seeding databases with synthetic rows or whole tables. Core actions such as populating existing tables, creating brand‑new tables, defining column‑level rules, setting row counts, and adding timestamps or naming prefixes are all handled in seconds. Advanced options include saving presets for repeatable datasets, exporting DDL plus INSERT scripts to file, and driving the same engine through AquaScript for automated builds. The tool works across every platform Aqua Data Studio connects to (SQL Server, Oracle, PostgreSQL, Snowflake, MongoDB, BigQuery, and more) letting teams prototype, test, and scale safely without leaving the IDE.

Start for free

SQL History capabilities include:

Populate Existing Tables

Inject random values into any selected table while keeping the current schema unchanged.

Generate New Tables

Create synthetic tables from scratch—including columns, keys, and relationships—for immediate prototyping.

Rule‑Based Column Controls

A Query selected in the SQL History list can be instantly added in any Aqua Data Studio active editor window.

Record and Archive SQL Query Execution

The Auto-Archive feature will put older items in the SQL Archive once the number specified in the Max History option is surpassed. Options for configuring the SQL History and Archive can be found under File->Options->General->History.

Powerful SQL History Features

Define data type, range, and pattern for each column so new rows follow predictable formats.

Large‑Scale Simulation

Set row counts up to one million to test queries, indexing, and storage growth under production‑level loads.

Scriptable in AquaScript

Call the same generator through the aqua.random object to automate data builds in CI pipelines.

Cross‑Database Support

Works with every platform Aqua Data Studio connects to, including SQL Server, Oracle, PostgreSQL, Snowflake, and MongoDB.

Timestamp & Prefix Options

Add optional timestamp columns and naming prefixes so generated data is easy to locate and purge.

Generate to File

Output DDL plus INSERT scripts instead of touching the live database, useful for reviews and version control.

Synthetic data, created with Aqua Data Studio’s built‑in Random Table & Data Generator, gives development and test teams production shaped data without production level risk. Entire tables, or selective rows, can be generated on demand, matching column types, keys, and relationships so code, reports, and QA cycles run against authentic structures while keeping personal or financial information out of non‑production tiers. The approach aligns naturally with GDPR, HIPAA, and PCI‑DSS requirements and removes the delays that come with data masking or extract approvals.

High‑volume generation also turns performance planning into a controlled exercise rather than a live‑fire drill. Millions of rows, deep joins, and growing schemas can be synthesized in minutes, allowing engineers to observe query plans, indexing behavior, storage growth, and AI pipeline footprints before those pressures land in production. Because the same generation logic is available in the GUI and through AquaScript, the datasets you create for a quick validation can be baked straight into nightly CI runs, providing a repeatable foundation for every sprint.

For a deeper exploration of security blind spots, scale testing, and governance strategy, see the linked blog post or download the full tech brief.

Tech Brief - Synthetic Data: The Missing Link Between Security and Scale. (the ungated version)

Blog - Building Without Blind Spots: Why Synthetic Data Is More Than a Governance Trend