Theo's Typesafe Cult•2y 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

> [email protected] 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\@[email protected][email protected][email protected]\node_modules\@t3-oss\core\index.ts:205
        !prop.startsWith(opts.clientPrefix) &&

pnpm db:push

> [email protected] 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\@[email protected][email protected][email protected]\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•2y ago

Are you using the t3 stack?

Solution

Sturlen•2y ago

baddra•2y ago

baddra•2y ago

If you are using planetscale you need these variables

JacobOP•2y 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