Learn more about how to calculate and track the cost to use Fabricate.

Use these videos to learn more about how to use Tonic Fabricate.

Getting started with Fabricate

Fabricate overview

Overview of Fabricate and its features

Foreign key relationships

Deriving a column from another column

Using the AI generator

Creating JSON data

Using the Markov Chain generator

Create a mock API for a database

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

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 , or .

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 . 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 . 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 .

Export the data

Finally, when you're ready to use the data, you can .

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

Tonic Fabricate allows you to create data from scratch.

For example, maybe you are working on a new feature or product where there is no existing data that uses the new schema. Or you need data for testing or development, but don't have any access to data that you can use.

In Fabricate, you can use the AI-based Data Agent chat to quickly define and refine a set of data.

Enterprise customers can also create rule-based databases, where they define and configure the structure of a database, its tables, and the table columns.

Fabricate can produce a range of value types across multiple categories and industries. You can even enhance the generated data with real data that you upload.

And when you're ready to use the data, you can export it in a variety of formats, including unstructured files that are populated from the data.

To create an account, can use Google, GitHub, or Microsoft Office, or specify an email address and configure a password.

Your Fabricate account is initially created under the free license plan. You can then upgrade to a paid plan. For more information, go to .

You are also prompted to create your first database.

Creating your account

To get started, go to .

The Fabricate Data Agent provides an AI chat interface to create and configure a database. It allows you to quickly create a single set of data that you can export to a database or files.

With a Data Agent database, the database creation as well as all changes to the database definition and data go through the Data Agent.

You can, for example, to start, you might tell the Data Agent to Create a database of transaction records that are linked to customer and product records.

The Data Agent asks questions to clarify the data to create. For example, it can ask for the number of customers or products, or how many orders to create for each customer.

Based on the initial results, you can provide additional prompts to adjust the data to fit your needs.

In response to the prompts, the Data Agent generates code to implement the requested change, whether it's to add a missing column or to adjust the types of values used to populate a column.

Data Agent databases have additional viewing and editing options for the generated data. You can manually edit specific values.

The cost for a customer to use Tonic Fabricate combines the basic access fee with the cost to make the LLM calls that are needed for AI features.

Elements of the Fabricate cost

Basic access

This is the flat monthly amount that is charged to Plus and Enterprise accounts.

It provides overall access to the application and its features.

AI usage and billing

Fabricate's AI features, such as the Data Agent, require calls to a large language model (LLM).

Fabricate uses Anthropic as its LLM provider for the Data Agent. Anthropic charges Tonic.ai for these calls to the Anthropic API.

The incurred cost is based on the volume and complexity of the processed data.

While the technical AI usage is measured in tokens, Tonic.ai tracks and bills usage in dollars.

Each account is granted a monthly AI usage allowance to cover standard AI activity.

If an account exceeds the monthly allowance:

• Free accounts - Fabricate pauses access to AI features until the allowance resets at the start of the next month.

• Plus accounts - Access to AI features is not interrupted. At the end of the month, Tonic.ai bills for the AI usage that exceeded the allowance.

• Enterprise accounts - Access to AI features is not interrupted. Tonic.ai bills calculates and bills quarterly for the AI usage that exceeded the allowance. Alternatively, Enterprise accounts can . If they provide their own key, then Tonic.ai does not charge them for AI usage overages.

The base charge for the additional AI usage is calculated as follows:

(Anthropic cost per token) x (Number of tokens)

The cost per token is based on the publicly listed API prices for .

Tonic.ai also charges a token processing fee of $0.50 for each 1 million tokens.

How the billing cycles work

Here is how the billing cycles work for each license plan.

Free plan

The Free plan does not allow any AI usage overages. Each month, Fabricate resets the AI usage allowance based on the account start date.

For example, a Free account starts on October 14.

If the account uses up its monthly allowance before November 13th, then AI features are paused until November 14, when the AI usage allowance is reset. Fabricate resets the AI usage allowance every month on the 14th.

Plus plan

For the Plus plan, the billing cycle is one month. Every month, the AI usage allowance is reset and the account is billed based on the account start date.

For example, a Plus account starts on November 15. On December 15, the AI usage allowance is reset, and the account is charged for the access fee and for any AI usage overage for between November 15 and December 14.

Every month on the 15th, the AI usage allowance is reset and the account is billed for the previous month.

Enterprise plan

For the Enterprise plan, the platform fee is billed annually. The billing cycle for the AI usage overage is quarterly, and is based on calendar quarters. The monthly AI usage allowance is lined up to the calendar month.

For example, an account starts on October 21st.

On November 1, December 1, and January 1, Fabricate resets the monthly AI usage allowance.

Shortly after January 1, the account is charged for the AI usage overage for October through December.

The next AI usage bill is sent after March 31, and covers the AI usage overage for January through March.

New accounts use the Free plan. Fabricate also provides a Plus plan and an Enterprise plan.

Overview of the license plans

Here is an overview of the available license plans. For more information, go to .

Upgrading from the Free plan

To upgrade from the Free license plan to the Plus plan, click the Upgrade Now option at the bottom of the Fabricate application. You are prompted to provide a credit card for payment.

To upgrade from the Free license plan to the Enterprise plan, .

You can import a CSV, JSON, or JSONL file as a new table in a Data Agent database.

For example, you might use this option to provide data for the Data Agent to use as a guide:

Create a table that uses the same fields as ExampleStaticData. Generate a new set of values for the names and addresses.

To import a file:

1. In the database heading, click Import.

2. On the Import Data panel, either:

