rds

Provision and manage AWS RDS databases with automated backups and failover.

1.1k|444|Updated May 18, 2019
One-click install
npx skills add https://github.com/itsmostafa/aws-agent-skills --skill rds
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: rds
Source: https://github.com/itsmostafa/aws-agent-skills/tree/main/skills/rds
Command: npx skills add https://github.com/itsmostafa/aws-agent-skills --skill rds

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

AWS RDS manages core database services and handles provisioning, patching, backups, monitoring, and failover, reducing operational overhead for database administrators.

Core Features & Use Cases

  • Managed database lifecycles: provisioning, patching, backups, and failover across MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Aurora.
  • High availability and disaster recovery: Multi-AZ deployments, read replicas, automated backups, and point-in-time recovery.
  • Performance tuning and security: parameter groups, IAM authentication, encryption, and monitoring integration with CloudWatch.

Quick Start

Use this skill to start an RDS instance with a single command to create a multi-AZ Postgres database and enable automated backups.

Frequently Asked Questions about rds

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate AWS RDS provisioning across different database engines?

AWS RDS provisioning is automated using AWS CLI and boto3 to deploy PostgreSQL, MySQL, MariaDB, Oracle, SQL Server, or Aurora instances hands-off. This skill manages the database lifecycle from development to production environments, reducing manual operational overhead.

What's the best way to configure Multi-AZ deployments and Read Replicas for high availability?

Multi-AZ deployments and Read Replicas are configured through automated scripts to achieve high availability and disaster recovery. This approach enables synchronous standby replicas for failover and asynchronous read replicas to scale read capacity across AWS RDS instances.

Does this approach support automated backups and point-in-time recovery for AWS RDS?

Automated backups and point-in-time recovery are fully supported for AWS RDS instances. This skill configures retention policies and transaction log archiving, allowing database administrators to restore managed databases to any specific second within the backup window.

Can I manage parameter groups and IAM authentication for AWS RDS databases?

Parameter groups and IAM authentication are managed directly through AWS CLI commands. This skill modifies database configuration parameters and enforces IAM database authentication to secure access, replacing traditional password methods with AWS identity tokens.

How do I integrate CloudWatch monitoring with AWS RDS instances?

CloudWatch monitoring is integrated with AWS RDS by enabling Enhanced Monitoring metrics through boto3 configuration. This skill sets up performance schema collection and metric alarms, providing database administrators with visibility into CPU, memory, and I/O utilization.

When should I use AWS RDS instead of managing my own database servers?

AWS RDS should be used when you need AWS to handle provisioning, patching, backups, monitoring, and failover. This managed approach reduces operational overhead for database administrators compared to self-managed database servers across production environments.