Quickstart

Generate your first synthetic dataset in 5 minutes.

Prerequisites

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

Step 1: Connect to your database

Weavori introspects your database schema to understand its structure — tables, columns, data types, and foreign key relationships. No data is read during this phase.

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

The estimate command connects to your database and prints a schema summary. 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