The Data Agent is also able to use values from a database to populate unstructured files that you can use elsewhere. It can generate:

• PDFs

• Word files (.docx)

• PowerPoint files (.pptx)

Fabricate can generate rule-based databases of the following types:

• MySQL

• PostgreSQL

• Databricks

• Oracle (Enterprise plan only)

• Microsoft SQL Server (Enterprise plan only)

• MongoDB

• SQLite

• CSV - Produces a set of CSV files.

• JSON - Produces a set of JSON files.

• XML - Produces a set of XML files.

To use the Fabricate API, you must have a Fabricate API key.

All requests to the Fabricate API must include an authorization header with the value:

Bearer <your_api_key>

You can add columns to and remove columns from a rule-based database table. You configure how Fabricate populates the column data.

The following generators produce values related to spoken languages.

For information about the API data models for these generators, go to Languages in the column attributes.

Language

Populates the column with the name of a spoken language. For example, French, Spanish, English.

You can configure a weighted distribution of the values.

You can also configure a group key to link the column to other columns.

Language Code

Populates the column with the 2-character code for a spoken language. For example, fr, es, en.

You can configure a .

You can also configure a to link the column to other columns.

The following generators produce values related to motor vehicles.

For information about the API data models for these generators, go to Vehicles in the column attributes.

Car Make

Populates the column with the make of a car. For example, Ford or Honda.

You can configure a weighted distribution of the values.

You can also configure a group key to link the column to other columns.

Car Model

Populates the column with the model of a car. For example, Mustang or Accord.

You can configure a .

You can also configure a to link the column to other columns.

Car Year

Populates the column with a year.

You can configure a .

You can also configure a to link the column to other columns.

Adding a column to a table

To add a column to a table:

1. In the table heading, click Add Column.

2. On the New Column panel:

   1. Set the column name.

   2. Select and configure the column generator.

For information on column configuration, go to .

For information about the available generators, go to .

Removing a column from a table

Before you delete a column, make sure that it is not being used in the configuration of another column.

To delete a column:

1. In the column heading, click the settings icon.

2. On the column settings panel, click Delete.

3. On the confirmation panel, click Delete Column.

The following generators produce values related to natural science.

For more information about these generators and how to configure them in the application, go to Natural science in the generator reference.

Animal Common Name

Populates the column with the name of an animal. For example, dog or cat.

Uses the General column configuration.

Animal Scientific Name

Populates the column with the scientific name of an animal. For example, canis lupus familaris or felis catus.

Uses the .

Plant Common Name

Populates the column with the name of a plant. For example, dandelion.

Uses the .

Plant Family

Populates the column with the name of a plant family. For example, asteraceae.

Uses the .

Plant Scientific Name

Populates the column with the scientific name of a plant. For example, taraxacum officinale.

Uses the .

Creating a Data Agent database

To create a Data Agent database:

1. Click the database dropdown at the top right, then click New Database.

Viewing the SQL or JavaScript for a Data Agent action

From the chat, flags SQL and JavaScript that it creates. Can view the content.

To complete an action to the database, the Data Agent generates either SQL or JavaScript.

In the chat window, the Data Agent uses icons to identify actions that generated SQL or JavaScript.

To view the content of the SQL or JavaScript, click the dropdown icon for the action. To copy the SQL or JavaScript, click the copy icon.

The following generators produce values for telephone numbers and email addresses.

For information about the API data models for these generators, go to in the column attributes.

Country Phone Code (Global)

Populates the column with a country telephone code from anywhere around the world.

You can configure a .

You can also configure a to link the column to other columns.

The following generators produce values related to network locations and files.

For information about the API data models for these generators, go to in the column attributes.

File Type Extension

Populates the column with a file extension. For example, .txt or .docx.

You can configure a .

You can also configure a to link the column to other columns.

For a rule-based database, you define the mock API on the database API tab.

By default, the API tab contains a commented-out example mock API definition.

Populating the mock API definition directly

One option is to enter the mock API definition directly in the definition field.

For information on the API syntax, go to .

About SQL tables

Fabricate SQL tables allow you compose virtual tables from data in other tables. They are particularly useful for:

• Denormalization

The following generators produce values related to movies.

For information about the API data models for these generators, go to in the column attributes.

Movie Genres

Populates the column with a movie genre. For example, Horror, Romantic Comedy.

You can configure a .

You can also configure a to link the column to other columns.

The following general column configuration properties apply to most generators.

For information on about the general properties and how they are set in the application, go to .

Each constraint object can contain the following attributes:

Job Area

Produces a value that describes the area of expertise for a job. For example, Security or Quality.

Job Descriptor

For each table, you can upload a .csv file that contains data for the table. The uploaded data can either replace the current data or be added to the current data.

You can also .

The uploaded data remains permanently in place. It is not affected when you regenerate the table data.

For example, having static data can be useful when you want to run tests and want to be able to use specific values.

To attach static data to a table:

1. In the table heading, click Attach Data.

The following generators produce values related to natural science.

For information about the API data models for these generators, go to in the column attributes.

Animal Common Name

Populates the column with the name of an animal. For example, dog or cat.

You can configure a .

You can also configure a to link the column to other columns.

The following generators produce values related to schools and education.

For information about the API data models for these generators, go to in the column attributes.

University Country Code

Populates the column with the 2-character country code for the university location. For example, ES, FR, US.

You can configure a .

You can also configure a to link the column to other columns.

You can define variables to use in SQL and row count expressions

You configure variables from the Settings tab of a rule-based database. To display the Settings tab, click the database name.

