mcpField
A
aws-rds-database

aws-rds-database

github.com/aj-geddesCloud & DevOps373450 installsUpdated 34w ago
Repository

About aws-rds-database

A practical skill for deploying and operating Amazon RDS relational databases. It covers common database workloads and provides AWS CLI and Terraform reference guides alongside operational and security guidance.

Key features

  1. 01PostgreSQL、MySQL、Oracle 和 SQL Server 场景
  2. 02AWS CLI 创建实例指南
  3. 03Terraform 配置参考
  4. 04备份、加密与 Multi-AZ 建议

Use cases

  1. 01部署事务型数据库
  2. 02为读密集型应用配置只读副本
  3. 03准备开发和预发布环境
  4. 04规划备份与灾难恢复

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill aws-rds-database

After installing, type/aws-rds-databasein Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

references/
database-connection-and-configuration.md
rds-instance-creation-with-aws-cli.md
terraform-rds-configuration.md
scripts/
validate-schema.sh
templates/
migration-template.sql

Details

From the project README

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

# 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:

GuideContents
RDS Instance Creation with AWS CLIRDS Instance Creation with AWS CLI
Terraform RDS ConfigurationTerraform RDS Configuration
Database Connection and ConfigurationDatabase 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

Comments

Markdown supported