Drizzle TeamDT
Drizzle Team•2y ago
patryk

Troubles during migrations using drizzle and a neon serverless database

Hello im really new to drizzle and i already learned how to setup a scheme but im having troubles when i want to migrate it to the neon postgressql database.

Error: No database connection string was provided to neon(). Perhaps an environment variable has not been set?

This is how my migration file looks like:

import { migrate } from 'drizzle-orm/neon-http/migrator';
import { drizzle, NeonHttpDatabase } from 'drizzle-orm/neon-http'
import { neon } from '@neondatabase/serverless';


async function main() {
    const sql = neon(process.env.DATABASE_URL as string)
    const db: NeonHttpDatabase = drizzle(sql);

    console.log("[migrate] Running migrations ...");

    await migrate(db, {migrationsFolder: "lib/db/migrations" });

    console.log("[migrate] All migrations have been ran, exiting ...");
}

main();
Was this page helpful?