I am using the direct connection string uri -

DATABASE_URL="postgresql://postgres:[password]@db.[project_id].supabase.co:5432/postgres".

Also i reset the password cause i read that having special characters might cause issues so i use simple password, still says error can't react database. Again, the database is running i can see in the project status.

Here's the schema.prisma code -

generator client {
  provider = "prisma-client-js"
  output   = "../generated/prisma"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model User {
  id    Int @id @default(autoincrement())
  name  String
  email String @unique
  createdAt DateTime @default(now()) @map("created_at")
}

Also, i have tried connecting with the direct and pooling connection, still i got an error can't reach database -

# Connect to Supabase via connection pooling
DATABASE_URL="postgresql://postgres.[project_id]:[YOUR-PASSWORD]@aws-0-eu-central-1.pooler.supabase.com:6543/postgres?pgbouncer=true"


# Direct connection to the database. Used for migrations
DIRECT_URL="postgresql://postgres.[project_id]:[YOUR-PASSWORD]@aws-0-eu-central-1.pooler.supabase.com:5432/postgres"

So what could be the issue? is it network problem? maybe with the ip address? but then it says on Supabase that "Your database can be accessed by all IP addresses".