how do I get the database url and not just the https url

Where have you deployed the database? Are you using the Prisma Cloud demo server?

yeah demo server

The demo server wasn’t meant for production, so you won’t be able to get the Database URL. If you require the Database dump, let me know your email address and workspace slug via DM so we can send it to you,

its a play environment