aws-rds-database

@aj-geddes · 收录于 5 天前 · 上游提交 4 个月前

Deploy and manage relational databases using RDS with Multi-AZ, read replicas, backups, and encryption. Use for PostgreSQL, MySQL, MariaDB, and Oracle.

场景数据库部署高可用配置备份恢复

适合你，如果你需要管理 AWS RDS 数据库实例

/ 下载安装

https://github.com/aj-geddes/useful-ai-prompts/tree/main/skills/aws-rds-database ↗

/ 通过 npx 安装 校验哈希

npx oh-my-skill add aj-geddes/useful-ai-prompts/aws-rds-database

/ 通过 bash 安装

curl -fsSL https://oh-my-skill.com/install.sh | bash -s -- aj-geddes/useful-ai-prompts/aws-rds-database

/ 已经装过?验证本机副本,不用重装

npx oh-my-skill verify aj-geddes/useful-ai-prompts/aws-rds-database

安装目标可用 --agent / --scope 或 --to 明确指定;省略时只会在唯一已存在的 agent 目录上自动选择,零命中或多命中会停止并提示。content_hash 缺失或不一致均拒装。

300GitHub stars

~476最小装载

~1.6K含声明引用

~1.7K文本包总量

索引托管

怎么用

商店整理自技能原文 · 版本 3f5182c · 表述以原文为准

它做什么

装上后，Claude 可以根据你的要求，使用 AWS CLI 或 Terraform 部署和管理关系型数据库（如 PostgreSQL、MySQL、MariaDB、Oracle），包括创建实例、配置子网组、安全组、备份、加密和多可用区部署。

什么时候触发

当你要求创建、配置或管理 AWS RDS 数据库实例时触发，例如需要部署 PostgreSQL 或启用自动备份等场景。

装好后可以这样说

Claude 将生成相应的 AWS CLI 命令。

Claude 会配置高可用和备份策略。

Claude 会生成 Terraform 配置代码。

技能原文 SKILL.md作者撰写 · MIT · 3f5182c

AWS RDS Database

[Overview](#overview)
[When to Use](#when-to-use)
[Quick Start](#quick-start)
[Reference Guides](#reference-guides)
[Best Practices](#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](references/rds-instance-creation-with-aws-cli.md) | RDS Instance Creation with AWS CLI | | [Terraform RDS Configuration](references/terraform-rds-configuration.md) | Terraform RDS Configuration | | [Database Connection and Configuration](references/database-connection-and-configuration.md) | 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

按 MIT 许可原样转载,未经改动 · 在 GitHub 查看 →

登录即可评论;带「已验证安装」的,是发布者名下有本店的安装或持有记录。

…