Supported DB types: MySQL, PostgreSQL, Redshift, MariaDB, SQL Server
Dashboard URL: https://console.aws.amazon.com
BaseDash supports connecting to PostgreSQL, MySQL, MariaDB, Sequel Server and Aurora databases created with RDS. Basedash also allows for connections to Redshift.
RDS (including Aurora)
- Go to https://console.aws.amazon.com/rds
- Select RDS database you want to connect to Basedash. You'll find your host and port under the Connectivity & security tab.
- You can find the username in the Configuration tab under the Master username label.
- The database name will be found under the DB name label if you created a database at the point of creation of the RDS instance, otherwise the database name will be the name of whatever database you've created manually on your RDS instance.
- The database password is not display anywhere, so you must store it yourself upon creation of the RDS instance.
- The security group associated with the RDS/Redshift instance should have an inbound TCP rule that gives access to the Basedash server to connect to your database.
- Go to https://console.aws.amazon.com/redshiftv2 and select the cluster you'd like to connect to.
- Copy the Endpoint found under the General information tab. The endpoint is made up of your host, database name, and port.
For example, given an endpoint of
redshift-cluster-1.ckkt2wnen3zc.us-east-1.redshift.amazonaws.com:5439/dev, the host is
redshift-cluster-1.ckkt2wnen3zc.us-east-1.redshift.amazonaws.com, the port is
5439, and the database name is
- Similarly to the RDS instructions above, the password cannot be found in the AWS console and must be saved on your end at the time of the Redshift cluster's creation. Also, make sure the cluster is publicly available and the security group associated with the cluster's VPC has an inbound TCP rule that gives access to the Basedash server.