Creating and managing Data Agent databases
Creating a Data Agent database
To create a Data Agent database:
Click the create database icon that is next to the database dropdown at the top right.
For Enterprise users, on the database creation page, click Data Agent database. Free and Plus users go directly to the new database panel.
On the new database panel, in the Database Name field, provide a name for the database.
If you are not creating a live connection database, then click Create Database. Fabricate displays a field for you to get started.
Provide an initial prompt to tell the Data Agent about the data to create. The prompt might be a simple instruction. For example:
Create a database of consumer transactions. The database includes transactions, customers, and products.You might also paste in a specific schema for the Data Agent to use. For example:Create a database of consumer transactions that uses the following schema.You can also upload files to provide information for the Data Agent to use. For example, instead of pasting in the schema, you can upload a file, drag and drop the file to the Data Agent, or click the attachment icon. Examples of schema files include:QL DDL scripts
prisma.schema scripts
Swagger YAML API definitions
The Data Agent analyzes the request, and if needed asks clarifying questions about the data values, the volume of data, and the relationships between the tables. If you provided a schema that contains more than 10 tables, then the Data Agent automatically switches to Plan mode. It creates a plan to create the database, which you can then review and execute. When you send the initial prompt, the Data Agent chat moves to the right side of the page.
You can provide answers to further shape the data, and optionally tell the Data Agent to use its own judgment for some elements of the data. For example:
Create 70 customers. Each customer has 1-3 orders. Each order has 1-5 products. You can choose the distribution of the customers throughout the United States.When it has enough information to work from, the Data Agent creates the database structure and then populates the database, then provides a summary of the results.
Creating a live connection database
Live connection databases are currently in private preview. To request access, contact Tonic.ai.
Live connection databases require an Enterprise license.
For Fabricate to connect to an external database, you must allow list the following IP addresses:
34.224.174.7
By default, a Data Agent database generates data in Fabricate. You can then export the data to files or to a database.
A live connection database generates data directly to an external database.
On the new database panel, to indicate to create a live connection database, check the Use live database connection checkbox.
When you create a live connection database, you identify the first database connection. A database connection consists of:
A server connection. You can configure available server connections for a workspace.
The database name.
To connect to the database:
From the Server dropdown list, select the server connection where the database is located. To create a new server connection, select new connection, then provide the details for the connection. Fabricate adds the connection to the available server connections for the workspace. To edit the selected server connection, click Edit. Note that any changes to the configuration apply wherever the server connection is used.
In the Database field, provide the name of the database.
To verify that Fabricate can connect to the database, click Test Connection.
To create the database, click Create Project.
Fabricate analyzes the database schema to determine the data structure. It displays the list of tables and selects the first table.
Below the table list, the Connections section lists the database connections for the current database.
The first database connection is marked as the default database connection, and is initially assigned the name default.
Selecting a Data Agent database to manage
To select a Data Agent database to manage:
Click the database dropdown at the top right. For Enterprise users, the list of databases can include both rule-based and Data Agent databases.
In the dropdown list, select the database. You can use the search field to look for a specific database by name.
Cloning a Data Agent database
You can create a new database as a clone of an existing database. For example, you might want a similar set of data that uses international names and addresses.
You cannot clone a live connection database.
When you clone a Data Agent database, you choose whether to preserve the chat history from the original database. By default, the history is not preserved.
To clone a Data Agent database.
In the table list, hover over the database name.
Click the copy icon.
On the Clone Database panel:
In the New Database Name field, provide the name for the new database.
To include the chat history from the original database, check the Include chat history checkbox.
Click Clone Database.
Renaming a Data Agent database
Click the edit icon next to the database name above the table list.
To change the name of a Data Agent database:
In the table list, hover over the database name.
Click the edit icon.
In the New Database Name field, provide the new name for the database.
Click Rename Database.
Deleting a Data Agent database
Click the delete icon next to the database name above the table list.
To delete a Data Agent database.
In the table list, hover over the database name.
Click the delete icon.
On the confirmation panel, click Delete Database.
Last updated
Was this helpful?