prisma-data-model

Enforce tenant-scoped queries, soft deletes, RBAC, and audit logging in Prisma data models.

Updated Dec 26, 2025
One-click install
npx skills add https://github.com/DeltaFoundry850/crispy-fishstick --skill prisma-data-model-deltafoundry850
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: prisma-data-model
Source: https://github.com/DeltaFoundry850/crispy-fishstick/tree/main/.agent/skills/prisma-data-model
Command: npx skills add https://github.com/DeltaFoundry850/crispy-fishstick --skill prisma-data-model-deltafoundry850

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill ensures secure, multi-tenant data modeling with Prisma by guiding schema design, query scoping, and validation.

Core Features & Use Cases

  • Multi-tenant data isolation: always scope queries by tenantId to prevent cross-tenant leakage.
  • Soft-delete and archival handling: consistently filter deletedAt and track deletion metadata.
  • Audit and validation integration: enforce RBAC, audit trails, and input validation with Prisma, migrations, and Zod schemas.

Quick Start

Update the Prisma schema, generate the client, run migrations, and update validations to align the data model with the application.

Frequently Asked Questions about prisma-data-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I enforce multi-tenant data isolation in a Prisma database?

Multi-tenant data isolation in Prisma requires scoping all queries by tenantId to prevent cross-tenant leakage. This approach ensures tenant-scoped queries maintain strict data boundaries alongside soft deletes, RBAC, and audit logging.

What is the best way to implement soft deletes and audit logging with Prisma?

Implementing soft deletes and audit logging with Prisma involves consistently filtering deletedAt fields and tracking deletion metadata. This ensures audit trails capture mutation data while maintaining data integrity across multi-tenant schemas.

Can I use Zod schema validation with Prisma for multi-tenant RBAC?

Yes, Zod schema validation integrates with Prisma to enforce RBAC and input validation for multi-tenant applications. This combination ensures tenant-scoped queries, explicit field selection, and transactional safety during data mutations.

Does Prisma support transactional safety for multi-tenant data mutations?

Prisma supports transactional safety for multi-tenant data mutations by enforcing constraints around tenantId inclusion and explicit field selection. This prevents cross-tenant leakage and maintains secure data modeling during complex database operations.

How do I set up a multi-tenant Prisma schema with migrations?

Setting up a multi-tenant Prisma schema involves updating the schema file, generating the client, running migrations, and updating validations. This aligns the data model with the application while enforcing tenantId scoping and deletedAt filtering.