No, dynamic connections cannot do this for you.
dynamic connections will allow you to create one connection file that can different MySQL database credentials based on domain.
this is only managing the database _connection_ though, it does not do anything to manage the database _contents_