Connect your AWS RDS PostgreSQL or MySQL database to VexiData for natural language querying and dashboard creation. This guide covers security group configuration and connection setup.

Connect AWS RDS to VexiData

Click to play video

Prerequisites

A VexiData account (free tier available)Create account
An AWS account with an RDS database instanceAWS RDS Console
Access to AWS Management Console

Connection Steps#

Get RDS Endpoint

1. Log in to the AWS Management Console

2. Navigate to RDS > Databases

3. Select your database instance

4. In the Connectivity & security tab, find the Endpoint (hostname)

Configure Security Group

AWS RDS instances are protected by security groups. Add VexiData's IP addresses:

1. In the RDS console, click on the VPC security group link

2. Select the security group and click Edit inbound rules

3. Add two new rules with VexiData's IPs:

• 139.59.53.167/32

• 165.22.217.42/32

4. Set port to 5432 (PostgreSQL) or 3306 (MySQL)

5. Click Save rules

Ensure Public Accessibility

If your RDS instance is not publicly accessible:

1. Go to your RDS instance Modify settings

2. Under Connectivity, enable Publicly accessible

3. Apply the changes (may require a restart)

Get Database Credentials

You'll need:

• Endpoint: Your RDS endpoint (e.g., mydb.xxx.us-east-1.rds.amazonaws.com)

• Port: 5432 (PostgreSQL) or 3306 (MySQL)

• Database name: Your database name

• Master username: Your database username

• Password: Your database password

Connect in VexiData

In VexiData, go to Data Sources from the menu, then select PostgreSQL or MySQL under the Add New Data Source section based on your RDS engine.

text

Display Name:    My AWS RDS Database
Host:            mydb.xxx.us-east-1.rds.amazonaws.com
Port:            5432 (or 3306 for MySQL)
Database:        your_database_name
Username:        your_master_username
Password:        your_database_password

Test and Save

Click Test & Save Connection. Once successful, you can start querying your AWS RDS data!

Security Group Configuration

Make sure to add both VexiData IP addresses to your security group inbound rules. Without this, the connection will timeout.

Search Documentation