Can't write to retool DB with DBeaver

💬 Queries and Resources
1

  • Goal: Connect to DB with DBeaver and adjust schema

  • Steps: Created SQL to build table in retool

  • Details: table doesn't show up; when I check the DB configuration it doesn't allow me to change the option for allowing DBeaver to write to the database stating this error:
    -Only 'Disable converting queries to prepared statements' can be modified in a RetoolDB resource's configuration

  • Screenshots:

image
image1090×439 23.5 KB

2

Hi @Keyvan,

I don't believe you have to change this setting in the resources to connect to the db with DBeaver. I have mine connected to DBeaver and it works fine.

To set up your db with DBeaver head over to the Retool Database page and copy the Postgres Connection URL:
chrome_kGP1N4oonZ

Then open DBeaver and setup your connection with this information.

dbeaver_9zyLmLZ760

In DBeaver set your URL starting with jdbc:postgresql:// then everything after the @ in the copied URL from Retool. Add the username and pw also found in the URL you copied.

That should be it.

1 Like
3

Thanks, I connect to the retool database just fine, but the create table statements that I run from DBeaver don't get committed to the retool database even if I refresh the database. By default, the "read-only" setting is set in the above mentioned screen. When I try to change the setting on retool so that I can read/write then it shows me that message. Anyone have a solution?

4

Ok, I logged out of retool and logged back in and the table that I tried creating from DBeaver now shows up in the database.

2 Likes