| name | add-db-service |
| description | Create a new database service following the FXFlow pattern. |
| disable-model-invocation | true |
Add DB Service
Create a new Prisma service file following established patterns.
Arguments
$ARGUMENTS[0] — Domain name (e.g., "alert-rule")
$ARGUMENTS[1] — Brief description
Steps
-
packages/db/prisma/schema.prisma — Add the Prisma model:
model AlertRule {
id String @id @default(uuid())
// ... fields
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([...])
}
-
Run migration: cd packages/db && npx prisma migrate dev --name add-alert-rule
-
packages/db/src/alert-rule-service.ts — Create service file:
import { getDb } from "./client"
-
packages/db/src/index.ts — Export the new service.
-
Run /verify.
Conventions
- One file per domain
- Export functions, not classes
- Use getDb() (lazy-init Prisma client)
- Encrypt sensitive fields via encryption.ts
- Include cleanup methods for time-series data