Hey Dennis,
It certainly is possible, there are a few ways of doing that. Using PR Environments and the render.yaml file, you can dynamically set the initialDeployHook [https://render.com/docs/preview-environments#preview-environment-initialization], which will run after the first successful deploy and before your service’s start command.
And you can also dynamically set your environments variables (feeding your cockroach DB new URL): https://render.com/docs/preview-environments#environment-variables
Make sure that “previewsEnabled” is set to “true” in our render.yaml file.
Regards.
Jérémy, Render Support