DT
Drizzle Team•2y ago
wlvz

Invalid input Only "mysql2" is available options for "--driver"

I'm trying to run drizzle-kit introspect:mysql by following the docs and I have the config file: 
import type { Config } from "drizzle-kit";
import dotenv from "dotenv";
dotenv.config({ path: " .env.local" });

export default {
  schema: "./lib/db/schema.ts",
  out: "./drizzle",
  connectionString: process.env.DATABASE_URL,
} satisfies Config;
import type { Config } from "drizzle-kit";
import dotenv from "dotenv";
dotenv.config({ path: " .env.local" });

export default {
  schema: "./lib/db/schema.ts",
  out: "./drizzle",
  connectionString: process.env.DATABASE_URL,
} satisfies Config;
and in my package.json I have: 
    "introspect": "drizzle-kit introspect:mysql"
    "introspect": "drizzle-kit introspect:mysql"
in my scripts. But when I go to run "npm run introspect" I get the error: 
drizzle-kit: v0.19.2
drizzle-orm: v0.27.0

No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/user/Code/testproject/drizzle.config.ts'
 Invalid input  Only "mysql2" is available options for "--driver"
drizzle-kit: v0.19.2
drizzle-orm: v0.27.0

No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/user/Code/testproject/drizzle.config.ts'
 Invalid input  Only "mysql2" is available options for "--driver"
2 Replies
wlvz
wlvzOP•2y ago
I tried running drizzle-kit introspect:mysql2 and I get the error: 
error: unknown command 'introspect:mysql2'
(Did you mean introspect:mysql?)
error: unknown command 'introspect:mysql2'
(Did you mean introspect:mysql?)
Andrii Sherman
Andrii Sherman•2y ago
Please check update syntax for config https://orm.drizzle.team/kit-docs/config-reference You need to define driver and pust connectionString inside dbCredentials

Did you find this page helpful?