Init Drizzle with cloudflare env variables

I'm trying to connect my database with the drizzle adapter. My backend will be hosted on cloudflare workers (with hono) so I can't use process.env to get my environement variables. How to get my cloudflare env variables to the db init ?

Thanks for your help!

import { drizzle } from "drizzle-orm/neon-http";
import { neon } from "@neondatabase/serverless";

interface Env {
  Bindings: { DATABASE_URL: string };
}

const sql = neon("DATABASE_URL");

export const db = drizzle(sql);

import { drizzle } from "drizzle-orm/neon-http";
import { neon } from "@neondatabase/serverless";

interface Env {
  Bindings: { DATABASE_URL: string };
}

const sql = neon("DATABASE_URL");

export const db = drizzle(sql);

import { drizzle } from "drizzle-orm/neon-http";
import { neon } from "@neondatabase/serverless";

interface Env {
  Bindings: { DATABASE_URL: string };
}

const sql = neon("DATABASE_URL");

export const db = drizzle(sql);

import { drizzle } from "drizzle-orm/neon-http";
import { neon } from "@neondatabase/serverless";

interface Env {
  Bindings: { DATABASE_URL: string };
}

const sql = neon("DATABASE_URL");

export const db = drizzle(sql);

Solution

import { drizzle } from "drizzle-orm/d1";
import * as schema from "./auth-schema";

export const createDrizzle = (db: D1Database) => drizzle(db, { schema });

import { drizzle } from "drizzle-orm/d1";
import * as schema from "./auth-schema";

export const createDrizzle = (db: D1Database) => drizzle(db, { schema });

import { drizzle } from "drizzle-orm/d1";
import * as schema from "./auth-schema";

export const createDrizzle = (db: D1Database) => drizzle(db, { schema });

import { drizzle } from "drizzle-orm/d1";
import * as schema from "./auth-schema";

export const createDrizzle = (db: D1Database) => drizzle(db, { schema });

Jump to solution

Ping•3/19/25, 6:57 PM

I don't use Hono, but from what I've seen with other users, it should look something like this:

export const createAuth = (env: CloudflareBindings) =>
    betterAuth({
        database: drizzleAdapter(createDrizzle(env.DB), { provider: "sqlite" }),
        secret: "some-secret-value-here",
        emailAndPassword: {
            enabled: true,
        },
    });

export type Auth = ReturnType<typeof createAuth>;

export const createAuth = (env: CloudflareBindings) =>
    betterAuth({
        database: drizzleAdapter(createDrizzle(env.DB), { provider: "sqlite" }),
        secret: "some-secret-value-here",
        emailAndPassword: {
            enabled: true,
        },
    });

export type Auth = ReturnType<typeof createAuth>;

fluchatOP•3/19/25, 7:02 PM

thank you so much! do you have the complete codebase?

fluchatOP•3/19/25, 7:02 PM

@Ping

Solution

Ping•3/19/25, 7:08 PM

import { drizzle } from "drizzle-orm/d1";
import * as schema from "./auth-schema";

export const createDrizzle = (db: D1Database) => drizzle(db, { schema });

import { drizzle } from "drizzle-orm/d1";
import * as schema from "./auth-schema";

export const createDrizzle = (db: D1Database) => drizzle(db, { schema });

Ping•3/19/25, 7:08 PM

This is just me searching through the better-auth codebase.

Ping•3/19/25, 7:09 PM

Must be some demo / testing code

fluchatOP•3/19/25, 7:14 PM

thanks a lot! I think I get it, still trying to figure it out on my own code base, will update this post with my solution for others :)

fluchatOP•3/19/25, 9:54 PM

https://tenor.com/view/there-you-have-it-boys-case-closed-the-simpsons-gif-13616870

Tenor

Init Drizzle with cloudflare env variables

Similar Threads

Similar Threads

Similar Threads