Access Retool Database tables externally
To access Retool Database data outside of your apps, you can:
- Export a CSV of your data.
- Use Retool Workflows to connect it to other data sources and integrations.
- Use connection strings to access your data in SQL clients or external applications.
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.
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.
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.
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.