A single database instance can host multiple independent schemas. No need to pay for more.
Treating a database as an API is more than doable, but the whole team needs to be on point with the necessary shift in expectations, as well as the shift in tooling and best practices.