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