Hi! I'd like to deploy the prisma + apollo server as a serverless function to Firebase. Firebase manages environment variables with

functions.config()

(https://firebase.google.com/docs/functions/config-env) But to connect to a database, prisma uses dotenv:

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

Is it possible to access

functions.config()

in

schema.prisma

file? I definitely donot want to hard code user name and password.

You can just write the config() value into the env for example

@janpio Thanks!❤️ so there're 3 files:

.env

DATABASE_URL="postgresql://...

schema.prisma

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

index.ts

const prisma = new PrismaClient({
  datasources: {
    db: {
      url: functions.config().prisma.db,
    },
  },
})

I'll try it out

Depending on how you develop locally, you will want to have some special code to only do the config() thing on Firebase.