fix(db): resolve Nuxt aliases in schema bundling (#802)

onmax · atinux · web-flow · commit 48db8178ce59 · 2026-01-30T10:11:28.000+01:00
Co-authored-by: Sébastien Chopin &lt;seb@nuxt.com&gt;
diff --git a/cli/commands/db/generate.mjs b/cli/commands/db/generate.mjs
@@ -3,6 +3,7 @@ import { consola } from 'consola'
 import { execa } from 'execa'
 import { join, resolve } from 'pathe'
 import { buildDatabaseSchema } from '@nuxthub/core/db'
+import { getTsconfigAliases } from '../../utils/db.mjs'
 
 export default defineCommand({
   meta: {
@@ -36,7 +37,8 @@ export default defineCommand({
     }
     consola.info('Ensuring database schema is generated...')
     await execa(options)`nuxt prepare`
-    await buildDatabaseSchema(join(options.cwd, '.nuxt'), { relativeDir: cwd })
+    const alias = await getTsconfigAliases(cwd)
+    await buildDatabaseSchema(join(options.cwd, '.nuxt'), { relativeDir: cwd, alias })
     consola.info('Generating database migrations...')
     const { stderr } = await execa({
       ...options,
diff --git a/cli/commands/db/squash.mjs b/cli/commands/db/squash.mjs
@@ -5,6 +5,7 @@ import { readFile, writeFile, rm } from 'node:fs/promises'
 import { join, resolve } from 'pathe'
 import { buildDatabaseSchema, createDrizzleClient } from '@nuxthub/core/db'
 import { sql } from 'drizzle-orm'
+import { getTsconfigAliases } from '../../utils/db.mjs'
 
 export default defineCommand({
   meta: {
@@ -171,7 +172,8 @@ export default defineCommand({
     consola.debug('Updated journal file')
 
     // Build schema and generate fresh migration
-    await buildDatabaseSchema(join(cwd, '.nuxt'), { relativeDir: cwd })
+    const alias = await getTsconfigAliases(cwd)
+    await buildDatabaseSchema(join(cwd, '.nuxt'), { relativeDir: cwd, alias })
     consola.info('Generating new migration...')
     const { stderr } = await execa({
       ...execaOptions,
diff --git a/cli/utils/db.mjs b/cli/utils/db.mjs
@@ -1,4 +1,5 @@
-import { join } from 'pathe'
+import { readFile } from 'node:fs/promises'
+import { join, resolve } from 'pathe'
 import { createStorage } from 'unstorage'
 import fsDriver from 'unstorage/drivers/fs'
 
@@ -32,3 +33,18 @@ export async function getNextMigrationNumber() {
 
   return (lastSequentialMigrationNumber + 1).toString().padStart(4, '0')
 }
+
+export async function getTsconfigAliases(cwd) {
+  try {
+    const tsconfig = JSON.parse(await readFile(join(cwd, '.nuxt/tsconfig.json'), 'utf-8'))
+    const paths = tsconfig.compilerOptions?.paths || {}
+    const alias = {}
+    for (const [key, values] of Object.entries(paths)) {
+      const resolvedPath = key.endsWith('/*') ? values[0].replace(/\/\*$/, '') : values[0]
+      alias[key.replace(/\/\*$/, '')] = resolve(join(cwd, '.nuxt'), resolvedPath)
+    }
+    return alias
+  } catch {
+    return {}
+  }
+}
diff --git a/src/db/lib/build.ts b/src/db/lib/build.ts
@@ -80,7 +80,7 @@ export async function applyBuildTimeMigrations(nitro: Nitro, hub: ResolvedHubCon
   }
 }
 
-export async function buildDatabaseSchema(buildDir: string, { relativeDir }: { relativeDir?: string } = {}) {
+export async function buildDatabaseSchema(buildDir: string, { relativeDir, alias }: { relativeDir?: string, alias?: Record<string, string> } = {}) {
   relativeDir = relativeDir || buildDir
   const entry = join(buildDir, 'hub/db/schema.entry.ts')
   await build({
@@ -93,6 +93,7 @@ export async function buildDatabaseSchema(buildDir: string, { relativeDir }: { r
       dts: '.d.mts'
     }),
     alias: {
+      ...alias,
       'hub:db:schema': entry
     },
     platform: 'neutral',
diff --git a/src/db/setup.ts b/src/db/setup.ts
@@ -253,7 +253,7 @@ async function generateDatabaseSchema(nuxt: Nuxt, hub: ResolvedHubConfig) {
       log.info('Make sure to run `npx nuxt db generate` to generate the database migrations.')
       schemaPaths = await getSchemaPaths()
       await updateTemplates({ filter: template => template.filename.includes('hub/db/schema.entry.ts') })
-      await buildDatabaseSchema(nuxt.options.buildDir, { relativeDir: nuxt.options.rootDir })
+      await buildDatabaseSchema(nuxt.options.buildDir, { relativeDir: nuxt.options.rootDir, alias: nuxt.options.alias })
 
       // Also copy to node_modules/@nuxthub/db/ for workflow compatibility
       const physicalDbDir = join(nuxt.options.rootDir, 'node_modules', '@nuxthub', 'db')
@@ -276,8 +276,7 @@ async function generateDatabaseSchema(nuxt: Nuxt, hub: ResolvedHubConfig) {
 
   // Build schema types during prepare/dev/build, then copy to node_modules
   nuxt.hooks.hookOnce('app:templatesGenerated', async () => {
-    // Build first
-    await buildDatabaseSchema(nuxt.options.buildDir, { relativeDir: nuxt.options.rootDir })
+    await buildDatabaseSchema(nuxt.options.buildDir, { relativeDir: nuxt.options.rootDir, alias: nuxt.options.alias })
 
     // Then copy to node_modules/@nuxthub/db/ for workflow compatibility
     const physicalDbDir = join(nuxt.options.rootDir, 'node_modules', '@nuxthub', 'db')
