Weavori
⌘K

Quickstart

Generate your first synthetic dataset in 5 minutes.

Last updated October 20, 2018

Prerequisites

  • Weavori installed — see the installation guide
  • A running PostgreSQL database (local or remote)
  • A PostgreSQL connection string (DSN)

Step 1: Verify connectivity

Weavori introspects your database schema to understand its structure — tables, columns, data types, and foreign key relationships. During this phase it reads schema metadata and PostgreSQL's built-in table statistics only — never your data.

$weavori estimate "postgres://user:password@localhost:5432/mydb"

The estimate command connects to your database and reports the table count, approximate row counts, and an estimated generation time. Use it to verify that Weavori can reach and understand your database.

Step 2: Generate synthetic data

Use generate to generate synthetic data into a target database. Weavori resolves foreign key dependencies, samples column distributions, and produces referentially intact data.

$weavori generate "postgres://user:password@localhost:5432/mydb" \ --target "postgres://user:password@localhost:5432/mydb_clone" \ --rows 500

This command will:

  1. Introspect the source schema
  2. Resolve foreign key dependencies (parents before children)
  3. Sample column distributions for realistic data
  4. Generate 500 rows per table
  5. Export to the target database

Step 3: View the results

Connect to your target database and inspect the generated data:

$ psql "postgres://user:password@localhost:5432/mydb_clone"
mydb_clone=# SELECT COUNT(*) FROM users;
count
-------
500
mydb_clone=# SELECT email FROM users LIMIT 5;
email
-----------------------------------------
jane.doe@example.com
john.smith@test.org
...

Next steps