rds

The RDS skill provides a comprehensive toolkit for automating the lifecycle management of Amazon Relational Database Service instances. It is designed for cloud engineers and DevOps professionals who need to maintain production-grade databases with minimal manual intervention. The skill handles the complexity of provisioning, performance tuning, and high availability configurations, allowing agents to perform tasks ranging from initial setup to complex disaster recovery operations.

• Full support for provisioning DB instances using CLI or Boto3 SDK, including engine selection (PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, Aurora).

• Advanced configuration management for Multi-AZ deployments, read replica scaling, and storage type selection (gp3, io1, io2).

• Automated security procedures including VPC security group management, KMS encryption at rest, SSL in transit, and Secrets Manager integration for credential rotation.

• Operational task execution such as manual snapshot creation, point-in-time recovery (PITR), parameter group tuning, and instance class modification.

• IAM-based database authentication setup to reduce reliance on static database passwords and improve security posture.

• Users should provide specific instance identifiers, engine versions, and VPC configuration details when initiating provisioning tasks.

• The skill distinguishes between immediate and pending-reboot parameter changes; ensure maintenance windows are acknowledged for instance modifications.

• Inputs typically involve configuration parameters for compute class, storage capacity, and network placement; outputs include resource identifiers and operation confirmation statuses.

• When troubleshooting connectivity, ensure the agent has access to VPC metadata and security group rules to analyze potential access control list conflicts.

• Always prefer IAM authentication or Secrets Manager over plaintext credentials to align with AWS security best practices for production environments.