metabuilder/.github/prompts/implement/backend/3-impl-database.prompt.md

Database Query Pattern

Always use the Database class wrapper, never raw Prisma:

Run app commands from frontends/nextjs/.

// ✅ Correct - with tenant isolation
const users = await Database.getUsers({ tenantId: user.tenantId })
await Database.setSchemas(schemas, { tenantId })

// ❌ Wrong - raw Prisma, no tenant filter
const users = await prisma.user.findMany()

After schema changes in prisma/schema.prisma:

npm run db:generate  # Regenerate Prisma client
npm run db:push      # Push to database

Key file: frontends/nextjs/src/lib/database.ts