Prisma 7 - Error opening TLS connection (cockroachdb)

Error opening a TLS connection: unable to verify the first certificate

cockroachdb:
    image: cockroachdb/cockroach:v25.3.3
    command: >
      start-single-node
      --certs-dir=/cockroach/certs
    ports:
      - "26257:26257"
    volumes:
      - roach-single:/cockroach/cockroach-data
      - roach-certs:/cockroach/certs
    environment:
      # if prior volumes already exist, these will have no effect
      - COCKROACH_DATABASE=ufc
      - COCKROACH_USER=john
      - COCKROACH_PASSWORD=pork
volumns:
  roach-single:
  roach-certs:

DATABASE_URL=postgresql://aseer:password@localhost:26257/althire?sslmode=verify-full

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

const globalForPrisma = globalThis as unknown as { prisma: PrismaClient }

export const prisma =
  globalForPrisma.prisma ||
  new PrismaClient({
    log: ['query', 'info', 'error', 'warn'],
    adapter: new PrismaPg({ connectionString: env.DATABASE_URL }),
  })

if (process.env.NODE_ENV !== 'production') globalForPrisma.prisma = prisma