Creating and managing Data Agent databases

Creating a Data Agent database

To create a Data Agent database:

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

2. For Enterprise users, on the database creation page, click Data Agent database. Free and Plus users go directly to the new database panel.

3. On the new database panel, in the Database Name field, provide a name for the database, then click Create Database. The database details page displays, with the Data Agent chat window on the right.

Database details for a new Data Agent database

1. In the chat, 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:

   • SQL DDL scripts

   • prisma.schema scripts

   • Swagger YAML API definitions

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

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

4. When it has enough information to work from, the Data Agent creates the database structure and then populates the database. It also provides a summary of the results.

Selecting a Data Agent database to manage

To select a Data Agent database to manage:

1. Click the database dropdown at the top right. For Enterprise users, the list of databases can include both rule-based and Data Agent databases.

Database dropdown list to select a database to manage

1. In the dropdown list, select the database.

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.

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.

1. In the table list, hover over the database name.

Edit, clone, and delete icons for a Data Agent database

1. Click the copy icon.

2. On the Clone Database panel:

   1. In the New Database Name field, provide the name for the new database.

   2. To include the chat history from the original database, check the Include chat history checkbox.

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

1. In the table list, hover over the database name.

Edit, clone, and delete icons for a Data Agent database

1. Click the edit icon.

2. In the New Database Name field, provide the new name for the database.

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

1. In the table list, hover over the database name.

Edit, clone, and delete icons for a Data Agent database

1. Click the delete icon.

2. On the confirmation panel, click Delete Database.