Creating Amazon Aurora DB Cluster With Instances

From the author

Creates a complete Amazon Aurora database cluster with instances, handling cluster creation, instance provisioning, and Secrets Manager password management in the proper sequence. Use when setting up new Aurora MySQL or PostgreSQL clusters with production-ready configuration.

— the description by AWS

AutoGineer summary

Written by AutoGineer from the skill’s own files, not by the author

This skill provides a standardized workflow for deploying Amazon Aurora database clusters on AWS. It handles the sequential creation of the cluster and its associated database instances, ensuring that security best practices are followed by utilizing AWS Secrets Manager for password management. The workflow includes validation steps for AWS credentials, monitoring of resource creation status, and support for both MySQL and PostgreSQL engines.

What it does

Validates AWS environment credentials and required permissions.
Provisions an Amazon Aurora database cluster with encrypted storage.
Configures managed password authentication via AWS Secrets Manager.
Adds database instances to the cluster to enable queryable access.
Monitors resource creation status with built-in retry logic.
Supports configuration of backup windows, maintenance schedules, and VPC settings.

When to use it

When deploying new production-ready Aurora MySQL or PostgreSQL database clusters.
When you need to ensure consistent, repeatable database infrastructure provisioning.
When you want to enforce secure password management using AWS Secrets Manager.
When setting up database environments that require specific backup and maintenance configurations.

Advantages

Reduces manual configuration errors through a defined, sequential process.
Ensures security by mandating managed password storage over plaintext inputs.
Provides built-in status monitoring to handle the asynchronous nature of AWS resource creation.
Standardizes infrastructure parameters across different database deployments.

Usage examples

“Create an Aurora MySQL cluster named my-app-db with a t3.medium instance.”: The agent will verify AWS credentials, initiate the cluster creation with managed secrets, wait for the cluster to become available, and then provision the requested instance.
“Set up a new Aurora PostgreSQL cluster with encryption enabled.”: The agent will execute the provisioning workflow, ensuring the cluster is created with storage encryption and the necessary Secrets Manager integration for the master user.

Install

Download the skill as a ZIP:
https://mp-staging.autogineer.com/agent-skills/aws/creating-amazon-aurora-db-cluster-with-instances/download

Unzip it into the cross-client skills folder of your project:

mkdir -p .agents/skills && unzip creating-amazon-aurora-db-cluster-with-instances.zip -d .agents/skills

Documentation by AWS

Overview

Domain expertise for creating complete Amazon Aurora database setups including cluster creation, instance provisioning, and managed password configuration via AWS Secrets Manager. Supports both Aurora MySQL and Aurora PostgreSQL engines.

Create an Aurora cluster with instances

To create a fully configured Aurora database cluster with attached instances, follow the procedure exactly. See Aurora cluster creation procedure.

The procedure creates an empty Aurora cluster first, then adds a database instance to make it queryable. It uses AWS Secrets Manager for password management and includes proper status monitoring with retry logic.

Troubleshooting

Cluster creation fails

Verify the engine version is supported in your region and that you have sufficient permissions for RDS and Secrets Manager operations.

Instance creation fails

Check that the instance class is compatible with the Aurora engine and available in your region's availability zones.

Long creation times

Aurora cluster and instance creation can take 10-20 minutes. Extended wait times are normal for Aurora resources.

Files

ATTRIBUTION.mdAdded by AutoGineer984 B
LICENSELicence file added by AutoGineer9.9 KiB
NOTICELicence file added by AutoGineer67 B
SKILL.md1.6 KiB
references/create-amazon-aurora-db-cluster-with-instances.md8.0 KiB

SKILL.md