How do I connect my Amazon RDS to DBeaver?

Share

In this answer, I am creating PostgreSQL RDS in AWS as an example, Follow the below steps,
In AWS Console,
  1. Select your database in the RDS dashboard
  2. Click on “Modify”
  3. In the “Connectivity” section, click on “Additional Configurations”
  4. Select Public option
  5. Save changes with Immediate Apply option
  6. Go inside your database by clicking the database name
  7. Click on security group associated with this database
  8. Add a new inbound rule to allow all traffic on port 5432(PostgreSQL database default port)
In the DBeaver tool,
  1. Click on the New Database Connection option
  2. Select database as PostgreSQL
  3. Enter the host as your endpoint name in the Connectivity & Security section of your database details
  4. Add port
  5. Add database name as your rds database name
  6. Enter username and password and try to test the connection


Hope this might have helped you.


Share

Leave a Comment