database-operation

What problem does it solve?

This Skill standardizes and guides the creation of robust Prisma database queries and server-side operations, reducing boilerplate and errors.

Core Features & Use Cases

• Prisma Client Import: Always use the singleton client from ~/services/prisma.server to ensure consistent connections.
• Server Function Structure: Server functions go in app/server/ with .server.ts suffix and follow the provided patterns for fetching resources.
• CRUD & Relationships: Demonstrates create, read, update, delete operations and relationship patterns with Prisma models.
• Transactions & Safety: Covers using transactions for multi-step operations and basic ownership safety checks.

Quick Start

Create a paginated getResources example to fetch a user's resources.