Ubuntu – Dockerfile cannot access docker-compose postgresql database url with Prisma

I really dont know why but my Dockerfile image cannot access my postgres db running with docker compose. Im using Linux Ubuntu

// prisma.schema

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

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

// package.json

"scripts": {
"build": "npx nest build",
"format": "prettier --write "src/*/.ts" "test/*/.ts"",
"start": "node dist/main",
"start:dev": "npm run start --watch",
"start:repl": "npm run start --entryFile repl",
"start:debug": "npm run start --watch --debug",
"lint": "eslint "{src,apps,libs,test}/*/.ts" --fix",
"test": "jest",
"test:watch": "jest --watch",
"test:cov": "jest --coverage",
"test:debug": "node --inspect-brk -r tsconfig-paths/register -r ts-node/register node_modules/.bin/jest --runInBand",
"test:e2e": "jest --config ./test/jest-e2e.json",
"prepare": "husky install",
"prisma:dev": "npx prisma migrate dev",
"prisma:reset": "npx prisma migrate reset",
"prisma:deploy": "npx prisma migrate deploy",
"prisma:studio": "npx prisma studio",
"docker:up": "docker compose up",
"docker:down": "docker compose down",
"docker:ls": "docker container ls"
},

// Dockefile

FROM node:18
WORKDIR /usr/src/app

COPY package*.json ./
RUN npm install

COPY . .

RUN npm run prisma:deploy
RUN npm run build

EXPOSE 8080

CMD ["npm", "run", "start:dev"]

// docker-compose.yml

version: '3'

services:
  postgres:
    image: postgres:15.3-alpine3.18
    restart: always
    environment:
      POSTGRES_USER: postgres
      POSTGRES_DB: personal
      POSTGRES_PASSWORD: pass123
    ports:
      - "5432:5432"
    volumes:
      - postgres_data:/var/lib/postgresql/data

  app:
    build: .
    depends_on:
      - postgres

volumes:
  postgres_data:

// What im running

npm run docker:up

// Error im having

> RUN npm run prisma:deploy:
> [email protected] prisma:deploy
> npx prisma migrate deploy
> Environment variables loaded from .env
> Prisma schema loaded from prisma/schema.prisma
> Datasource "db": PostgreSQL database "personal", schema "public" at "localhost:5432"
> Error: P1001: Can't reach database server at localhost:5432
> Please make sure your database server is running at localhost:5432.

// .env

# DATABASE_URL="postgresql://postgres:pass123@postgres:5432/personal?schema=public"
DATABASE_URL="postgresql://postgres:pass123@localhost:5432/personal?schema=public"
PORT=8080
HOST="0.0.0.0"

Obs: if i run docker:up only for postgres with DATABASE_URL="postgresql://postgres:pass123@localhost:5432/personal?schema=public" (on localhost) i can access the postgress normally with DBeaver

I tried to run change DATABASE_URL to:
DATABASE_URL="postgresql://postgres:pass123@postgres:5432/personal?schema=public"
and
DATABASE_URL="postgresql://postgres:pass123@localhost:5432/personal?schema=public"