This covers the essentials of spinning up and managing relational databases on AWS RDS, from PostgreSQL and MySQL to Oracle workloads. The quick start walks through creating subnet groups, security groups, and launching instances via CLI, while the reference guides include Terraform configs and connection setup. It's practical if you need Multi-AZ deployments, read replicas, or automated backups without managing the underlying infrastructure yourself. The best practices section is straightforward about the important stuff like encryption, IAM auth, and keeping credentials out of code. Good starting point for transactional databases and OLTP workloads when you want AWS handling the ops heavy lifting.

skills.sh installs
453
GitHub stars
379
last updated
Aug 21, 2026

Install

$ npx -y skills add aj-geddes/useful-ai-prompts --skill aws-rds-database --agent claude-code

Installs into .claude/skills of the current project.

Files

AWS RDS Database

Table of Contents

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

Sponsors

Details

Repository
github.com/aj-geddes/useful-ai-prompts
Categories
Backend & APIs, Security, DevOps & CI/CD, AI & Agent Building, Release Management, Cloud & Infrastructure, Databases
First seen
Jun 3, 2026

More from aj-geddes/useful-ai-prompts

All 258
1davila7 avatarbackend-patternsdavila7/claude-code-templatesBackend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes.452skills.sh installs
2secondsky avatardatabase-schema-designsecondsky/claude-skillsDatabase schema design for PostgreSQL/MySQL with normalization, relationships, constraints. Use for new databases, schema reviews, migrations, or encountering m437skills.sh installs
3jezweb avatarbetter-authjezweb/claude-skillsSelf-hosted auth for TypeScript/Cloudflare Workers with social auth, 2FA, passkeys, organizations, RBAC, and 15+ plugins. Requires Drizzle ORM or Kysely for D1 434skills.sh installs
4secondsky avatarnuxt-serversecondsky/claude-skills| Nuxt 4 server-side development with Nitro: API routes, server middleware, database integration, and backend patterns. Use when: creating server API routes, im415skills.sh installs
5mrgoonie avatarbetter-authmrgoonie/claudekit-skillsImplement authentication and authorization with Better Auth - a framework-agnostic TypeScript authentication framework. Features include email/password authenti396skills.sh installs
6davila7 avatarfirebasedavila7/claude-code-templatesFirebase gives you a complete backend in minutes - auth, database, storage, functions, hosting. But the ease of setup hides real complexity. Security rules are 390skills.sh installs