BA
Better Auth•2w ago
Jacob

Can't use @better-auth/cli when exporting a auth function

I am using Better Auth across my api (hono + cloudflare workers) and fronted (nextjs + vercel), so far so good however when i want to run the bunx @better-auth/cli generate i get the following error: 
$ bunx @better-auth/cli generate --config ../api/src/common/auth.ts --output ./src/schemas/auth.ts
ERROR [Better Auth]: [#better-auth]: Couldn't read your auth config in BuzzTrip/packages/api/src/common/auth.ts. Make sure to default export your auth instance or to export as a variable named auth.
error: script "db:auth" exited with code 1
$ bunx @better-auth/cli generate --config ../api/src/common/auth.ts --output ./src/schemas/auth.ts
ERROR [Better Auth]: [#better-auth]: Couldn't read your auth config in BuzzTrip/packages/api/src/common/auth.ts. Make sure to default export your auth instance or to export as a variable named auth.
error: script "db:auth" exited with code 1
my auth config is setup like so: 
export const createAuth = (
  baseUrl: string,
  authSecret: string,
  googleClientId: string,
  googleClientSecret: string,
  url: string,
  authToken: string
) => {
  const db = createDb(url, authToken);

  return betterAuth({
    // ... config
  });
};

export type Auth = ReturnType<typeof createAuth>;
export const createAuth = (
  baseUrl: string,
  authSecret: string,
  googleClientId: string,
  googleClientSecret: string,
  url: string,
  authToken: string
) => {
  const db = createDb(url, authToken);

  return betterAuth({
    // ... config
  });
};

export type Auth = ReturnType<typeof createAuth>;
Since we need to pass in env's from the cloudflare context, we need to create the auth client rather than just existing. my repo: https://github.com/jacobsamo/BuzzTrip branch: https://github.com/jacobsamo/BuzzTrip/tree/feat/migrate-to-better-auth code causing the problem: https://github.com/jacobsamo/BuzzTrip/blob/feat/migrate-to-better-auth/apps/api/src/common/auth.ts run from: https://github.com/jacobsamo/BuzzTrip/blob/feat/migrate-to-better-auth/packages/db/package.json
GitHub
GitHub - jacobsamo/BuzzTrip: Plan the trip you've always dreamed of
Plan the trip you've always dreamed of. Contribute to jacobsamo/BuzzTrip development by creating an account on GitHub.
GitHub
GitHub - jacobsamo/BuzzTrip at feat/migrate-to-better-auth
Plan the trip you've always dreamed of. Contribute to jacobsamo/BuzzTrip development by creating an account on GitHub.
GitHub
BuzzTrip/apps/api/src/common/auth.ts at feat/migrate-to-better-auth...
Plan the trip you've always dreamed of. Contribute to jacobsamo/BuzzTrip development by creating an account on GitHub.
GitHub
BuzzTrip/packages/db/package.json at feat/migrate-to-better-auth · ...
Plan the trip you've always dreamed of. Contribute to jacobsamo/BuzzTrip development by creating an account on GitHub.
Solution:
you can call ```ts import { getMigrations } from "better-auth/db"; const { runMigrations } = await getMigrtions(auth.options);...
Jump to solution
5 Replies
bekacru
bekacru•7d ago
you can't run the CLI in this setup. You sohuld call run migration programatically. Or I think cf recently added the ability to acess env without handler context.
Jacob
JacobOP•6d ago
Yeah okay, didn’t think of that, so have to call the function programmatically with the passed items and run the migration? What would something like this work? I am using bun
Solution
bekacru
bekacru•6d ago
you can call 
import { getMigrations } from "better-auth/db";

const { runMigrations } = await getMigrtions(auth.options);
await runMigratinos() //this will run the migrations for you
import { getMigrations } from "better-auth/db";

const { runMigrations } = await getMigrtions(auth.options);
await runMigratinos() //this will run the migrations for you
Jacob
JacobOP•6d ago
Oh cool, thank you for the example that’s very helpful
Jacob
JacobOP•5d ago
When running similiar code: 
import { getMigrations } from "better-auth/db";
import { createAuth } from "./auth";

const auth = await createAuth(
  process.env.API_URL!,
  process.env.FRONT_END_URL!,
  process.env.AUTH_SECRET!,
  process.env.GOOGLE_CLIENT_ID!,
  process.env.GOOGLE_CLIENT_SECRET!,
  process.env.TURSO_CONNECTION_URL!,
  process.env.TURSO_AUTH_TOKEN!,
  process.env.RESEND_API_KEY!
);

const { runMigrations } = await getMigrations(auth.options);

await runMigrations(); //this will run the migrations for you
import { getMigrations } from "better-auth/db";
import { createAuth } from "./auth";

const auth = await createAuth(
  process.env.API_URL!,
  process.env.FRONT_END_URL!,
  process.env.AUTH_SECRET!,
  process.env.GOOGLE_CLIENT_ID!,
  process.env.GOOGLE_CLIENT_SECRET!,
  process.env.TURSO_CONNECTION_URL!,
  process.env.TURSO_AUTH_TOKEN!,
  process.env.RESEND_API_KEY!
);

const { runMigrations } = await getMigrations(auth.options);

await runMigrations(); //this will run the migrations for you
i end with this error: 
 bun ./src/common/auth-migrate.ts
2025-03-30T05:10:41.783Z WARN [Better Auth]: Could not determine database type, defaulting to sqlite. Please provide a type in the database options to avoid this.
2025-03-30T05:10:41.783Z ERROR [Better Auth]: Only kysely adapter is supported for migrations. You can use `generate` command to generate the schema, if you're using a different adapter.
 bun ./src/common/auth-migrate.ts
2025-03-30T05:10:41.783Z WARN [Better Auth]: Could not determine database type, defaulting to sqlite. Please provide a type in the database options to avoid this.
2025-03-30T05:10:41.783Z ERROR [Better Auth]: Only kysely adapter is supported for migrations. You can use `generate` command to generate the schema, if you're using a different adapter.
this is my createAuth function: 
export const createAuth = (
  /**Our API url */
  baseUrl: string,
  /**Where the fronted is hosted */
  frontEndUrl: string,
  /**Our auth secret to handle hashing */
  authSecret: string,
  googleClientId: string,
  googleClientSecret: string,
  /**Db connection URL */
  url: string,
  /** Db auth token */
  authToken: string,
  resendApiKey: string
) => {
  const db = createDb(url, authToken);

  return betterAuth({
    appName: "BuzzTrip",
    baseURL: baseUrl,
    basePath: "/auth",
    secret: authSecret,
    trustedOrigins: [frontEndUrl],
    database: drizzleAdapter(db, {
      provider: "sqlite", // or "mysql", "sqlite"`
      schema: {
        ...schemas,
        user: schemas.users,
      },
    }),
    // ... other options
  });
};

export type Auth = ReturnType<typeof createAuth>;
export const createAuth = (
  /**Our API url */
  baseUrl: string,
  /**Where the fronted is hosted */
  frontEndUrl: string,
  /**Our auth secret to handle hashing */
  authSecret: string,
  googleClientId: string,
  googleClientSecret: string,
  /**Db connection URL */
  url: string,
  /** Db auth token */
  authToken: string,
  resendApiKey: string
) => {
  const db = createDb(url, authToken);

  return betterAuth({
    appName: "BuzzTrip",
    baseURL: baseUrl,
    basePath: "/auth",
    secret: authSecret,
    trustedOrigins: [frontEndUrl],
    database: drizzleAdapter(db, {
      provider: "sqlite", // or "mysql", "sqlite"`
      schema: {
        ...schemas,
        user: schemas.users,
      },
    }),
    // ... other options
  });
};

export type Auth = ReturnType<typeof createAuth>;

Did you find this page helpful?