Using docker with RDS (Prod) but confusing local DB settings (dev)

I am developing a Rails web application with Docker and for various reasons would like to use RDS in production for my configuration and longevity, not container based Docker (this is a requirement).

I understand that I can set up database.yml to point to my RDS instance for Prod env and some local DB instance in my local dev env.

However, I am confused as to whether to use a container database on my local local environment, or an external one like MySQL Server.

Based on the env-agnostic containers Docker pattern, I suppose that having a container based DB in only some envs doesn't make any sense (in fact, I don't think it docker-compose.yml

will even support something like this), so I assume that I will need to refer to the MySQL Server solution for my local dev env.

Has anyone else gone through such a requirement? Let me know if I think about it right. Also, would this present potential problems for DB migration scenarios?

Any suggestions are greatly appreciated!

Thank.