Cannot read properties of undefined (reading 'connectionString')

In my drizzle.config.ts I have the code:

import type { Config } from "drizzle-kit";
import 'dotenv/config'

export default {
  schema: "./lib/db/schema.ts",
  out: "./drizzle",
  connectionString: process.env.DATABASE_URL,
  driver: "mysql2",
} satisfies Config;

import type { Config } from "drizzle-kit";
import 'dotenv/config'

export default {
  schema: "./lib/db/schema.ts",
  out: "./drizzle",
  connectionString: process.env.DATABASE_URL,
  driver: "mysql2",
} satisfies Config;

and when I go to run drizzle-kit introspect:mysql I get the error:

TypeError: Cannot read properties of undefined (reading 'connectionString').

TypeError: Cannot read properties of undefined (reading 'connectionString').

I checked my .env.local and DATABASE_URL is defined:

DATABASE_URL='mysql://[email protected]/username?ssl={"rejectUnauthorized":true}'

DATABASE_URL='mysql://[email protected]/username?ssl={"rejectUnauthorized":true}'

2 Replies

Andrii Sherman•2y ago

Please check latest config setup https://orm.drizzle.team/kit-docs/config-reference

Configuring Drizzle kit – DrizzleORM

Drizzle ORM | %s

Andrii Sherman•2y ago

you need to put connectionString under dbCredentials field

Gaming

Programming

Cannot read properties of undefined (reading 'connectionString')