There's the option to do a schema migration between environments. There was a bug in that migration, solved in 3.18
However, it's migrating only the schema.
We should be able to do also migration of data.
There's no workaround possible with a Workflow.
The only way I can see for now is to it manually.
@MicExpert Thanks for posting. We do have a feature request for this functionality, it's not currently on the roadmap, but I've added your request to it. You are correct that this must currently be done manually or with a tool like pgsync.
@Matti it shouldn't matter if you are using Retool cloud vs self-hosted as long as you have the connection information, you can use a third party to help transfer the schema etc.
You should be able to find the connection information on the Connection tab of the Retool Database dropdown: