We have a whole section in our documentation's guides section on example usecases with database:
https://docs.kraft.cloud/guides/#databases
They work exactly as you suggest, they scale-to-zero when no requests are made and data can be safely stored/transactioned in persistent volumes on the platform too.