closes #6606

Docs

Custom Schema namespace

If you're using PostgreSQL and you want to generate the schema with a custom schema namespace,
you can pass the schemaName option to the Drizzle adapter.

export const auth = betterAuth({
  database: drizzleAdapter(db, {
    provider: "pg",
    schemaName: "auth", // [!code highlight]
  }),
});

Then when using the Better Auth CLI, it will generate the schema that looks something like this:

npx @better-auth/cli@latest generate

export const authSchema = pgSchema("auth");

export const user = authSchema.table("user", {...});
export const session = authSchema.table("session", {...});

Summary by cubic

Add schemaName support to the Drizzle adapter so the CLI can generate PostgreSQL schemas under a custom namespace. MySQL and SQLite remain unchanged.

• New Features

  • Added schemaName to DrizzleAdapterConfig.
  • CLI generator imports pgSchema only when schemaName is set, declares const Schema = pgSchema(""), and uses Schema.table(...) for PostgreSQL.
  • Converts schemaName to a safe identifier (handles hyphens, non-alphanumerics, leading numbers).
  • Updated docs and added tests/snapshots for pg with/without schemaName; sqlite/mysql ignore schemaName.

• Migration

  • PostgreSQL: set schemaName in drizzleAdapter config and re-run the Better Auth CLI.
  • No action needed for MySQL or SQLite.

^{Written for commit 47c7b2e. Summary will update on new commits.}