Release notesFabricateTonic.ai

Adding a table to a database

To add a table to a database, you can:

  • Create a completely new table

  • Clone an existing table

  • Import data from a .csv file

Creating a completely new table

To create a table:

  1. Click Add Table(s).

  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:

    • SQL DDL script

    • OpenAPI spec

    • Content from another type of script or definition file, such as a JSON or XML schema or a DTD. The Fabricate AI then attempts to interpret the information and then use it to set up the table.

    • A prompt that describes the table. For example, "Create a table that tracks customers, including the mailing address, email address, and telephone number". The Fabricate AI uses that as the basis to set up an initial version of the table.

  4. Optionally, expand More options, and in the AI Hints field, provide an additional prompt to help further define the table columns. For example, you might indicate specific generators to use, or provide limits on specific values.

  5. Click Add Table.

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.

  4. Click Clone Table.

Creating a table from imported data

You can create a table from an imported CSV 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 Import Data.

  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.

Fabricate table that is imported from a file

Last updated