Finding your database credentials is essential for connecting to your SQL database, either through code, or in a tool like BaseDash. It can be tricky to find your credentials when you have an AWS Aurora database is hosted on RDS—we're here to make it simple.
Your database credentials are comprised of five main properties:
All this information is accessible on the AWS dashboard, with the exception of the password, which is not displayed anywhere—you'll only get temporary access to this when you first create your database, so make sure to copy it down.
Go to https://console.aws.amazon.com/rds to open your RDS dashboard. From here, click Databases in the sidebar, then select the database you want to find the credentials for.
Once your database is selected, you should be on the Connectivity & security tab. Here, you'll be able to see your host (labelled Endpoint name) and port. There will be two endpoints here, labelled Writer and Reader. You should use the Writer endpoint if you expect to make edits to your database.
Switch to the Configuration tab. Here, you'll be able to find your database name (labelled DB name), and username (labelled Master username).
Your database name will only show up if you created a database when you initialized your Aurora instance—otherwise, you'll have to manually create a database on your Aurora instance.
Before connecting to your AWS-hosted database from an external app or tool, you'll first need to do two things:
Can can see whether your database is publicly accessible in the Connectivity & security tab.
If the database is not publicly accessible, you can always modify your database by clicking Modify. Under Connectivity,expand the Additional configuration section, then select Publicly accessible. Select Continue and choose Modify DB instance.
The security group associated with the Aurora instance needs to have an inbound TCP rule that gives access to connect to your database. To do this first go to the security group settings.
Next click Edit inbound rules and add the IP address of the tool or server you're connecting to as an inbound TCP rule. For BaseDash, this IP address is 188.8.131.52/32. This is also shown during the Connect data source flow in the app.
When selecting the Type of the inbound rule, use the database type that you are using (e.g. PostgreSQL, MySQL, etc.).
Enter the IP address you're trying to connect from. Take special notice that you must include "/32" at the end of the IP address since that is the format that AWS expects.
BaseDash is an internal tool that lets anyone on your team safely view and edit data from your database. It's simply the best way for teams to manage data, with powerful features like edit history, no-code filtering, and real-time collaboration.
Now that you have your credentials, you can easily connect your database to tools like BaseDash. If you don't have an account yet, sign up for free and create a shared workspace for your company.
To add your database, click "Connect data source" in the sidebar. Select your database type, then select "AWS" as your hosting provider, then enter a human-readable name for your database. After that, we'll show you the IP address you need to add as an inbound rule on AWS (184.108.40.206/32).
Finally, you can enter your credentials and successfully connect your database to BaseDash! We pre-fill some information based on your database type to save you some time.
We include video guides in the form to help you through the process. If you're still having trouble connecting your database, you can contact us for help.