Adding a variable

To add a variable:

1. Click

Uses an LLM to populate a column with unstructured data, such as text or JSON, that can include values from other columns in the table.

For more information about the Unstructured Data generator and how to configure it in the application, go to .

Data Agent chats have a size limit. As you interact with the Data Agent, Fabricate updates the percentage of the size limit that you have used.

As you get closer to the limit, the response time can slow down.

You can create multiple chats. For example, for a more complex database, you might use different chats to manage different areas of the data.

Viewing and updating the shared reference for Data Agent chats

Every chat is independent of the other chats. It does not have access to all of the context from any of the other chats.

When you create a rule-based database for a database type other than XML or JSON, the database details include a DDL tab. If you used a SQL DDL script to create the database, then Fabricate populates the DDL tab with that script.

From the DDL tab, you can update the DDL.

When you update the DDL, you also choose whether Fabricate automatically changes the database schema to match the new DDL. When Fabricate updates the database, it adds and removes tables and columns. It does not touch columns and tables that you exclude from the database export. For more information, go to and .

To change the DDL:

1. Click Update DDL.

The following generators produce values related to movies.

For more information about these generators and how to configure them in the application, go to in the generator reference.

Movie Genres

Populates the column with a movie genre. For example, Horror, Romantic Comedy.

Uses the .

The Fabricate API uses the following data model.

Job Area

Produces a value that describes the area of expertise for a job. For example, Security or Quality.

Job Descriptor

Produces a value that describes a general descriptor of the job hierarchy level. For example, Senior or Lead.

The following generators produce values related to motor vehicles.

For more information about these generators and how to configure them in the application, go to in the generator reference.

Car Make

Populates the column with the make of a car. For example, Ford or Honda.

Uses the .

The following generators produce values related to spoken languages.

For more information about these generators and how to configure them in the application, go to in the generator reference.

Language

Populates the column with the name of a spoken language. For example, French, Spanish, English.

Uses the .

Managing your account

When you sign up for Fabricate, it creates a Fabricate account and makes you the owner of the account.

To manage your account, click the user menu, then click My Account.

From the My Account page,

By default, the account name is set to the name of the person who created it.

To use a different name for the account:

1. Under Account Info, in the Account Name field, provide the new account name.

2. Click Save Changes.

Account owners can do the following:

• Change the current license plan. For more information, go to .

• Manage account users. Having multiple users in an account requires a license plan other than the free plan. For more information, go to .

• Create and manage API keys to use to authenticate API requests. For more information, go to .

• For the cloud application, configure the access token and models to use for the .

Managing your personal profile

Your personal profile contains specific information about you as a user.

To view your profile information, click the user menu, then click My Profile.

From the My Profile page, you can:

• Update your name and email address.

• Change your Fabricate password.

Changing your profile name and email address

On the My Profile page, under My Details:

1. In the Name field, provide an updated name for your profile.

2. In the Email field, provide an updated email address for your profile.

3. Click Save Changes.

Changing your Fabricate password

On the My Profile page, under Reset Password:

1. In the Current Password field, type your current Fabricate password.

2. In the Password field, type the new password.

3. In the Confirm Password field, type the password again.

4. Click Save Changes.

Deleting your account

When you delete your account, Fabricate deletes all of the users, workspaces, databases, and data that are associated with the account.

From the My Account page, to delete your Fabricate account:

1. Under Delete Account, check the checkbox to confirm that you understand that you cannot undo the deletion. Until you check the checkbox, the Delete Account button remains disabled.

1. Click Delete Account.

To add a table to a rule-based database, you can:

• Create a table from a schema definition

• Clone an existing table

• Import data from a .csv file

• Generate a table of static data based on an AI prompt

• Create a SQL table based on data in other tables. For more information, go to .

Creating a table from a schema definition

To create a table:

1. Click Add Table(s), then click From schema definition.

2. On the Add Table(s) panel, in the Name field, provide a name for the table.

3. Optionally, in the Schema Definition text area, provide one of the following to define the table schema:

Cloning an existing table

You can also create a clone of an existing table. The clone is created with the same columns and data as the original table. You can then adjust the table configuration.

To add a table that is a clone of an existing table:

1. Display the table that you want to clone.

2. Click Clone Table.

3. On the clone panel, in the New Table Name field, provide the name for the new table. By default, the table name is <table_name>_COPY. For example, if you clone the users table, the default name is users_COPY.

Creating a table from imported data

You can create a table from an imported CSV, JSON, or JSONL file. Fabricate uses the file to determine the table columns and data types, and to populate the table data.

To add a table based on an imported CSV file:

1. In the database header, click Add Table(s), then click From a CSV or JSON file.

2. In the Name field, provide the name of the table.

3. To search for and select a file, click Choose File.

4. Click Import Table.

On the table details, Fabricate indicates that the table data came from a file. It marks the columns as having come from the source file.

Generating static data from an AI prompt

You can create a table of static data from an AI prompt. Fabricate also generates a CSV file of the table data.

To generate static data from an AI prompt:

1. In the database header, click Add Table(s), then click Generate static data using AI.

2. In the Table Name field, provide the name of the table. The table name is also used as the name of the CSV file.

3. In the Prompt field, provide an AI prompt that describes the data. For example: List of states in the United States, the state abbreviations, and the year that the state joined the United States.

1. To make adjustments to the data, update the prompt, then click Regenerate.

2. When you are satisfied with the generated data:

   • To download the data as a CSV file, click Download.

   • To copy the CSV to the clipboard, click Copy to Clipboard.

