All skills
aws avatar

/amazon-aurora-postgresql

@a9d1c70

Amazon Aurora PostgreSQL — creates, modifies, and advises on Aurora PostgreSQL clusters specifically (PostgreSQL-compatible engine, Aurora serverless, express configuration, pgvector, Babelfish). Trigger for Aurora PostgreSQL cluster operations, express-configuration quick-start, ACU sizing, I/O-Optimized storage, commitment pricing, or PostgreSQL upgrade planning. For Aurora MySQL, use amazon-aurora-mysql instead. Contains safety guardrails, express-first routing, and response templates that override defaults.

Use this Skill: https://skilld.dev/gh/aws/agent-toolkit-for-aws/amazon-aurora-postgresql

This session only. Nothing lands on disk.

referencesio-optimized-pricing.md

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

Aurora Storage Pricing — Standard vs I/O-Optimized

Pricing Constants (us-east-1)

Component Standard I/O-Optimized
Storage ($/GiB-month) $0.10 $0.225
I/O requests $0.20 per million $0 (included)
Compute multiplier 1.0× 1.30× (30% premium)

Pricing varies by region. The analyzer script fetches live pricing from the AWS Pricing API when credentials are available; static constants above are the fallback.

The 25% Breakeven Rule

Let:

  • C = compute cost per month (Standard)
  • S = storage GiB × $0.10
  • I = I/O cost per month

Total Standard cost: T_std = C + S + I Total I/O-Optimized cost: T_io = 1.30·C + 2.25·S + 0 (no I/O)

Break-even (where T_io = T_std):

1.30·C + 2.25·S = C + S + I
0.30·C + 1.25·S = I
I / T_std = 0.30·C + 1.25·S over (C + S + I)

Empirically across typical Aurora workloads, this collapses to the simple rule: if I/O cost is ≥ 25% of total cluster spend, switch to I/O-Optimized.

AWS documents this same 25% threshold in their Aurora storage documentation.

What Storage Type Does NOT Affect

  • Performance — both configurations use the same distributed SSD cluster volume across 3 AZs
  • Durability or availability — identical
  • Instance types, engine versions, parameter groups, networking
  • Aurora serverless ACU ranges — the 30% multiplier applies to ACU-hour pricing the same way

Switching Between Storage Types

This skill executes the storage-type switch only after explicit user confirmation, with a downtime / 30-day-cooldown warning first (see instructions.md Task 5 — it is a "warn then execute" operation per SKILL.md safety guardrails):

  • Switch is a cluster-level modification: --storage-type aurora-iopt1 (for I/O-Optimized) or aurora (for Standard)
  • Switching from Aurora Standard to Aurora I/O-Optimized is limited to once every 30 days. Switching from Aurora I/O-Optimized back to Aurora Standard can be done at any time (no 30-day limit)
  • The switch is online (no downtime, no restart) for non-NVMe instance classes. Clusters with NVMe/Optimized Reads instances (r6gd, r8gd, r6id) require a restart with brief unavailability.
  • Switch takes effect immediately for billing

Commitment Pricing Interaction

  • Reserved Instances apply to Aurora I/O-Optimized clusters in full, including the 30% premium. Aurora automatically accounts for the price difference: an I/O-Optimized instance consumes 30% more normalized RI units per hour than the same instance on Standard, so it burns down RI capacity ~1.3× faster. There is no portion forced to on-demand rates
  • Database Savings Plans cover both Standard and I/O-Optimized compute
  • If the user has RIs covering a provisioned fleet, those RIs still apply on I/O-Optimized. To fully cover the 30%-higher normalized-unit consumption, purchase roughly 30% additional RIs of the same instance family (size flexibility lets you round to whole units). No RI discount is forfeited

Source: SKILL.md on GitHub

No alerts3mo3 checks · Risk SAFE
  • Gen Agent Trust Hub3mo

    This skill provides a modular and secure toolkit for managing Amazon Aurora PostgreSQL. It features robust safety guardrails, including multi-tier confirmation models and explicit refusal of destructive operations. The integrated analysis scripts utilize official AWS data sources and adhere to the principle of least privilege, emphasizing short-lived IAM authentication for database connectivity.

  • Socket3mo

    No alerts

  • Snyk3mo

    Risk: LOW · No issues

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

Last checked against GitHub yesterday.

Activeupdated 4 months ago
version
1

README badge

README badge for aws/agent-toolkit-for-aws/amazon-aurora-postgresql