Amazon RDS + SQLectron

Project Overview:

This project demonstrates how to deploy and manage a cloud-hosted relational database using Amazon RDS, and how to securely connect to it using SQL Electron, a lightweight and cross-platform SQL database client. The goal of this setup is to show practical cloud infrastructure skills, database administration, and secure connectivity between cloud services and local tools.

Objective

To create, configure, and interact with a scalable, managed relational database running on Amazon RDS, and use SQL Electron to perform database operations such as creating tables, inserting data, and running queries.

Technologies Used

Amazon RDS (MySQL) fully managed relational database.
AWS Management Console database deployment and configuration.
SQL Electron GUI client for connecting to the RDS instance.
Security Groups to manage inbound database traffic.
IAM secure access management.

Project Architecture

1. Amazon RDS instance deployed in a secure AWS VPC.
2. SQL Electron installed on the local machine.
3. Security group rules configured to allow controlled access from your IP to the RDS port (3306 for MySQL ).
4. SQL Electron connects to the RDS endpoint using database credentials.
5. User performs SQL operations (CRUD queries, table creation, etc.) via SQL Electron.

Steps taken to complets this project :

1. Launch Amazon RDS Instance

Selected database engine (MySQL).
Chose a free tier eligible instance class.
Set admin username & password.
Configured VPC, subnets, and availability zone.
Enabled automatic backups and monitoring.

2.Configure Security Group

Created a security group allowing inbound traffic from Anywhere.
Opened the appropriate port (3306 ).

3. Retrive Connection Details

Copied the RDS endpoint.
Noted down the port, username and password.

4. Connect Using SQL Electron

Opened SQL Electron and created a new connection.
Succefully connected to the cloud database.

5. Run SQL Queries

Create new databases.
Create new tables.
Insert rows

Final Outcome

A fully functional cloud hosted SQL database running on Amazon RDS, securely accessible via SQL Electron from a local environment. This project highlights real-world cloud engineering abilities deploying, connecting, and managing a relational database in AWS.