For license plans other than the Free plan, account owners can add users to an account. Each user is assigned an account role.

Displaying the list of account users

The list of users is in the Users section of the My Account page.

To display the My Account page, in the user menu, click My Account.

For each user, the list contains the following information:

• The user name and email address.

• The user's account role.

• The user's workspace access. For each workspace that the user has access to, lists the workspace name and the access role.

Adding users to an account

To add users to your account:

1. Click Invite Users.

2. On the Invite Users panel, in the Emails field, provide the email addresses of the users to add. Put each email address on a separate line.

3. To immediately grant access to all of the current account workspaces:

   1. Check the

Changing the account role for a user

About account roles

Fabricate supports the following account roles:

• Owner - Every account must have at least one owner. The first user in the account is automatically an owner. Other users can be assigned as owners. Account owners have full access to manage the account. They can:

  • Create and manage workspaces.

  • Add and remove account users.

  • Change assigned account roles.

Assigning account roles to users

By default, when you add a user to your organization, they are granted the Member account role.

To change the account role for a user, from the Account Role dropdown list, select the role to assign.

Removing an account user

To remove a user from your account:

1. Click the Remove option for the user.

2. On the confirmation panel, click Remove User.

You cannot remove the only account owner for an account.

If you have multiple workspaces, then before you create or edit a rule-based database, make sure that you are in the correct workspace.

To change to a different workspace, in the user menu, click Switch Workspaces, then select the workspace.

Starting a new database

To start a completely new database:

1. Click the database dropdown at the top right, then click New Database.

1. On the database creation page, click Rule-based database.

2. On the Create a New Database panel, in the Database Name field, provide a name for the database.

3. From the Type dropdown list, select the .

4. Optionally, in the Schema Definition

Fabricate displays the database details page for the database.

Selecting a database to manage

To select a database to manage:

1. Click the database dropdown at the top right.

2. In the dropdown list, select the database.

Cloning an existing database

From the database Settings tab, you can create a new database based on an existing database. The new database inherits all of the configuration from the original database.

To clone a database:

1. Select the database to clone.

2. On the Settings tab, click Clone.

Changing the database name and type

From the database Settings tab, you can change the database name and type.

1. In the Name field, provide the new database name.

2. From the Type dropdown list, select the new database type.

3. Click Save Changes.

Setting the schema name for PostgreSQL and SQL Server databases

For PostgreSQL and SQL Server databases, you can optionally provide a schema name to use when you export data.

On the Settings tab, in the Schema Name field, provide the name of the schema.

Deleting a database

To delete a database, on the database Settings tab:

1. Click Delete.

2. On the confirmation panel, click Delete Database.

Changing the table name

To change the name of a table:

1. Click the table name.

2. In the name field, provide the new name.

3. Click the save icon.

Configuring constraints for the table

Within a table, you can configure constraints to either:

• Guarantee that the value of a column is unique.

• Guarantee that a specified list of columns does not have the same value. For example, for an airline flight, the origin city and destination city should be different values.

The constraints list is on the table settings panel. To display the settings panel, in the table heading, click the settings icon.

To add a constraint, click Add Constraint.

To configure a constraint:

1. From the Type dropdown list, select the type of constraint.

   • For a uniqueness constraint, select Unique.

   • For a not equal constraint, select Not Equal.

2. For each column to add to the constraint, click Add column

To remove a constraint, click the delete icon.

Indicating whether to include the table in the export

By default, each table is included in the exported data.

From the settings panel, you can configure a table to be excluded from the exported data.

To exclude the table, check Hide this table when exporting.

Setting a table-wide seed value

By default, every time you generate data, Fabricate generates a completely different set of values.

To generate the same set of data across the table, you can set a seed value for the table.

On the settings panel, in the Seed field, provide the seed value to use.

To have Fabricate generate a new seed value, click the generate icon next to the field.

Note that you can also . A column-level value overrides the table-level value.

Determining the number of rows in the table

By default, for a new table, Fabricate generates 100 rows. The row count is displayed above the table.

The free tier is limited to maximum of 100 rows per table.

Row count when the number of rows is derived

In some cases, the row count is derived based on column configuration. For example, when you configure a , you can configure the number of rows to generate for each primary key value.

When the row count is derived, then the row count does not display as a number of fields. Instead, Fabricate displays how the number of rows is calculated.

For example, the following indicates that the table contains 5 rows for each value of customer_id:

Changing the row count configuration

If the row count is not derived, then you can configure the number of rows in the table.

To configure a specific number of rows:

1. From the comparison dropdown, select exactly.

2. In the field, either provide a number or an expression that evaluates to a number.

Alternatively, you can set the number of rows based on the number of unique values of a specific type in the table. For example, for a list of orders, you can set the number of rows to be equal to the number of possible payment types or the number of locations.

1. From the comparison dropdown, select unique values of. Note that if there is not an appropriate value to use, then the unique values of option is not available.

2. From the value type dropdown list, select the value to use.

Every database belongs to a specific workspace.

You can use workspaces to group and manage access to sets of databases. Each workspace can be assigned a different set of users and API keys. The users and API keys are assigned a workspace role that controls their access to workspace functions.

When you create your Fabricate account, Fabricate automatically creates a workspace with your name. If you don't create other workspaces, then all of your databases are in that workspace.

The following generators produce values for telephone numbers and email addresses.

For more information about these generators and how to configure them in the application, go to Telephone numbers and email addresses in the generator reference.

Country Phone Code (Global)

Populates the column with a country telephone code from anywhere around the world.

Uses the General column configuration.

