If you’re getting started with AWS Cloud, one of the most useful services you’ll come across is Amazon RDS (Relational Database Service). It allows you to create, manage, and scale relational databases in the cloud—without worrying about the complexities of infrastructure management.

In this post, we’ll go through the step-by-step process to create a free Amazon RDS MySQL or PostgreSQL database using the AWS Free Tier.

🚀 What is Amazon RDS?

Amazon RDS is a managed database service that makes it easy to set up, operate, and scale a relational database in the cloud. It supports popular engines like MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server.

With RDS, AWS handles routine tasks such as backups, patching, and monitoring—so you can focus on building your application rather than managing infrastructure.

🧩 Why Use Amazon RDS?

Fully Managed: No need to manually configure or maintain servers.
Highly Scalable: You can increase storage and performance as your app grows.
Automatic Backups: RDS provides automated backups and snapshots.
Secure: AWS ensures encryption, network isolation, and IAM integration.
Free Tier Eligible: You can experiment with databases at no cost for 12 months.

🧭 Step-by-Step: Create an Amazon RDS Database

1️⃣ Go to the RDS Console

Sign in to your AWS Management Console.
In the search bar, type “RDS” and open the service.

2️⃣ Click Create Database

You’ll see an option to create a new database. Click “Create database.”

3️⃣ Choose Standard Create

This gives you full control over configuration options.

4️⃣ Select a Database Engine

Choose either:

MySQL (commonly used for web apps)
PostgreSQL (known for strong performance and reliability)

5️⃣ Choose the Free Tier Template

Select the Free Tier option to ensure your setup stays within free usage limits.

6️⃣ Configure Basic Settings

DB instance identifier: mydbfree
Master username: admin
Password: Create and confirm a strong password.

7️⃣ Choose Instance Type

Select db.t3.micro — this is the Free Tier-eligible instance type.

8️⃣ Storage Settings

Leave default storage as 20GB GP2 (General Purpose SSD).

9️⃣ Connectivity

Under Connectivity, select Don’t connect to EC2 for now.
Keep other default settings unless your app requires custom configurations.

🔟 Create the Database

Review your configuration.
Click “Create database.”

AWS will take a few minutes to deploy your RDS instance.

✅ Verify Your Database

Once the status shows “Available”, your RDS instance is running successfully!

You can now connect using tools like:

MySQL Workbench
pgAdmin
Or via your application’s connection string.

💡 Important Tips

Keep your RDS instance running only for the challenge or testing.
Delete it once done to keep your AWS account organized.
Even if you keep it, it’s still free under the Free Tier—but cleanup helps avoid clutter.

🎥 Watch the Full Tutorial

If you prefer a visual walkthrough, check out my YouTube tutorial on this topic:
👉 https://www.youtube.com/watch?v=WgqTtoxGB8I

🔖 Conclusion

You’ve just created your first Amazon RDS database on AWS! 🎉
By using the Free Tier, you can practice database management without spending a dime. Whether you’re preparing for cloud certifications or building your next app, RDS is an essential skill to master.