Using the Data Agent chat to manage databases

You use the Data Agent chat to provide instructions to the Agent to perform database and database connection actions, including adding, configuring, and deleting a database or connection.

The chat applies across the entire project. You can refer to any of the databases and connections in the project.

Viewing the SQL or JavaScript for a Data Agent action

To complete an action to a 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.

Displaying the generated SQL for a step

Displaying the generated JavaScript for a step

Prompting the Data Agent to change a database

After you create the initial version of a database, you use the Data Agent to make adjustments to the database structure and the data values.

For example, the Data Agent might create email addresses that all use a single fake email domain. For more realistic data, you can prompt the Data Agent to change the email addresses to use real personal and commercial email domains.

Or you might ask the Data Agent to add new columns or tables.

Uploading files to the Data Agent

To provide information for the Data Agent to work from, you can upload files.

A file might, for example, contain the schema to use (Add a table that uses the attached schema). Examples of schema files include:

• SQL DDL scripts
• prisma.schema scripts
• Swagger YAML API definitions

Or it might contain a set of example values (Add a job title column that uses the attached list of values).

Or it might be a CSV or .xlsx file that contains a list of records (Use the attached Excel file to create a products table.)

You can also upload .jpg and .png images. For example, you might upload an image to show the structure of an invoice form that the Data Agent populates from the data.

To upload files to the Data Agent, either:

• Drag and drop the files to the Data Agent.
• Click the attachment icon, then search for and select the files.

Data Agent chat prompt with the attachment icon highlighted

Note that for a live connection database, you can only import data. You cannot import schema information or other files.

Reverting a change

If a change produces unexpected results, you can provide another prompt to fix the issue.

You can also revert a change and then try again.

You cannot revert changes to a live connection database.

To revert a change, in the Data Agent chat:

1. Hover over the prompt that initiated the change.

Revert option for an action to a Data Agent database

1. Click the revert icon.
2. Confirm that you want to revert the change. The Data Agent reverts the change. It redisplays the prompt so that you can make adjustments to it.