Country Phone Code (US)

Populates the column with the country telephone code for the United States.

Uses the .

Email Address

Populates the column with an email address.

If the table includes first name and last name columns, then the email address is automatically derived from the those columns. For example, [email protected].

Uses the .

Phone Number (Global)

Populates the column with a telephone number from anywhere in the world.

Phone Number (US)

Populates the column with a telephone number from the United States.

To use the Fabricate API and CLI, you must have a Fabricate API key.

Displaying the list of API keys

To display the list of API keys, click the user icon at the bottom left of Fabricate, then select My Account.

The API Keys section contains your list of API keys.

Creating an API key

To create an API key:

1. Click Create New API Key.

2. On the Create New API Key panel, in the Name field, provide a name for the API key.

3. By default, new API keys are granted Editor access to all of the current account workspaces. For information about workspace roles, go to . To grant a different workspace role, select the role from the dropdown list. To not grant any access to the account workspaces, uncheck the Grant access to all workspaces checkbox. You can then add the API key as needed to specific workspaces. Note that this only applies to workspaces that exist when you create the API key. The API key is not automatically granted access to any future workspaces.

Copying an API key

To copy an API key to the clipboard, click the copy icon next to the key.

Deleting an API key

To delete an API key, click Delete.

You can use the Fabricate API to manage databases and generate data. Except for generating data, most API calls are designed for rule-based databases.

The API is at https://fabricate.tonic.ai/api/v1. You make requests to the API endpoints within the API. Each request requires authentication with an API key.

For examples of how to use the Fabricate API, go to the fabricate-api-examples repository on GitHub.

Fabricate also provides a Python library that you can use to make calls to the Fabricate API. The Python library is at https://github.com/TonicAI/tonic-fabricate-python.

There is also a client NPM package at https://www.npmjs.com/package/@fabricate-tools/client.

The following generators produce values related to schools and education.

For more information about these generators and how to configure them in the application, go to Education in the generator reference.

University Country Code

Populates the column with the 2-character country code for the university location. For example, ES, FR, US.

Uses the General column configuration.

University Name

Populates the column with the name of a university. For example, Harvard.

Uses the .

University URL

Populates the column with the URL for the university website. For example, harvard.edu.

Uses the .

Individual columns include common properties, as well as properties that are specific to the assigned generator.

For an alphabetical list of generators, go to Generator summary.

For details about how to configure each generator on the application, go to Generator reference.

Each database object can contain the following attributes:

{
  "id": uuid,
  "name": "my_store",
  "created_at": datetime,
  "updated_at": datetime,
  "last_generated": datetime,
  "data_url": string,
  "platform": string,
  "variables": {
    "<variable_name>": string
  },
  "entities": entity[]
  "workspace": {
    "id": uuid,
    "name": string
  }
}

You can export the most recently generated rule-based database data to files or to a database.

Note that views are exported as tables. They do not create or replace the views in the target database.

Starting the export

To start an export, in the database header, click Export Data.

The following generators produce values related to banks and credit cards.

For information about the API data models for these generators, go to in the column attributes.

Bank City

Populates the column with the name of a city.

You can configure a .

You can also configure a to link the column to other columns.

Tonic Fabricate offers generators to create the following categories of column values.

For an alphabetical list of the generators, go to .

For information on how to configure columns in the API, go to .

The following generators produce names and other identifying values for an individual.

Fabricate automatically correlates name and gender columns within a table.

For information about the API data models for these generators, go to in the column attributes.

First Name

Produces a given name, such as John or Mary.

You can configure a .

You can also configure a to link the column to other columns.

When you create your Fabricate account, Fabricate automatically creates a workspace with your name.

If you do not create other workspaces, then all of your databases are created in that workspace.

Adding a workspace

The following generators produce datetime values. Note that there are also category-specific generators that produce datetime values, such as a car model year or an IPO date.

For more information about these generators and how to configure them in the application, go to in the generator reference.

Datetime

Populates the column with a datetime value.

Using SQL tables to denormalize data

Though not required, it's a common practice to:

1. Generate the raw data you need in normalized tables

The following generators produce values related to healthcare and health insurance.

For information about the API data models for these generators, go to Healthcare and health insurance in the column attributes.

Drug Company

Populates the column with the name of a pharmaceutical company. For example, Pfizer.

You can configure a weighted distribution of the values.

You can also configure a group key to link the column to other columns.

Drug Generic Name

Populates the column with a generic name of a drug.

You can configure a .

You can also configure a to link the column to other columns.

Drug Name

Populates the column with the brand name of a drug.

You can configure a .

You can also configure a to link the column to other columns.

Drug NDC Code

Populates the column with a code from the National Drug Code directory.

You can configure a .

You can also configure a to link the column to other columns.

HCPCS Code

Populates the column with a code from the Healthcare Common Procedure Coding System.

You can configure a .

You can also configure a to link the column to other columns.

HCPCS Name

Populates the column with a name from the Healthcare Common Procedure Coding System.

You can configure a .

You can also configure a to link the column to other columns.

Hospital City

Populates the column with the city for a hospital address.

You can configure a .

You can also configure a to link the column to other columns.

Hospital Name

Populates the column with the name of a hospital organization.

You can configure a .

You can also configure a to link the column to other columns.

Hospital NPI

Populates the column with the National Provider Identifier for a hospital.

You can configure a .

You can also configure a to link the column to other columns.

Hospital Postal Code

Populates the column with a postal code for a hospital address.

You can configure a .

You can also configure a to link the column to other columns.

Hospital State

