© 2026 Hedgehog Software, LLC
prisma.config.ts
Failed to load config file "D:\Projects\cafeBot\api" as a TypeScript/JavaScript module. Error: PrismaConfigEnvError: Missing required environment variable: DATABASE_URL
npx prisma generate
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;