skills.rest
AndreKurait
AndreKuraitCOMMUNITY
Explore all skills by this author →
GitHub

amazon-aurora-postgresql

Evaluate Aurora PostgreSQL deployment paths and recommend express or full configurations.

Updated Jun 18, 2026
Search Tags:#serverless#express#dsp#ri#storage-optimization#aurora-postgresql#acU-sizing
One-click install
npx skills add https://github.com/AndreKurait/claude-marketplace-test --skill amazon-aurora-postgresql-andrekurait
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: amazon-aurora-postgresql
Source: https://github.com/AndreKurait/claude-marketplace-test/tree/main/skills/specialized-skills/database-skills/amazon-aurora-postgresql
Command: npx skills add https://github.com/AndreKurait/claude-marketplace-test --skill amazon-aurora-postgresql-andrekurait

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires boto3, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Automates evaluation and governance of Aurora PostgreSQL deployments, guiding users through express vs full configuration choices, ACU sizing, I/O-Optimized storage decisions, and commitment-pricing planning for both serverless and provisioned clusters.

Core Features & Use Cases

  • Deployment-path decisioning: Route between Aurora Express (serverless, IAM-auth) and Full Configuration based on user constraints (VPC requirements, KMS, custom parameter groups, or MySQL engine requests).
  • ACU sizing & capacity planning: Help size ACU for serverless and provisioned clusters, including memory floors and peak requirements.
  • I/O-Optimized vs Standard storage decisions: Apply the 25% breakeven guideline, cost comparisons, and switch rules with 30-day cooldown awareness.
  • Pricing & commitments: Analyze RI vs DSP scenarios for Aurora compute (provisioned) and Aurora serverless, including DSP eligibility by family and hybrid strategies.
  • Upgrade & migration guidance: Outline migration paths between express and full configurations, including data-movement options and prechecks.

Quick Start

Describe your Aurora environment and I will guide you through express vs full configuration decisions, ACU sizing, I/O optimization, and pricing options.

Frequently Asked Questions about amazon-aurora-postgresql

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

FAQPage Schema
How do I choose between Aurora Express and full configuration for PostgreSQL?▼

Choosing between Aurora Express and full configuration depends on VPC requirements, KMS needs, and custom parameter groups. Express suits serverless with IAM-auth, while full configuration handles custom constraints and specific engine requests.

What is the breakeven point for Aurora I/O-Optimized vs Standard storage?▼

The breakeven point for Aurora I/O-Optimized vs Standard storage is 25%. This guideline helps determine cost comparisons, switch rules, and the 30-day cooldown awareness required for storage optimization decisions.

How do I size ACU for Aurora PostgreSQL serverless clusters?▼

To size ACU for Aurora PostgreSQL serverless clusters, evaluate memory floors and peak workload requirements. Proper ACU sizing ensures provisioned and serverless clusters meet capacity planning needs effectively.

Reserved Instances vs Database Savings Plans: which Aurora pricing option is better?▼

Reserved Instances vs Database Savings Plans pricing depends on Aurora compute deployment type. Analyze RI vs DSP scenarios for provisioned and serverless clusters, including DSP eligibility by family and hybrid commitment strategies.

Can I migrate an existing Aurora PostgreSQL deployment from express to full configuration?▼

You can migrate Aurora PostgreSQL between express and full configurations. Migration guidance includes outlining data-movement options, performing prechecks, and evaluating deployment-path decisions based on workload constraints.

Related Skills

Explore More Data & Analytics Skills→
AndreKuraitAndreKurait

creating-amazon-aurora-db-cluster-with-instances

Create an Amazon Aurora cluster with an attached instance and Secrets Manager password management.

Community
Advanced
HankanmanHankanman
1

preference-cooldown-bypass-bug

Separate cooldown tracking from preference enable/disable state to prevent rate-limiting bypass.

Community
Intermediate
berTrindadeberTrindade

security

Enforce secure Terraform secrets handling and least-privilege network access.

Community
Advanced
necatiarslannecatiarslan
1

awsclaw-rdsdata

Execute SQL statements and manage transactions via the RDS Data API.

Community
Intermediate