RDS for MySQL and PostgreSQL support read/write splitting. A maximum of five read replicas can be created for an RDS DB instance. Currently, a proxy cannot be used to split read/write requests. You need to configure your applications to split read requests to read replicas and write requests to the primary DB instance.
RDS for Microsoft SQL Server does not support read/write splitting.