Theo's Typesafe Cult•12mo ago

Drizzle not pulling in environment variables

So originally my app was fine with the env variables originally but now it is not working. I am not sure what is going on. I have tried to use the dotenv package but that did not work. my drizzle config

import { type Config } from 'drizzle-kit';
import { env } from './env.mjs';

import * as dotenv from "dotenv";
dotenv.config();

export default {
  schema: './src/db/schemas/',
  out: './src/db/migrations',
  driver: 'mysql2',
  dbCredentials: {
    connectionString: env.DATABASE_URL,
  },
} satisfies Config;

import { type Config } from 'drizzle-kit';
import { env } from './env.mjs';

import * as dotenv from "dotenv";
dotenv.config();

export default {
  schema: './src/db/schemas/',
  out: './src/db/migrations',
  driver: 'mysql2',
  dbCredentials: {
    connectionString: env.DATABASE_URL,
  },
} satisfies Config;

the error i am getting

pnpm db:push

> meally@1.0.0 db:push G:\GitHub\Meally\apps\meally
> drizzle-kit push:mysql --config=drizzle.config.ts

drizzle-kit: v0.19.5
drizzle-orm: v0.27.2

Reading config file 'G:\GitHub\Meally\apps\meally\drizzle.config.ts'
❌ Invalid environment variables: {
  DATABASE_URL: [ 'Required' ],
  DATABASE_HOST: [ 'Required' ],
  DATABASE_USERNAME: [ 'Required' ],
  DATABASE_PASSWORD: [ 'Required' ],
  NODE_ENV: [ 'Required' ],
  NEXTAUTH_URL: [ 'Required' ],
  NEXTAUTH_SECRET: [ 'Required' ],
  GITHUB_CLIENT_ID: [ 'Required' ],
  GITHUB_CLIENT_SECRET: [ 'Required' ],
  GOOGLE_CLIENT_ID: [ 'Required' ],
  GOOGLE_CLIENT_SECRET: [ 'Required' ],
  FACEBOOK_APP_ID: [ 'Required' ],
  FACEBOOK_CLIENT_SECRET: [ 'Required' ],
  TWITTER_API_KEY: [ 'Required' ],
  TWITTER_API_SECRET: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_API_KEY: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_AUTH_DOMAIN: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_PROJECT_ID: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_STORAGE_BUCKET: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_MESSAGING_SENDER_ID: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_APP_ID: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_MEASUREMENT_ID: [ 'Required' ],
  NEXT_PUBLIC_APP_URL: [ 'Required' ]
}
G:\GitHub\Meally\node_modules\.pnpm\@t3-oss+env-nextjs@0.6.0_typescript@5.1.6_zod@3.21.4\node_modules\@t3-oss\core\index.ts:205
        !prop.startsWith(opts.clientPrefix) &&

pnpm db:push

> meally@1.0.0 db:push G:\GitHub\Meally\apps\meally
> drizzle-kit push:mysql --config=drizzle.config.ts

drizzle-kit: v0.19.5
drizzle-orm: v0.27.2

Reading config file 'G:\GitHub\Meally\apps\meally\drizzle.config.ts'
❌ Invalid environment variables: {
  DATABASE_URL: [ 'Required' ],
  DATABASE_HOST: [ 'Required' ],
  DATABASE_USERNAME: [ 'Required' ],
  DATABASE_PASSWORD: [ 'Required' ],
  NODE_ENV: [ 'Required' ],
  NEXTAUTH_URL: [ 'Required' ],
  NEXTAUTH_SECRET: [ 'Required' ],
  GITHUB_CLIENT_ID: [ 'Required' ],
  GITHUB_CLIENT_SECRET: [ 'Required' ],
  GOOGLE_CLIENT_ID: [ 'Required' ],
  GOOGLE_CLIENT_SECRET: [ 'Required' ],
  FACEBOOK_APP_ID: [ 'Required' ],
  FACEBOOK_CLIENT_SECRET: [ 'Required' ],
  TWITTER_API_KEY: [ 'Required' ],
  TWITTER_API_SECRET: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_API_KEY: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_AUTH_DOMAIN: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_PROJECT_ID: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_STORAGE_BUCKET: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_MESSAGING_SENDER_ID: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_APP_ID: [ 'Required' ],
  NEXT_PUBLIC_FIREBASE_MEASUREMENT_ID: [ 'Required' ],
  NEXT_PUBLIC_APP_URL: [ 'Required' ]
}
G:\GitHub\Meally\node_modules\.pnpm\@t3-oss+env-nextjs@0.6.0_typescript@5.1.6_zod@3.21.4\node_modules\@t3-oss\core\index.ts:205
        !prop.startsWith(opts.clientPrefix) &&

Solution:

^- this. also, do you get the same error while building your app or just pushing? P.S. if you want to use dotenv as a workaround, you have to import variables using process.env.YOU_ENV_VAR as it won't affect the t3env env object...

Jump to solution

5 Replies

Lopen•12mo ago

Are you using the t3 stack?

Solution

Sturlen•12mo ago

baddra•12mo ago

baddra•12mo ago

If you are using planetscale you need these variables

Eirfire•12mo ago

Right ok thankyou, I’m not using the t3 stack just the environment variable package but I’ll try this

Gaming

Programming

Drizzle not pulling in environment variables