agentsclimarketplace

Aws rds setup

Skill pluginagentmarketplace/custom-plugin-aws/skills/aws-rds-setup

Deploy and configure RDS/Aurora databases with HA and securityFrom its SKILL.md

Install
npx -y skills add pluginagentmarketplace/custom-plugin-aws --skill aws-rds-setup

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
  • 2 stars2 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

5.0 KB, as published. Nobody here has run it

AWS RDS Setup Skill

Deploy production-ready managed databases with high availability.

Quick Reference

AttributeValue
AWS ServiceRDS, Aurora
ComplexityMedium
Est. Time15-45 min
PrerequisitesVPC, Subnet Group, Security Group

Parameters

Required

ParameterTypeDescriptionValidation
enginestringDatabase enginemysql, postgres, aurora-mysql, etc.
instance_classstringInstance typedb.* family
db_namestringDatabase nameAlphanumeric
master_usernamestringAdmin username^[a-zA-Z][a-zA-Z0-9]{0,15}$
master_passwordstringAdmin passwordMin 8 chars, complexity

Optional

ParameterTypeDefaultDescription
multi_azboolfalseMulti-AZ deployment
storage_typestringgp3gp2, gp3, io1, io2
allocated_storageint20Storage in GB
backup_retentionint7Backup retention days
encryptionbooltrueStorage encryption

Execution Flow

1. Create DB subnet group
2. Configure parameter group
3. Create RDS instance
4. Wait for available status
5. Create read replicas (if specified)
6. Configure backups
7. Set up monitoring

Implementation

Create RDS Instance

# Create DB subnet group
aws rds create-db-subnet-group \
  --db-subnet-group-name prod-db-subnets \
  --db-subnet-group-description "Production DB subnets" \
  --subnet-ids subnet-111 subnet-222 subnet-333

# Create RDS instance
aws rds create-db-instance \
  --db-instance-identifier prod-mysql \
  --db-instance-class db.r6g.large \
  --engine mysql \
  --engine-version 8.0 \
  --master-username admin \
  --master-user-password "$DB_PASSWORD" \
  --allocated-storage 100 \
  --storage-type gp3 \
  --storage-encrypted \
  --kms-key-id alias/rds-key \
  --multi-az \
  --db-subnet-group-name prod-db-subnets \
  --vpc-security-group-ids sg-12345 \
  --backup-retention-period 7 \
  --preferred-backup-window "03:00-04:00" \
  --preferred-maintenance-window "sun:04:00-sun:05:00" \
  --enable-performance-insights \
  --performance-insights-retention-period 7 \
  --enable-cloudwatch-logs-exports '["error","slowquery"]' \
  --deletion-protection \
  --tags Key=Environment,Value=Production

Create Read Replica

aws rds create-db-instance-read-replica \
  --db-instance-identifier prod-mysql-replica \
  --source-db-instance-identifier prod-mysql \
  --db-instance-class db.r6g.large \
  --availability-zone us-east-1b

Parameter Groups

MySQL Optimization

{
  "max_connections": "LEAST({DBInstanceClassMemory/9531392},5000)",
  "innodb_buffer_pool_size": "{DBInstanceClassMemory*3/4}",
  "slow_query_log": "1",
  "long_query_time": "2"
}

PostgreSQL Optimization

{
  "shared_buffers": "{DBInstanceClassMemory/32768}",
  "effective_cache_size": "{DBInstanceClassMemory*3/4}",
  "log_min_duration_statement": "1000"
}

Troubleshooting

Common Issues

SymptomCauseSolution
Connection refusedSG or networkCheck SG rules, VPC routing
Too many connectionsLimit reachedIncrease max_connections, use pooling
Slow queriesMissing indexesEnable Performance Insights
Storage fullGrowth exceededEnable autoscaling

Debug Checklist

  • Security group allows port 3306/5432?
  • DB in correct VPC/subnet?
  • Instance status "available"?
  • Using correct endpoint (writer vs reader)?
  • SSL/TLS configured correctly?
  • Parameter group applied?

Connection String Format

# MySQL
mysql -h endpoint.rds.amazonaws.com -u admin -p dbname

# PostgreSQL
psql "host=endpoint.rds.amazonaws.com dbname=mydb user=admin sslmode=require"

# With IAM Auth
aws rds generate-db-auth-token --hostname endpoint --port 3306 --username iam_user

High Availability

ConfigurationRTORPOCost
Single-AZHoursUp to 5 min$
Multi-AZ1-2 min0$$
Aurora Multi-AZSeconds0$$$
Aurora GlobalSecondsSeconds$$$$

Test Template

def test_rds_connection():
    # Arrange
    endpoint = "prod-mysql.xxx.us-east-1.rds.amazonaws.com"

    # Act
    connection = pymysql.connect(
        host=endpoint,
        user='admin',
        password=get_secret('db-password'),
        database='mydb',
        ssl={'ssl': True}
    )

    # Assert
    cursor = connection.cursor()
    cursor.execute("SELECT 1")
    result = cursor.fetchone()
    assert result[0] == 1

    # Cleanup
    connection.close()

Assets

  • assets/rds-config.yaml - RDS configuration templates

References

Keep looking

Skills are one crate of 609,689. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.