> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superjoin.ai/llms.txt
> Use this file to discover all available pages before exploring further.
# Connect your AWS RDS Database to Google Sheets
> Quickly link your AWS RDS database to Google Sheets for hassle-free data integration and visualization.
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
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.
Select MySQL (for RDS as well) from the list of available data sources.
Enter your connection credentials.
| Field | Description | Example |
| -------- | --------------------------------------------------------- | --------------------------------------------------------- |
| Host | This will be the endpoint of your RDS instance. | your-db-instance.123456789012.us-east-1.rds.amazonaws.com |
| Port | Use the specific port for your MySQL database. | Default is 3306 |
| Database | Specify the name of the database you want to query. | initialdatabase |
| User | Enter the username for connecting to your MySQL database. | admin or user123 |
| Password | Provide 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.
Log in to the AWS Management Console.
Navigate to the RDS dashboard and select your database instance.
Under the 'Connectivity & Security' section, find the 'Endpoint' and 'Port' information.
Click "Authorize" to establish the connection. Superjoin will open the Data Preview upon successful creation, allowing you to start querying your database.
