Manage data in Retool Database

Learn how to manage data in Retool Database.

Access externally

To access Retool Database data outside of your apps, you can:

Import CSVs

To import existing CSV-formatted data, drag a CSV file onto the drop zone. Convert your file to a CSV before you upload it, as XLSX files are not supported. Once you upload a file, Retool attempts to identify the type for each field and map it to an appropriate field type to create a table schema.

Link between tables

You can link records between tables in the Database editor UI to see relevant data in one place. For example, you could link a table with order information to another table with user details. The foreign keys field references a field from another table that contains unique values, such as the primary key. Once a value is set, you can view the relevant linked record.

Manage tables and records

You can use the Database Editor to visually interact with tables and their records much like a spreadsheet. To access the Database Editor, sign in to your Retool organization and select the Database tab.

Multiple environments

1 items