1. There’s no way for the customer to generate backups today, but we do daily backups on our end. If anything were to happen to the data, we can probably help.
https://docs.retool.com/docs/retool-database#how-safe-is-my-data: "Retool Database stores your data in a Postgres cluster managed by our cloud provider. Retool uses multiple levels of redundancy, which include daily backups of all data. If you have any questions or would like to know more, please get in touch."
2. Yes! We are currently testing a feature that allows customers to connect to Retool DB via external REST API access. It’s not launched just yet, but it’s on the roadmap
To update this thread with the latest, Retool Database now offers connection strings as the method to interact with your data externally (we are no longer pursuing a REST API). This is currently being rolled out to all cloud organizations for you to be able to connect with whatever Postgres client you'd like (psql, pg_admin, SDKs). If you don't see that in the UI yet you will soon!