Populates the column with a US state for a hospital address.

You can configure a .

You can also configure a to link the column to other columns.

Hospital Street Address

Populates the column with a hospital street address.

You can configure a .

You can also configure a to link the column to other columns.

ICD-10 Diagnosis Code

Populates the column with a diagnosis code from ICD-10.

You can configure a .

You can also configure a to link the column to other columns.

ICD-10 Diagnosis Long Description

Populates the column with a long description of a diagnosis from ICD-10.

You can configure a .

You can also configure a to link the column to other columns.

ICD-10 Diagnosis Short Description

Populates the column with a short description of a diagnosis from ICD-10.

You can configure a .

You can also configure a to link the column to other columns.

ICD-10 Procedure Code

Populates the column with a procedure code from ICD-10.

You can configure a .

You can also configure a to link the column to other columns.

ICD-10 Procedure Long Description

Populates the column with the long description of a procedure from ICD-10.

You can configure a .

You can also configure a to link the column to other columns.

ICD-10 Procedure Short Description

Populates the column with the short description of a procedure from ICD-10.

You can configure a .

You can also configure a to link the column to other columns.

ICD-9 Diagnosis Code

Populates the column with a diagnosis code from ICD-9.

You can configure a .

You can also configure a to link the column to other columns.

ICD-9 Diagnosis Long Description

Populates the column with the long description of a diagnosis from ICD-9.

You can configure a .

You can also configure a to link the column to other columns.

ICD-9 Diagnosis Short Description

Populates the column with the short description of a diagnosis from ICD-9.

You can configure a .

You can also configure a to link the column to other columns.

ICD-9 Procedure Code

Populates the column with the code for a procedure in ICD-9.

You can configure a .

You can also configure a to link the column to other columns.

ICD-9 Procedure Long Description

Populates the column with the long description of a procedure in ICD-9.

You can configure a .

You can also configure a to link the column to other columns.

ICD-9 Procedure Short Description

Populates the column with the short description of a procedure in ICD-9.

You can configure a .

You can also configure a to link the column to other columns.

The following generators produce values related to airports and flights.

For more information about these generators and how to configure them in the application, go to Air travel in the generator reference.

Airport Code

Populates the column with an airport code. For example, SFO or CDG.

Uses the General column configuration.

Airport Continent

Populates the column with the name of a continent.

Uses the .

Airport Country Code

Populates the column with a 2-character country code.

Uses the .

Airport Elevation (Feet)

Populates the column with a number intended to represent the elevation where an airport is located.

Uses the .

Airport GPS Code

Populates the column with an airport code from the International Civil Aviation Organization (ICAO) code. For example, LFPG or KJFK.

Uses the .

Airport Latitude

Populates the column with a latitude value.

Uses the .

Airport Longitude

Populates the column with a longitude value.

Uses the .

Airport Municipality

Populates the column with the name of a city or metropolitan area where an airport is located.

Uses the .

Airport Name

Populates the column with the name of an airport. For example, John F Kennedy Airport or Heathrow Airport.

Uses the .

Airport Region Code

Populates the column with a 2-character code to represent the region where the airport is located.

Uses the .

Flight Airline

Populates the column with the name of a commercial airline. For example, Delta Airlines or Lufthansa.

Uses the .

Flight Arrival Airport

Populates the column with the name of an airport.

Uses the .

Flight Arrival Airport Code

Populates the column with a 3-character airport code.

Uses the .

Flight Arrival City

Populates the column with the name of a city.

Uses the .

Flight Arrival Country

Populates the column with the name of a country.

Uses the .

Flight Departure Airport

Populates the column with the name of an airport.

Uses the .

Flight Departure Airport Code

Populates the column with a 3-character airport code.

Uses the .

Flight Departure City

Populates the column with the name of a city.

Uses the .

Flight Departure Country

Populates the column with the name of a country.

Uses the .

Flight Departure Time

Populates the column with a timestamp in 24-hour format. For example, for 1:15 PM, the generated value would be 13:15.

Uses the .

Flight Duration Hours

Populates the column with a decimal number to indicate the number of hours in a flight. For example, 2.5.

Uses the .

Flight Number

Populates the column with a value representing a flight number. For example, LH1234.

Uses the .

The Unstructured Data generator uses an LLM to populate a column with unstructured data, such as text or JSON, that can include values from other columns in the table.

For information about the API data model, go to Unstructured Data in the column attributes.

For more information about the generator, view the video tutorial.

Configuring the access token and models

On the cloud application, on the My Account page, the Unstructured Data Generator section contains settings for the OpenAI access token and the models to use to generate the content.

To display the My Account page, click the user menu, then click My Account.

Providing an access token for the LLM provider

On the cloud application, you must provide an access token for the LLM provider that you plan to use. By default, Fabricate uses OpenAI.

1. In the Access Token field, provide the token.

2. Click Save Changes.

Providing the base URL for the API

By default, Fabricate uses OpenAI as the LLM provider.

To use a different API, in the URI base field, provide the base URL for an OpenAI-compatible API such as OpenRouter.

Selecting the model for each content type

The Unstructured Data generator can produce either free text, a conversation, or JSON.

By default, Fabricate uses:

• For free text and conversations, gpt-4.1-mini

• For JSON, gpt-4.1

For each type of content, you can configure the model to use.

1. In the Model for Free Text field, provide the model to use for free text.

2. In the Model for Conversations field, provide the model to use for conversations.

3. In the Model for JSON field, provide the model to use for JSON.

Testing the model connections

To verify that Fabricate can connect to the models, click Test Settings.

