One of my mentees worked with Xata in their app using Prisma and it wasn't great. The need for a second db for the 'shadow' db that prisma needs, and they would throw Out of Memory errors frequently without any significant usage.
The app now moved to Prisma's postgres hosting and it works like a charm, only thing that changed is the db.