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

Name: friends-prisma-db
Author: rafalszoltysik

Read first

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

Domain → API

Domain	Models	API
Identity	`User` (`discordId`)	`discord/`, `auth/`
Match	`GameRoom`, `RoomPlayer`	`game/`
Catalog	`Prompt`	seed + `game/`
Play	`Round`, `Vote`	`game/`

Execution order

Align names with existing schema; both sides of relations; createdAt/updatedAt.
Edit schema.prisma; pnpm db:migrate from root (not db:push for prod-bound changes).
Update Nest services; always scope by authenticated user / membership.
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.
Seed syncs (update via replaces to keep Prompt.id, insert missing, delete unreferenced leftovers). Do not wipe rounds/votes. No --force in production.
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.
Tests per friends-testing.

Commands

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

{ "ocm": "1", "id": "rafalszoltysik-squimbo-friends-prisma-db", "kind": "skill", "name": "friends-prisma-db", "description": "Squimbo Prisma schema, migrations, seed — PostgreSQL via @friends/db. Use when changing schema.prisma, models, migrations, db:seed, or Prisma queries for User, GameRoom, Round, Prompt, Vote.", "publisher": "rafalszoltysik", "version": "1.0.0", "capabilities": { "domains": [ "general" ], "tags": [ "skill-md", "github" ], "languages": [ "en" ] }, "quality_prior": 0.6, "examples": [ "Squimbo Prisma schema, migrations, seed — PostgreSQL via @friends/db. Use when changing schema.prisma, models, migrations, db:seed, or Prisma queries for User, GameRoom, Round, Prompt, Vote." ], "primary": false, "metadata": { "source": { "provider": "github", "repository": "https://github.com/rafalszoltysik/Squimbo", "path": ".cursor/skills/friends-prisma-db/SKILL.md", "ref": "21e88355f2c96d32f1c476494d3789edb4c1ad35", "url": "https://github.com/rafalszoltysik/Squimbo/blob/21e88355f2c96d32f1c476494d3789edb4c1ad35/.cursor/skills/friends-prisma-db/SKILL.md", "key": "rafalszoltysik/Squimbo/.cursor/skills/friends-prisma-db/SKILL.md" } }, "instructions": "# Squimbo Prisma & database\n\n## Read first\n\n1. [packages/db/README.md](../../../packages/db/README.md)\n2. `packages/db/prisma/schema.prisma`\n3. Prisma plugin: `schema-conventions`, `migration-best-practices`\n\n## Domain → API\n\n| Domain | Models | API |\n|--------|--------|-----|\n| Identity | `User` (`discordId`) | `discord/`, `auth/` |\n| Match | `GameRoom`, `RoomPlayer` | `game/` |\n| Catalog | `Prompt` | seed + `game/` |\n| Play | `Round`, `Vote` | `game/` |\n\n## Execution order\n\n1. Align names with existing schema; both sides of relations; `createdAt`/`updatedAt`.\n2. Edit `schema.prisma`; `pnpm d", "cost": { "context_tokens": 374 } }

friends-prisma-db

About

Squimbo Prisma & database

Read first

Domain → API

Execution order

Commands

Use it

Manifest

Reviews