Fabricate workflow

At a high level, the workflow to generate data from Fabricate includes the following steps:

Create a database

The first step is to create the database in Fabricate.

You can start a completely new database, or clone an existing database.

Define the database

Next, you define the structure of the database, which includes:

• The tables in the database.

• The columns in each table.

• Relationships between the tables.

When you create a database, you can provide a SQL script that sets up the database schema.

You can also add tables manually. When you add a table, to define the table columns, you can:

• Provide example data

• Provide a description for the Fabricate AI to use to create it - "A users table with names, addresses, email addresses, and telephone numbers"

• Provide a SQL script with the table definition

For each table, you configure how to generate the data in each column. When you create a table, Fabricate makes a first pass at assigning generators.

You can then adjust the column settings as needed.

As you change the configuration, Fabricate automatically updates the generated data. You can also provide a set of static data to include.

Export the data

Finally, when you're ready to use the data, you can export it from the database.

You can export the data to a set of files, or use it to populate an existing database.