RDS is a managed relational database service that supports several database engines including MySQL, PostgreSQL, Oracle, SQL Server, and Amazon Aurora. It automates database management tasks such as backups, patching, scaling, and replication, allowing users to focus on their application rather than the underlying infrastructure. RDS integrates with other AWS services such as CloudWatch for monitoring and IAM for access control.