aws-rds-database

Deploy and manage relational databases using RDS with Multi-AZ, read replicas, backups, and encryption. Use for PostgreSQL, MySQL, MariaDB, and Oracle.

By aj-geddes · 435 installs

npx skills add aj-geddes/useful-ai-prompts --skill aws-rds-database

Source repository · Upstream listing

AWS RDS Database Table of Contents [Overview]( overview) [When to Use]( when to use) [Quick Start]( quick start) [Reference Guides]( reference guides) [Best Practices]( best practices) Overview Amazon RDS simplifies relational database deployment and operations. Support multiple database engines with automated backups, replication, encryption, and high availability through Multi AZ deployments. When to Use PostgreSQL and MySQL applications Transactional databases and OLTP Oracle and Microsoft SQL Server workloads Read heavy applications with replicas Development and staging environments Data requiring ACID compliance Applications needing automatic backups Disaster recovery scenarios Quick Start Minimal working example: Reference Guides Detailed implementations in the references/ directory: Guide Contents [RDS Instance Creation with AWS CLI](references/rds instance creation with aws cli.md) RDS Instance Creation with AWS CLI [Terraform RDS Configuration](references/terraform rds configuration.md) Terraform RDS Configuration [Database Connection and Configuration](references/database connection and configuration.md) Database Connection and Configuration Best Practices ✅ DO Use Multi AZ for production Enable automated backups Use encryption at rest and in transit Implement IAM database authentication Create read replicas for scaling Monitor performance metrics Set up CloudWatch alarms Store credentials in Secrets Manager Use parameter groups for configuration ❌ DON'T Store passwords in code Disable encryption Use public accessibility in production Ignore backup retention Skip automated backups Create databases without Multi AZ