NuxtHub

NuxtHub provides the easiest way to add database persistence to your authentication. Enable NuxtHub and this module generates and manages your database schema.

Features

• Auto Schema Generation - Tables for users, sessions, accounts created automatically
• Plugin-Aware - Schema updates when you add plugins like twoFactor, passkey
• Multi-Dialect - SQLite, PostgreSQL, or MySQL
• Multi-Cloud - Deploy to Cloudflare, Vercel, or self-hosted infrastructure
• Secondary Storage - Optional KV storage for session caching
• Zero Config Migrations - Use npx nuxt db migrate for production

Setup

pnpm add @nuxthub/core

export default defineNuxtConfig({
  modules: [
    '@nuxthub/core',
    '@onmax/nuxt-better-auth'
  ],

  hub: {
    db: 'sqlite' // 'sqlite' | 'postgresql' | 'mysql'
  }
})

Configuration Options

The hub.db option accepts a string shorthand or full object:

export default defineNuxtConfig({
  hub: {
    db: 'sqlite' // shorthand: 'sqlite' | 'postgresql' | 'mysql'
    // or full object:
    // db: { dialect: 'postgresql', /* additional options */ }
  }
})

Secondary Storage (KV)

Enable KV storage for faster session lookups:

export default defineNuxtConfig({
  hub: {
    db: 'sqlite',
    kv: true
  },

  auth: {
    secondaryStorage: true
  }
})

Sessions are cached in NuxtHub KV, reducing database queries.

Production Migrations

NuxtHub handles migrations automatically in most deployments. For manual control:

Manual Migration

If you need to run migrations manually:

# Generate migrations from schema changes
npx nuxt db generate

# Apply pending migrations
npx nuxt db migrate

CI/CD Integration

Add to your GitHub Actions workflow:

- name: Run migrations
  run: npx nuxt db migrate
  env:
    NUXT_HUB_PROJECT_KEY: ${{ secrets.NUXTHUB_PROJECT_KEY }}

Schema Generation Details

The module analyzes your server/auth.config.ts at build time:

1. Reads plugins from your config
2. Generates Drizzle schema matching your dialect
3. Injects into NuxtHub via hub:db:schema:extend hook

Accessing the Database

With NuxtHub, you get access to the Drizzle database instance in your server config:

export default defineServerAuth(({ db }) => ({
  // db is the Drizzle instance from NuxtHub
}))