Configuring the generator

On the column details panel, you select the format of the generated content and provide prompts to describe it.

Selecting the type of content to generate

From the Type dropdown list, select the type of unstructured content to generate:

• Free text generates unstructured plain text or Markdown.

• Conversation generates a transcript of a conversation between two personas. For example, you might use this option to replicate a customer support call.

• JSON generates data in JSON format.

Providing a prompt to describe the content

In the Prompt field, provide an overview description of the content.

The prompt can include other columns from the table. To include a column, use {column_name}.

For example:

• "Generate notes for a patient visit. The patient is named {patient_name}, is {age} years old, and was diagnosed with {diagnosis}."

• "Generate a conversation between an airline customer named {customer_name} who is trying to get help with a cancelled flight and a support agent named {agent_name}."

• "Generate a JSON object to summarize the customer information. Include {customer_name}, {mailing_address}, and {telephone_number}.

Describing personas for a conversation

For the conversation type of unstructured content, you provide a description of each persona in the conversation.

The personas can include other columns from the table. To include a column, use {column_name}.

1. In the Persona 1 field, provide a description of the first persona.

2. In the Persona 2 field, provide a description of the second persona.

For example:

• "An airline customer {customer_name} who is upset about a canceled flight."

• "A customer support representative who is trying to help the customer {customer_name}."

Defining the schema for JSON content

For the JSON type of unstructured content, you provide the JSON schema.

In the Schema field, provide the JSON schema.

You can type or paste the schema directly, or you can have Fabricate generate the schema based on an example object.

To generate the schema from an example:

1. Click Derive JSON schema from an example.

2. On the panel, in the Example JSON field, provide an example of a JSON object that reflects the schema. For example:

1. Click Derive JSON Schema.

Setting the randomness factor for the content

In the Temperature field, provide a number to indicate how varied or creative the content is.

The higher the number, the more creative the output.

A typical value is between 1.0 and 1.2. A value higher than 1.2 starts to produce garbled or nonsensical values.

Selecting the output format

For free text and conversations, you select the format to use for the output.

From the Format dropdown list:

• To generate plain text, select Plain Text.

• To use Markdown format, select Markdown.

Generating example output

After you configure the required fields, to verify that the results are what you expect, you can generate an example entry.

To generate the example, click Generate a sample result.

After you generate an initial example, to generate a new example, click Regenerate. For example, you might generate a new example after you make adjustments to a prompt or schema.

Displaying an unstructured column value

For a column that uses the Unstructured Data generator, to display the content, click the content icon.

The following generators produce values related to geographic locations.

Fabricate automatically correlates location values. For example, in a given record, the value in a city column is a city located in the state column.

Note that other generators specific to air travel, healthcare, and finance also produce some geographic values. For example, there are generators that produce city where a bank, airport, or hospital is located.

For more information about these generators and how to configure them in the application, go to Geographic locations in the generator reference.

City (Global)

Populates the column with the name of a city from anywhere in the world.

Uses the .

City (US)

Populates the column with the name of a city from within the United States.

Uses the .

Country (Global)

Populates the column with the name of a country from anywhere in the world.

Uses the .

Country (US)

Populates the column with the United States.

Uses the .

Country Code (Global, 3 Character)

Populates the column with a for a country from anywhere in the world. For example, FRA, ESP, USA.

Uses the .

Country Code (Global)

Populates the column with a for a country from anywhere in the world. For example, FR, ES, US.

Uses the .

Country Code (US)

Populates the column with the 2-character country code for the United States - US.

Uses the .

Full Address (Global)

Populates the column with a full mailing address from anywhere in the world.

Uses the .

Full Address (US)

Populates the column with a full mailing address from within the United States.

Uses the .

Latitude (Global)

Populates the column with a latitude value from anywhere in the world.

Uses the .

Latitude (US)

Populates the column with a latitude value from within the United States.

Uses the .

Longitude (Global)

Populates the column with a longitude value from anywhere in the world.

Uses the .

Longitude (US)

Populates the column with a longitude value from within the United States.

Uses the .

Postal Code (Global)

Populates the column with a postal code from anywhere in the world.

Uses the .

Postal Code (US)

Populates the column with a 5-digit postal code from within the United States.

Uses the .

State / Province (Global)

Populates the column with the name of a state or province from any country in the world. For example, Normandy or Ontario.

Uses the .

State / Province (US)

Populates the column with the name of a state in the United States. For example, Montana or New York.

Uses the .

State Abbreviation (Global)

Populates the column with the postal abbreviation of a state or province from anywhere in the world. For example, NOR or ONT.

Uses the .

State Abbreviation (US)

Populates the column with the postal abbreviation of a state in the United States. For example, MN or NY.

Uses the .

Street Address (Global)

Populates the column with a street address from anywhere in the world. For example, 10 Rue Morgue.

Uses the .

Street Address (US)

Populates the column with a street address from within the United States. For example, 15 Main Street.

Uses the .

The following generators produce values related to banks and credit cards.

For more information about these generators and how to configure them in the application, go to Banking and finance in the generator reference.

Bank City

Populates the column with the name of a city.

Uses the General column configuration.

Bank Country Code

Populates the column with a 2-character country code. For example, ES, FR, US.

Uses the .

Bank LEI

Populates the column with a legal entity identifier (LEI) for a bank.

Uses the .

Bank Name

Populates the column with the name of a bank in the United States.

Uses the .

Bank RIAD Code

Populates the column with a bank Register of Institutions and Affiliates Data (RIAD) code.

Uses the .

Bank Routing Number

