I am facing this issue.

schema.prisma

generator client {
  provider = "prisma-client-js"
}

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

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  password  String
  role      String   // Admin or Regular User
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

package.json

"@prisma/client": "^6.3.1",
    "apollo-server-express": "^3.13.0",
    "dotenv": "^16.4.7",
    "express": "^4.21.2",
    "graphql": "^16.10.0",
    "pg": "^8.13.1",
    "postgres": "^3.4.5",
    "prisma": "^6.3.1"

PS E:\backend> npx prisma migrate dev --name init
Environment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma
Datasource "db": PostgreSQL database "postgres", schema "public" at "aws-0-ap-south-1.pooler.supabase:6543"

Error: P1001: Can't reach database server at `aws-0-ap-south-1.pooler.supabase:6543`

Please make sure your database server is running at `aws-0-ap-south-1.pooler.supabase:6543`.

node - 18.20 and 16.20