All skills

Advises on Amazon RDS open-source engines (MySQL, MariaDB, PostgreSQL) for instance creation, upgrade planning, commitment pricing, proxy evaluation, and Blue/Green deployments. Handles any RDS MySQL, MariaDB, or PostgreSQL question, including create a production-ready RDS MySQL instance, provision an RDS PostgreSQL database, run the RDS upgrade advisor for my RDS MySQL instance, what are my upgrade options, upgrade RDS MariaDB from 10.6 to the latest version, should I buy reserved instances or a savings plan for db.r7g.2xlarge RDS MySQL, change a VARCHAR to INT column on RDS MySQL 8.0 with Blue/Green, and does RDS Proxy help when PgBouncer already runs in transaction mode. Covers instance creation with production best practices, describe-db-instances and describe-db-engine-versions upgrade-target workflow, live prechecks via SSM or direct connection, RI versus DSP commitment pricing, RDS Proxy versus PgBouncer, and Blue/Green lifecycle with binlog replay compatibility.

Use this Skill: https://skilld.dev/gh/aws/agent-toolkit-for-aws/rds-oss

This session only. Nothing lands on disk.

referencescommitment-scenarios.md

≈684 tokens on demand. Your agent reads this file only when SKILL.md points to it.

RDS Commitment Pricing Decision Scenarios

Scenario A: Steady 24/7 Production, Fixed Family

Example: RDS MySQL on db.r7g.2xlarge, Multi-AZ, running 24/7 for 2+ years.

Recommendation: 3yr All-Upfront RI (Multi-AZ offering). Highest savings (~55-60%).

Watch out: If migrating to r8g before term ends, RI doesn't transfer. Use 1yr RI or DSP instead.

Scenario B: Steady Production, Want Flexibility

Example: Stable workload, but team may switch instance generations within 12-18 months.

Recommendation: 1yr DSP. Covers any eligible RDS instance family. ~20-35% discount, family-agnostic.

Scenario C: Variable Workload

Example: Batch jobs running 8 hours/day, 5 days/week. ~24% utilization.

Recommendation: Stay on-demand. RI break-even is ~40-50% utilization. Below that, commitments cost more.

Scenario D: Mixed Fleet Across Engines

Example: 5 RDS MySQL instances + 3 RDS PostgreSQL instances, mix of r6g and r7g.

Recommendation: Hybrid approach.

  • RI for r6g instances (DSP doesn't cover r6g) — engine-specific RIs
  • DSP covers r7g instances across both MySQL and PostgreSQL
  • Migrate r6g → r7g over time, shift more to DSP

Scenario E: Multi-AZ with Read Replicas

Example: RDS PostgreSQL Multi-AZ primary + 2 Single-AZ read replicas.

Recommendation:

  • Multi-AZ RI for the primary (must be Multi-AZ offering)
  • Single-AZ RI for each read replica (separate offerings)
  • Or DSP to cover all three with one commitment

Scenario F: Planned Migration to Aurora

Example: RDS MySQL being migrated to Aurora MySQL within 6-12 months.

Recommendation: No RDS commitment. RI and DSP are use-it-or-lose-it. If you buy an RDS MySQL RI and migrate to Aurora, the RI is wasted. Wait until post-migration, then evaluate Aurora commitment options.

Quick Decision Tree

Is utilization < 40%?
├── YES → Stay on-demand
└── NO
    ├── Is the instance family r6g / older?
    │   ├── YES → RI only (DSP doesn't cover). Engine-specific.
    │   └── NO → Compare RI vs DSP
    ├── Planning to migrate to Aurora?
    │   ├── YES → No commitment (RI doesn't transfer cross-engine)
    │   └── NO → Continue
    ├── Want flexibility across families?
    │   ├── YES → DSP (1yr or 3yr)
    │   └── NO → 3yr RI for max savings
    └── Multi-AZ?
        ├── YES → Must buy Multi-AZ RI offering (not Single-AZ)
        └── NO → Single-AZ RI

Sizing the Commitment

Never commit to more than your steady baseline. Do not RI a read replica that's torn down during off-hours. For DSP, commit to the 24/7 baseline $/hr and leave peaks on-demand.

Source: SKILL.md on GitHub

No alerts3mo3 checks · Risk SAFE
  • Gen Agent Trust Hub3mo

    This skill is a specialized advisor for Amazon RDS open-source engines, providing workflows for resource provisioning, upgrades, and cost optimization. It adheres to security best practices by enforcing encryption, multi-factor availability, and secure credential management via AWS Secrets Manager. No malicious patterns were identified.

  • Socket3mo

    No alerts

  • Snyk3mo

    Risk: LOW · No issues

Signed by skilld at aea59f3. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 3 months ago
version
1

README badge

README badge for aws/agent-toolkit-for-aws/rds-oss