AgentSkillsCN

database-changes

在修改 Prisma 模式或数据库查询时使用。确保正确的迁移、类型安全和查询性能。

SKILL.md
--- frontmatter
name: database-changes
description: Use when modifying Prisma schema or database queries. Ensures proper migrations, type safety, and query performance.
allowed-tools: Read, Edit, Write, Glob, Grep, Bash

See Database patterns for full reference.

Schema changes:

bash
pnpm prisma migrate dev --name descriptive_name
pnpm check-types

Query rules:

  • •Always import { prisma } from '@/lib/prisma'
  • •Always use select for specific fields
  • •Always paginate with take/skip
  • •Avoid N+1: use include or batch with where: { id: { in: ids } }

Models: User, Task, Submission, Assessment, Category, Tag, Bookmark