There is no SQL editor, just a data viewer tab. It's recommended that you use an actual database management application, like dbeaver, data grip, or even pgadmin4

I have tried connecting but it doesn't connect

You will need to use the DATABASE_PUBLIC_URL to connect from an external source. The DATABASE_URL now defaults to the private URL for internal networking

_

and this will encour a charge if I'm not mistaken also what you mrsn by the the database url now defaults to the private networking thanks for your help

By defaulting to the private URL there is no egress when used by your deployed application. You will pay egress for connecting with a database management application though over the public url

so do I have to use the public url to connect databases or can I use my private url which is what I have been trying to do

If you are connecting from your deployed application you can use the private URL. If you are using a database management application on your computer, you will need to use the public url

how do I connect using the deployed application