Populates the column with a United States bank routing number.

Uses the .

Bank State

Populates the column with the name of a US state.

Uses the .

Bank Street Address

Populates the column with a street address.

Uses the .

Bank Swift Code

Populates the column with a bank Swift code.

Uses the .

Credit Card Number

Populates the column with a credit card number.

Credit Card Type

Populates the column with a credit card type. For example, Visa, MasterCard, American Express.

Currency Code (Global)

Populates the column with a 3-character currency code for a currency from anywhere in the world. For example, EUR, AUD, JPY.

Uses the .

Currency Code (US)

Populates the column with the 3-character currency code for the United States, USD.

Uses the .

Currency Name (Global)

Populates the column with the name of a currency from anywhere in the world. For example, Euro, Mexican Peso, Yen.

Uses the .

Currency Name (US)

Populates the column with Dollar.

Uses the .

The following generators produce names and other identifying values for an individual.

Fabricate automatically correlates name and gender columns within a table.

For more information about these generators and how they are configured in the application, go to Names and other identifying information in the generator reference.

First Name

Produces a given name, such as John or Mary.

Uses the General column configuration.

Full Name

Produces a full name (given name and family name), such as John Smith and Mary Jones.

Uses the .

Last Name

Produces a family name, such as Smith or Jones.

Uses the .

Middle Name

Produces a middle name. Uses the same set of names as the First Name generator. The middle name is always different from the first name.

Uses the .

Nickname

Produces a common nickname for the person, such as Bobby or Lefty.

Uses the .

Passport Number (Global)

Produces a random passport number that matches the country name or code that is in another column of the table.

Uses the .

Passport Number (US)

Produces a random United States passport number.

Uses the .

Person Name Suffix

Produces a name suffix. The possible suffixes are Jr., Sr., and III.

The suffix is applied to 2% of male names.

Uses the .

Person Name Title

Produces a name title. The possible titles are Mr., Mrs., Ms., and Dr..

The Dr. prefix is applied to 1% of all records.

The remaining titles are distributed evenly among the records, and correspond to the gender of the name columns.

Uses the .

Sex

Populates a column with either Male or Female.

Uses the .

SSN

Populates a column with valid United States Social Security numbers (SSNs).

Username

Populates a column with a username. For example, johndoe.

Uses the .

The following generators produce values related to network locations and files.

For more information about these generators and how to configure them in the application, go to Networks and files in the generator reference.

File Type Extension

Populates the column with a file extension. For example, .txt or .docx.

Uses the General column configuration.

File Type MIME Type

Populates the column with a file MIME type. For example, text/plain or image/jpeg.

Uses the .

IP Address

Populates the column with an IP address. For example, 192.168.1.100 or 2001:0db8:0000:0000:0000:0000:1a2b:3c4d.

MAC Address

Populates the column with a MAC address. For example, 00:1A:2B:3C:4D:5E.

Project Name

Populates the column with the name of a project.

URL

Populates the column with a URL. For example, https://example.com.

User Agent

Populates the column with a user agent value. For example, Mozilla/5.0 (Windows NT 10.0; Win64; rv:110.0.

The following generators produce values related to business organizations and products.

For more information about these generators and how to configure them in the application, go to Companies and products in the generator reference.

Company Domain Name

Populates the column with the domain name for a company. For example, apple.com or tonic.ai.

Uses the General column configuration.

Company Industry

Populates the column with a company industry. For example, Consumer Electronics or Computer Software.

Uses the .

Company IPO Year

Populates the column with a year to represent when the company IPO occurred.

Uses the .

Company Last Sale

Populates the column with a monetary value to represent the amount of the company's most recent sale. For example 150.25.

Uses the .

Company Market

Populates the column with the stock exchange where the company stock is traded. For example, NASDAQ or NYSE.

Uses the .

Company Market Cap

Populates the column with the market cap for the company. For example, 1.5B.

Uses the .

Company Name

Populates the column with the name of a company.

Uses the .

Company Sector

Populates the column with the sector that the company belongs to. For example, Technology.

Uses the .

Company Stock Quote URL

Populates the column with the URL where the company's stock quote can be found. For example, https://www.nasdaq.com/market-activity/stocks/aapl.

Uses the .

Company Stock Ticker Symbol

Populates the column with the ticker symbol for the company. For example, aapl.

Uses the .

EIN

Populates the column with valid United States employer identification number (EIN).

Product Category

Populates the column with a category of product. For example, Health or Electronics.

Uses the .

Product Description

Populates the column with a description of a product.

Uses the .

Product Name

Populates the column with the name of a product.

Uses the .

Product Price

Populates the column with the price of the product.

Uses the .

Product Subcategory

Populates the column with the subcategory that the product belongs to. For example, Oral Care and Hygiene.

Uses the .

The following generator produce values related to airports and flights.

For information about the API data models for these generators, go to in the column attributes.

Airport Code

Populates the column with an airport code. For example, SFO or CDG.

You can configure a .

You can also configure a to link the column to other columns.

To display the column configuration panel, in the column heading, click the settings icon.

For information on the data model for configuring these general properties from the API, go to .

Setting the column name

In the Name field, set the column name.

Getting database information

Getting all of the databases in a workspace

To list all of the databases in a specific workspace:

An entity is equivalent to a database table.

Each entity object can contain the following attributes:

The following generators produce values related to healthcare and health insurance.

For more information about these generators and how to configure them in the application, go to in the generator reference.

Drug Company

Populates the column with the name of a pharmaceutical company. For example, Pfizer.

Uses the .