Skip to main content
Superjoin has revolutionized the way organizations connect to RDS databases, offering secure and efficient connection solutions. This guide will walk you through setting up a connection with Superjoin, ensuring you can leverage the full capabilities of Superjoin with your MySQL database. 🚀

​
Step-by-step walkthrough: How to connect RDS to Google Sheets

1

Launch Superjoin

Once Superjoin is installed, navigate to the Extensions menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.
2

Pick MySQL

Select MySQL (for RDS as well) from the list of available data sources.
3

Connect your MySQL Database

Enter your connection credentials.
FieldDescriptionExample
HostThis will be the endpoint of your RDS instance.your-db-instance.123456789012.us-east-1.rds.amazonaws.com
PortUse the specific port for your MySQL database.Default is 3306
DatabaseSpecify the name of the database you want to query.initialdatabase
UserEnter the username for connecting to your MySQL database.admin or user123
PasswordProvide the password corresponding to the specified user.password123
For using AWS RDS (Relational Database Service), you will typically gather the same types of credentials. However, the process may include some AWS-specific steps.
If you’re connecting to a PostgreSQL RDS instance which is running PostgreSQL version 15 or higher, you must enable the enforce SSL toggle beflow the password field.
4

Login to AWS

Log in to the AWS Management Console.
5

Navigate to RDS

Navigate to the RDS dashboard and select your database instance.
6

Identify endpoint (host) & port

Under the ‘Connectivity & Security’ section, find the ‘Endpoint’ and ‘Port’ information.
7

Connect to your RDS Database

Click “Authorize” to establish the connection. Superjoin will open the Data Preview upon successful creation, allowing you to start querying your database.