How can I determine size of database prior to importing from SQL dump?
I don't know of any tool that can do what you ask.
The space required can vary due to many factors:

Storage engines
Number of indexes per table
Data types
Character sets
Table options (for example row format and compression)
Numerous MySQL Server configuration options
Table encryption

If you are trying to optimize the storage, try launching a cloud instance with a modest instance type but over-provisioned with plenty of storage space. Then restore your database dump file, and measure the actual size of the restored database. Use that information to provision another cloud instance with exactly the storage you think is appropriate. Then drop the first one, since you only used it to get the size estimate.
Another consideration: Do you really want to provision only enough space for the current database? You don't think it will keep growing (most databases keep growing, in my experience). Does your storage volume have enough space for binary logs? For temporary tables needed during ALTER TABLE? For temporary tables needed during queries?
It's usually a good idea to make sure you have at least double the storage space of your current database size.