Prisma ORM patterns for Vendix database operations. Trigger: When editing schema.prisma, creating migrations, or using Prisma client.
apps/backend/prisma/schema.prisma.apps/backend/package.json and currently use Prisma 7.x.apps/backend/prisma/schema.prisma.apps/backend/prisma.config.ts.prisma.config.ts from process.env.DATABASE_URL, not in schema.prisma.@prisma/adapter-pg and pg.Pool in backend Prisma services.snake_case; enum values are mixed. Treat the schema as source of truth.Use domain-appropriate services instead of raw PrismaClient in request handlers:
| Domain | Service |
| --- | --- |
| domains/superadmin/ | GlobalPrismaService |
| domains/organization/ | OrganizationPrismaService |
| domains/store/ | StorePrismaService |
| domains/ecommerce/ | EcommercePrismaService |
| jobs/seeds/system scripts | GlobalPrismaService or explicit approved withoutScope() |
For model registration and tenant isolation details, use vendix-prisma-scopes.
Run from repo root unless stated otherwise:
npm run prisma:generate -w apps/backend
npm run prisma:studio -w apps/backend
npm run db:migrate:dev -w apps/backend
npm run db:migrate:prod -w apps/backend
npm run db:seed -w apps/backend
npm run db:reset -w apps/backend
npm run db:clean -w apps/backend
npm run db:reset-seed
Use vendix-prisma-migrations before creating/reviewing migration SQL.
withoutScope() in request handlers without explicit approval.vendix-prisma-schemavendix-prisma-migrationsvendix-prisma-scopesvendix-prisma-seedSearch for places (restaurants, cafes, etc.) via Google Places API proxy on localhost.
Interact with GitHub using the `gh` CLI. Use `gh issue`, `gh pr`, `gh run`, and `gh api` for issues, PRs, CI runs, and advanced queries.
Create or update AgentSkills. Use when designing, structuring, or packaging skills with scripts, references, and assets.
Start voice calls via the OpenClaw voice-call plugin.
Notion API for creating and managing pages, databases, and blocks.
Gemini CLI for one-shot Q&A, summaries, and generation.
Category:developer