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:
- Introspect the source schema
- Resolve foreign key dependencies (parents before children)
- Sample column distributions for realistic data
- Generate 500 rows per table
- 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
- Read the generate command reference for all available flags
- Learn how Weavori works
- Follow the end-to-end workflow guide