home / skills / partme-ai / full-stack-skills / cloud-aws-rds

cloud-aws-rds skill

safe

This skill guides you through AWS RDS setup, configuration, backups, and management, delivering practical steps to deploy and maintain databases.

npx playbooks add skill partme-ai/full-stack-skills --skill cloud-aws-rds

Review the files below or copy the command above to add this skill to your agents.

Files (2)

SKILL.md

649 B

---
name: cloud-aws-rds
description: Provides comprehensive guidance for AWS RDS including database creation, configuration, backups, and RDS management. Use when the user asks about AWS RDS, needs to create RDS databases, configure RDS, or manage AWS database services.
license: Complete terms in LICENSE.txt
---

## When to use this skill

Use this skill whenever the user wants to:
- [待完善：根据具体工具添加使用场景]

## How to use this skill

[待完善：根据具体工具添加使用指南]

## Best Practices

[待完善：根据具体工具添加最佳实践]

## Keywords

[待完善：根据具体工具添加关键词]

Overview

This skill provides hands-on, practical guidance for managing Amazon RDS databases across engines (MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Aurora). It covers creation, configuration, backups, monitoring, security, and common operational tasks to keep databases reliable and cost-effective. The content is actionable and focused on real-world scenarios for developers and operators.

How this skill works

The skill inspects typical RDS requirements and walks through step-by-step actions: choosing engine/instance class, setting storage and networking, enabling automated backups and snapshots, and configuring monitoring and alerts. It explains recommended parameter and option configurations, IAM roles and security groups, and procedures for upgrades, failovers, and read replica setup. It also outlines automation patterns using the AWS CLI, CloudFormation, and Terraform for repeatable deployments.

When to use it

Creating a new managed database on AWS with guidance on engine and instance selection
Configuring backups, retention, and point-in-time recovery for production databases
Setting up replication, read replicas, or high-availability Multi-AZ deployments
Hardening RDS with network, encryption, and IAM best practices
Migrating on-prem or self-hosted databases to Amazon RDS
Designing monitoring, alerting, and performance tuning workflows

Best practices

Choose the right engine and instance class based on workload profiles and storage IOPS needs
Enable Multi-AZ for production and automated backups with an appropriate retention window
Use parameter groups for consistent settings and option groups only when needed
Restrict network access with VPC security groups and enable encryption at rest and in transit
Automate deployments and schema migrations using IaC (CloudFormation/Terraform) and CI/CD
Implement CloudWatch alarms, enhanced monitoring, and slow query logging for visibility

Example use cases

Provisioning a PostgreSQL RDS instance with automated backups, encryption, and read replica for scaling reads
Migrating a MySQL database from EC2 to RDS using AWS Database Migration Service with minimal downtime
Configuring Multi-AZ SQL Server with proper parameter group and automated patching window
Setting up performance monitoring and tuning for a bursty application using enhanced monitoring and RDS Performance Insights
Implementing automated snapshot lifecycle and cross-region copy for disaster recovery

FAQ

Which database engines are supported?

Amazon RDS supports MySQL, PostgreSQL, MariaDB, Oracle, Microsoft SQL Server, and Amazon Aurora (MySQL and PostgreSQL compatible). Choose based on feature needs and licensing.

How do automated backups and point-in-time recovery work?

Automated backups capture daily snapshots and transaction logs. With automated backups enabled, you can restore to any second within the retention window using point-in-time recovery.