aws-rds-database

SKILL.md

AWS RDS Database

Table of Contents

Overview

When to Use

Quick Start

Reference Guides

Best Practices

Overview

Amazon RDS simplifies relational database deployment and operations. Support multiple database engines with automated backups, replication, encryption, and high availability through Multi-AZ deployments.

When to Use

PostgreSQL and MySQL applications

Transactional databases and OLTP

Oracle and Microsoft SQL Server workloads

Read-heavy applications with replicas

Development and staging environments

Data requiring ACID compliance

Applications needing automatic backups

Disaster recovery scenarios

Quick Start

Minimal working example:

# Create DB subnet group
aws rds create-db-subnet-group \
  --db-subnet-group-name app-db-subnet \
  --db-subnet-group-description "App database subnet" \
  --subnet-ids subnet-12345 subnet-67890

# Create security group for RDS
aws ec2 create-security-group \
  --group-name rds-sg \
  --description "RDS security group" \
  --vpc-id vpc-12345

# Allow inbound PostgreSQL
aws ec2 authorize-security-group-ingress \
  --group-id sg-rds123 \
  --protocol tcp \
  --port 5432 \
  --source-security-group-id sg-app123

# Create RDS instance
aws rds create-db-instance \
  --db-instance-identifier myapp-db \
  --db-instance-class db.t3.micro \
  --engine postgres \
  --engine-version 15.2 \
// ... (see reference guides for full implementation)

Reference Guides

Detailed implementations in the references/ directory:

Guide
Contents

RDS Instance Creation with AWS CLI
RDS Instance Creation with AWS CLI

Terraform RDS Configuration
Terraform RDS Configuration

Database Connection and Configuration
Database Connection and Configuration

Best Practices

✅ DO

Use Multi-AZ for production

Enable automated backups

Use encryption at rest and in transit

Implement IAM database authentication

Create read replicas for scaling

Monitor performance metrics

Set up CloudWatch alarms

Store credentials in Secrets Manager

Use parameter groups for configuration

❌ DON'T

Store passwords in code

Disable encryption

Use public accessibility in production

Ignore backup retention

Skip automated backups

Create databases without Multi-AZ

1d:[