PrismaP
Prisma•3mo ago•
3 replies
beanbeanjuice

"Missing required environment variable: DATABASE_URL" after Migrating to prisma.config.ts

I'm trying to migrate to the new 
prisma.config.ts
 as outlines here. I'm running into this error.

Failed to load config file "D:\Projects\cafeBot\api" as a TypeScript/JavaScript module. Error: PrismaConfigEnvError: Missing required environment variable: DATABASE_URL


This error occurs when I run 
npx prisma generate
.

It was perviously working before moving to 
prisma.config.ts
.


prisma.config.ts

import { defineConfig, env } from "prisma/config";
import * as path from "node:path";
export default defineConfig({
    // The Rust-compiled schema engine
    engine: "classic",
    schema: path.join("prisma", "schema.prisma"),
    migrations: {
        path: path.join("prisma", "migrations"),
        seed: "ts-node -r tsconfig-paths/register prisma/seed.ts",
    },
    datasource: {
        url: env("DATABASE_URL"),
    },
});


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

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

const env = process.env.NODE_ENV;

const adapter = new PrismaPg({ connectionString: process.env.DATABASE_URL });
export const prisma = globalForPrisma.prisma || new PrismaClient({
    adapter: adapter,
    log:
        env === "development"
            ? ["warn", "error", "query", "info"]
            : env === "test"
                ? [] // no logs in test
                : ["warn", "error"], // production / other
});

if (env !== "production") globalForPrisma.prisma = prisma;
Prisma
Prisma ORM 6.18.0, Postgres Database Metrics and Config Modernization
Catch up on the lates 6.18.0 release for Prisma ORM and Prisma Postgres.
Prisma ORM 6.18.0, Postgres Database Metrics and Config Modernization
Was this page helpful?