skilld
All skills
aws avatar

/amazon-aurora-postgresql

@a9d1c70
by Amazon Web Servicesaws/agent-toolkit-for-aws2.8k stars
337

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.

Ask your Agent

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

This session only. Nothing lands on disk.

referencesupgrade-planning-instructions.md

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

Aurora Upgrade Advisor Workflow

Guide customers through Aurora PostgreSQL major and minor version upgrades. Identifies the cluster, recommends target versions (latest vs LTS), runs live prechecks, flags query-plan regressions, and surfaces pre- and post-upgrade checklists. Major version upgrades are blocked — see SKILL.md Safety guidance. This reference helps plan the upgrade.

Execute commands using available tools from the AWS MCP server when connected (sandboxed execution, audit logging, observability). Fall back to the AWS CLI or shell when the MCP server is not available.

When This Applies

User mentions: upgrade Aurora cluster, what version should I upgrade to, pre-upgrade checklist, post-upgrade steps, Aurora LTS, upgrade prechecks, Aurora PostgreSQL upgrade, or major/minor version upgrade.

Two response modes

Mode A — Advisory (no cluster named): User asks a general question like "what version should I upgrade to?" or "what's the LTS version?" without specifying a cluster. Skip directly to LTS recommendation (see "Mode A workflow" below). Do NOT ask for cluster ID and region first — recommend the LTS version with rationale, then offer to run the live workflow if they want a cluster-specific assessment.

Mode B — Cluster-specific (cluster named): User names a cluster identifier or asks you to plan an upgrade for a specific cluster. Run the full workflow (Tasks 1–8) with live AWS calls. Tasks are split across:

  • mode-b-discovery.md — Tasks 1–4: permissions, no-fabrication guard, acquire parameters, identify the cluster, determine upgrade targets.
  • lts-recommendation.md — Task 5: recommend two options (LTS vs latest), with the authoritative current-LTS table and trade-offs.
  • mode-b-prechecks-checklists.md — Tasks 6–8: live database prechecks, query-load analysis, pre/post-upgrade checklists and engine-specific blockers.

When the user reports a completed upgrade and asks what to check now, route to post-upgrade-validation.md (must-surface Aurora items + immediate cluster-state checks) and post-upgrade-detail.md (statistics refresh, extension updates, plan verification, parameter-group-family migration, snapshot rollback window, monitoring window).

Mode A workflow (advisory, ~3-4 paragraphs)

When the user asks "what version should I upgrade to?" with their current version (e.g., "I'm on 14.9") but no cluster ID:

  1. Lead with LTS recommendation. State the designated Aurora PostgreSQL LTS minors (16.8 / 17.7) and frame the relevant one as the recommended target. Be direct — don't ask for more info first.
  2. Explain LTS rationale: longer support window (~3 years of critical fixes), fewer forced upgrade cycles, suitable when stability matters more than new features.
  3. Mention the latest non-LTS option as the alternative for users wanting newer features, but make clear LTS is the default recommendation.
  4. State the upgrade path: for major version jumps from old versions (e.g., PostgreSQL 14.9 → 16.x), the upgrade may require an intermediate hop or Blue/Green deployment. Direct major-version upgrades require prechecks, a maintenance window, and a rollback plan.
  5. Offer the cluster-specific workflow as a follow-up: "If you share your cluster ID and region, I can pull the exact valid upgrade targets, run prechecks, and produce a pre/post-upgrade checklist."

Mode A does NOT need cluster identifier, region, or live AWS calls. It is general guidance, version-independent. For the authoritative current-LTS table and the LTS/latest trade-offs, see lts-recommendation.md.

Troubleshooting

Cluster not found. Check region and cluster identifier. For Global Databases, use describe-global-clusters with the global cluster identifier.

Engine version shows -limitless. Aurora Limitless. Upgrade paths are separate — only offer -limitless target versions and note the model differs.

Precheck queries time out via SSM. Increase the SSM timeout, or switch to RDS Data API if enabled. Large schemas can take minutes for information_schema queries.

RDS Proxy compatibility unclear. Check target version release notes. If unclear, test on a snapshot-restored clone with the proxy attached before production.

User wants to roll back after a successful upgrade. Rollback requires snapshot restore — no in-place downgrade. If the cluster is functioning but has a regression, debug it rather than roll back. See the post-upgrade checklist for regression-hunting steps.

Deep-Dive References

Source: SKILL.md on GitHub

Third-party checks

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

Provenance

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

Capability

version
1

README badge

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