Menu
Create a new database service following the FXFlow pattern.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
| name | add-db-service |
| description | Create a new database service following the FXFlow pattern. |
| disable-model-invocation | true |
Create a new Prisma service file following established patterns.
$ARGUMENTS[0] — Domain name (e.g., "alert-rule")$ARGUMENTS[1] — Brief descriptionpackages/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"
// Follow patterns from existing services:
// - Export typed functions (not classes)
// - Use getDb() for Prisma client
// - Include create, get, list, update, delete as needed
// - Add cleanup method for old records if applicable
// - Keep under 250 LOC
packages/db/src/index.ts — Export the new service.
Run /verify.
Run full repo verification (lint, typecheck, test, security, diff review) and fix failures.
Audit documentation freshness — find docs that are stale or missing coverage for recent code changes.
Create a new Next.js API route with proper typing and error handling.
Add a new daemon REST endpoint with types, handler, web API proxy, and hook.
Wire a new WebSocket event end-to-end (daemon → types → hook → component).
Refactor code to meet file-size limits and DRY rules without changing behavior.