Imported from rafalszoltysik/Squimbo (.cursor/skills/friends-prisma-db/SKILL.md). Install upstream with npx skills add rafalszoltysik/Squimbo --skill friends-prisma-db. Copyright stays with the author.

Squimbo Prisma & database

Read first

1. packages/db/README.md
2. packages/db/prisma/schema.prisma
3. Prisma plugin: schema-conventions, migration-best-practices

Domain → API

Execution order

1. Align names with existing schema; both sides of relations; createdAt/updatedAt.
2. Edit schema.prisma; pnpm db:migrate from root (not db:push for prod-bound changes).
3. Update Nest services; always scope by authenticated user / membership.
4. Seed the most_likely bank from packages/db/prisma/prompt-bank.ts. Insert English rows only (Prompt_locale_en_only_check). Each entry also has bodyPl for a later PL bank; do not insert locale = pl until product + a migration drop that check.
5. Seed syncs (update via replaces to keep Prompt.id, insert missing, delete unreferenced leftovers). Do not wipe rounds/votes. No --force in production.
6. Prompt quality: docs/prompt-content.md. Mix editorial themes in prompt-bank.ts. No pack picker. Do not add spice / theme Prisma columns unless schema + migration are explicitly required.
7. Tests per friends-testing.

Commands

pnpm db:up
pnpm db:migrate
pnpm db:seed
pnpm db:generate