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-basics.md

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

RDS Commitment Pricing — Mechanics

Reserved Instances (RI)

RIs are a per-instance commitment for RDS. You commit to a specific instance class, engine, and deployment type (Single-AZ or Multi-AZ) in a region for 1 or 3 years.

Payment Options

Option Upfront Recurring Typical Discount (3yr)
No Upfront $0 Monthly fee ~40-50%
Partial Upfront ~50% of term Lower monthly ~50-55%
All Upfront Full term cost $0 ~55-60%

Size Flexibility

RDS RIs have size flexibility within the same instance family and engine. A db.r7g.2xlarge RI can cover 2× db.r7g.xlarge. Size flexibility does NOT apply across families or engines.

Multi-AZ

Multi-AZ RIs are separate offerings. A Single-AZ RI does NOT cover a Multi-AZ instance. You must purchase the correct deployment type.

What RI Doesn't Cover

  • Storage or I/O (no RI for GP3/IO1 storage)
  • Cross-engine: a MySQL RI doesn't cover PostgreSQL or MariaDB
  • Cross-family: an r7g RI doesn't cover r6g or m7g

Database Savings Plans (DSP)

DSP is a $/hour account-wide commitment. You commit to spending $X/hr on RDS compute; in return you get a discounted rate.

Key Properties

  • 1-year or 3-year terms available for RDS (unlike Aurora which is 1yr only)
  • Covers RDS MySQL, MariaDB, and PostgreSQL compute
  • Family-agnostic within eligible families
  • Account-wide: applies to consolidated billing family
  • Payment options: No Upfront, Partial Upfront, All Upfront

Coverage Limits

DSP covers latest-gen families: r7g, r7i, r8g, r8gd, m7g, m7i, c7g, c7i, x8g. Older families (r6g, r5) are NOT covered.

Typical Discount

1yr DSP: ~20-35%. 3yr DSP: ~35-50%. Less than equivalent RI terms but more flexible.

Mutual Exclusion

Only one discount per instance-hour. Priority: RI first, then DSP, then on-demand.

You can mix RI + DSP: RI for steady baseline on one family, DSP for cross-family or variable usage.

Break-Even

RIs save money when utilization exceeds ~40-60% of the term. Below that, on-demand is cheaper.

RDS vs Aurora Differences

  • RDS DSP supports both 1yr and 3yr terms (Aurora DSP is 1yr only)
  • RDS has no Serverless option — all instances are provisioned
  • RDS has no I/O-Optimized storage tier — no 30% compute premium to worry about
  • RDS Multi-AZ RIs are separate from Single-AZ (Aurora handles this at the cluster level)
  • RDS RI is engine-specific: MySQL RI ≠ PostgreSQL RI ≠ MariaDB RI

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