How to Connect Your AWS RDS MySQL Database to Indiequery

Last updated: November 21, 2025

Connect your AWS RDS MySQL database to Indiequery to query and explore data through a web interface. No desktop apps, no SSH. Just copy your connection details from the AWS console and connect in minutes.

Get Your RDS Connection Details

Log into the AWS Management Console and navigate to the RDS service. Click Databases in the left sidebar, then select your MySQL instance to view its details.

Find the Endpoint and Port

On the Connectivity & security tab, you'll find your database endpoint and port. Copy the Endpoint - this is your database host and looks like database-1.abc123xyz.us-east-1.rds.amazonaws.com. The default port for MySQL is 3306, but note your specific port if you customized it during setup.

Find the Database Name

Switch to the Configuration tab to find your database name. Look for DB name in the configuration details. If you didn't specify a database name during creation, you'll need to create one after connecting.

Get Your Credentials

You set the master username and password when you created the RDS instance. The default username is typically admin. If you forgot the password, you can reset it by selecting Modify on your instance in the RDS console.

Connect to Indiequery

Go to app.indiequery.com and click Add Database Connection. Enter your connection details from the AWS console:

  1. Host - Paste the endpoint from the Connectivity & security tab
  2. Port - Enter 3306 (or your custom port)
  3. Database - Enter the DB name from the Configuration tab
  4. Username - Enter your master username (default: admin)
  5. Password - Enter your master password
  6. Keep "Require SSL" checked (RDS requires SSL by default)
  7. Click Add Connection

Indiequery tests the connection automatically. Once successful, start querying.

Make Your RDS Instance Accessible

RDS instances are private by default. To connect from Indiequery, you need to configure public accessibility and security groups.

Enable Public Accessibility

Select your database instance in the RDS console and click Modify. Under Connectivity, find Public access and select Yes. Click Continue and apply the changes. This allows connections from outside your VPC.

Configure Security Group

Your RDS instance uses a security group to control inbound traffic. You need to allow connections on port 3306.

Go to the Connectivity & security tab on your instance and click the security group listed under VPC security groups. Select the Inbound rules tab and click Edit inbound rules. Add a new rule with type MySQL/Aurora, port 3306, and set the source to your IP address or CIDR block.

For testing, you can use 0.0.0.0/0 to allow any IP, but this is not recommended for production due to security risks. Instead, use your specific IP address or a restricted CIDR block. Click Save rules when done.

Common Connection Issues

"Connection timed out"

Verify that Public access is set to Yes in your RDS instance settings. Check that your security group has an inbound rule allowing port 3306 from your IP address. Confirm you're using the endpoint from Connectivity & security, not an internal IP. Also verify your VPC has an internet gateway attached.

"SSL connection required"

RDS requires SSL by default. Keep "Require SSL" checked in Indiequery when adding your connection.

"Authentication failed"

Verify your username and password are correct. The default username is usually admin. If you forgot the password, use Modify in the RDS console to reset it. Remember that passwords are case-sensitive.

"Unknown database"

Check the DB name on the Configuration tab. Database names in MySQL are case-sensitive, so ensure you're using the exact name. If no database was created during instance setup, you'll need to create one first.

"Could not connect to server: Host not found"

You may be using the instance identifier instead of the endpoint. Use the full endpoint from the Connectivity & security tab, which includes the region (e.g., .us-east-1.rds.amazonaws.com).

Security Best Practices

While 0.0.0.0/0 makes testing easier, it allows connections from any IP address. For production databases, use your specific IP address or a restricted CIDR block in the security group. Consider using AWS VPN or Direct Connect for secure access. Rotate database passwords regularly and enable IAM database authentication for additional security.

Next Steps

Once connected:

  • Browse database schema and tables
  • Run SQL queries with autocomplete
  • Create visualizations from results
  • Save and reuse queries
  • Build dashboards
  • Share results publicly

Head to app.indiequery.com and start exploring your AWS RDS database.

← Back to Hosting Integration