Cannot find driver! mysql2 or pg.
I'm trying to run drizzle-kit studio can get this error:
Error [ERR_MODULE_NOT_FOUND]: Cannot find package 'mysql2' imported from C:\Users\rober\code\projects\drizsup\node_modules\drizzle-orm\mysql2\index.mjs
Here is my drizzle.config.ts:
import type { Config } from "drizzle-kit";
export default {
schema: "./src/lib/schema.ts",
out: "./src/lib/db",
driver: "mysql2",
dbCredentials: {
connectionString: process.env.DATABASE_URL,
},
} satisfies Config;
If I remove the driver option it says no driver option found, if I add driver: mysql2 or pg it says cannot find driver mysql2 or pg? Looked through other help questions couldn't find a solution.
Error [ERR_MODULE_NOT_FOUND]: Cannot find package 'mysql2' imported from C:\Users\rober\code\projects\drizsup\node_modules\drizzle-orm\mysql2\index.mjs
Here is my drizzle.config.ts:
import type { Config } from "drizzle-kit";
export default {
schema: "./src/lib/schema.ts",
out: "./src/lib/db",
driver: "mysql2",
dbCredentials: {
connectionString: process.env.DATABASE_URL,
},
} satisfies Config;
If I remove the driver option it says no driver option found, if I add driver: mysql2 or pg it says cannot find driver mysql2 or pg? Looked through other help questions couldn't find a solution.