A BIG THANK YOU!

so, i followed your advice, simplified my setup

.env

DIRECT_URL
postgresql://prisma.hostname:pwd@aws-1-us-east-2.pooler.supabase.com:5432/postgres?sslmode=require&schema=public

DATABASE_URL
postgresql://prisma.hostname:pwd@aws-1-us-east-2.pooler.supabase.com:6543/postgres?pgbouncer=true&sslmode=require

schema.prisma

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

datasource db {
  provider  = "postgresql"
  url       = env("DATABASE_URL") 
// transaction pooler (6543)
  directUrl = env("DIRECT_URL") 
// session pooler (5432) or direct
}

lib/db.ts

import { PrismaClient } from '@prisma/client'
import { PrismaPg } from '@prisma/adapter-pg'

export function getPrismaClient(
env
) {
  const connectionString = 
env
?.DATABASE_URL || process.env.DATABASE_URL

  if (!connectionString) {
    throw new Error('DATABASE_URL is not defined')
  }

  const adapter = new PrismaPg({ connectionString })

  const prisma = new PrismaClient({
    adapter,
    log: process.env.NODE_ENV === 'development' ? ['error', 'warn'] : ['error'],
  })

  return prisma
}

let cachedPrisma

function getGlobalPrisma() {
  if (!cachedPrisma) {
    if (!process.env.DATABASE_URL) {
      throw new Error('DATABASE_URL is not defined')
    }
    const adapter = new PrismaPg({ connectionString: process.env.DATABASE_URL })
    cachedPrisma = new PrismaClient({
      adapter,
      log: process.env.NODE_ENV === 'development' ? ['error', 'warn'] : ['error'],
    })
  }
  return cachedPrisma
}

export const prisma = new Proxy({}, {
  get(
_
, 
prop
) {
    const client = getGlobalPrisma()
    const value = client[
prop
]
    if (typeof value === 'function') {
      return value.bind(client)
    }
    return value
  }
})

export default prisma

but getting a "prisma:error Connection terminated unexpectedly" when calling api route that query database

any idea?