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.
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.
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.
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.
Note that for a live connection database, you can only import data. You cannot import schema information or other files.
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:
Hover over the prompt that initiated the change.
Click the revert icon.
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.
Last updated
Was this helpful?
Was this helpful?
