Next.js Discord

Discord Forum

Missing_Connection_string VercelPostgresError

Unanswered
Nile Crocodile posted this in #help-forum
Open in Discord
Nile CrocodileOP
Hi I'm trying to use VercelPostgres locally aswell as your supposed to be able to but something is going wrong. It appears next/vercel is not picking up my .env variables. In detail the POSTGRES_URL variable.

I have a envConfig.ts

"use server"

import { loadEnvConfig } from '@next/env';

const projectDir = process.cwd();
loadEnvConfig(projectDir);

I have in my drizzle.config.ts


import '../../envConfig';
import { defineConfig } from "drizzle-kit"

export default defineConfig ({
out: "./drizzle",
schema: "./src/server/db/schema.ts",
dialect: "postgresql",
dbCredentials: {
url: process.env.POSTGRESURL!,
},
tablesFilter: ["goldencars
*"],
})


And my src/server/db/index.ts

import { sql } from '@vercel/postgres';
import { drizzle } from 'drizzle-orm/vercel-postgres';
import * as schema from './schema'
import '../../envConfig';

// Debug environment variables
console.log('Database Environment:', {
url: process.env.POSTGRES_URL,
nodeEnv: process.env.NODE_ENV,
});

export const db = drizzle(sql, { schema });

I need help pls!

0 Replies