Skip to main content

Access Retool Database tables externally

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

Export data as a CSV​

You can export a copy of table data at any time in CSV format. Open the Table options menu for an existing table and select Export CSV.

Alt text

In the Query Library, you can also export CSVs after running SQL commands. Click the Download csv button next to the query results to download a CSV of your data.

Use Retool Workflows with Retool Database​

With Retool Workflows, you can schedule ETL tasks to push and pull data between Retool Database and third-party endpoints and integrations. In a Workflows Query block, select retool_db as the resource to access Retool Database data.

Using Retool DB in Workflows blocks

Connection strings​

Admins can view connection strings on the Connection tab in the Settings modal, accessed from the dropdown on the Retool Database title. Retool provides connection strings as PSQL commands and PostgreSQL connection URLs. On Retool Cloud, you can reset your database password for the current environment by selecting Reset Password in this tab.

Connection string with Reset Password option

You can copy the PSQL command directly to the command line, or use the PostgreSQL connection URL in external applications. For example, use the connection URL in PostgreSQL clients such as PgAdmin, platforms such as Zapier, or any ORM which connects to PostgreSQL. Some tools may not support connection strings with role names and passwords, so you may need to enter these fields directly.

Tables created using connection strings might not immediately show up in the Retool Database UI. To display a new table, click the menu in the top left corner and select the table.

For cloud-hosted organizations on the Free plan, Retool automatically pauses the Retool Database service after one month of inactivity. Any existing connection strings will no longer work. Once you start using Retool Database again, updated connection strings are available.