CursorPrismaDatabase

Prisma Cursor Rules

Cursor rules for Prisma ORM: schema design, query optimization, migrations, and type-safe database access patterns.

.cursorrules
- Use select and include explicitly; never return full models with unbounded data
- Batch multiple reads with Promise.all; use $transaction for multi-step writes
- Add @@index decorators for all query patterns you know about upfront
- Use prisma.$extends for query middleware and model extensions
- Never run prisma db push in production; always use prisma migrate deploy
- Use Prisma's soft delete pattern (deletedAt) over hard deletes for auditable data
- Enable query logging in development to catch N+1 issues early
- Use connectionLimit in the database URL for serverless environments

How to use with Cursor

Create a `.cursorrules` file in your project root and paste these rules. Cursor reads this automatically on every AI interaction.

#prisma#orm#database#typescript#cursor#coding-rules

Related Rules