Fabricate workflows

Fabricate provides the following options to define and configure a database.

• Use the Data Agent to create a one-time set of data. Free and Plus users must always use the Data Agent.

• Enterprise users can also create a rule-based database to define a repeatable set of rules to generate sets of data.

Data Agent databases

The Fabricate Data Agent is essentially an AI chat interface that you use to define a set of data.

When you create a Data Agent database, the initial definition, as well as changes to the database structure and data, are accomplished through the chat.

You can tell the chat to add tables and columns, and provide guidance for the data values and table relationships.

You can also use the chat to answer questions about the data.

When you're ready to use the data, you can export it to a database or file format.

Rule-based databases

Requires an Enterprise license.

For a rule-based database, you manually create and configure the tables and columns, with some AI assistance. A rule-based database defines rules to generate a set of data.

Where a Data Agent database focuses on creating the data itself, a rule-based database is more about configuring the rules to use to generate the data.

At a high level, the workflow for a rule-based database is:

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.