Skip to main content
prompt GP ChatGPT

Prisma ORM taste — ChatGPT prompt: what it does, how to install

Prisma ORM taste — a prompt for ChatGPT and Claude Code establishes pragmatic guidelines for database workflows with Prisma ORM. Directs model schema design, migrations, and query patterns.

CC0-1.0 ★ 178,201 updated 2026-10-24

Open on GitHub

What Prisma ORM taste does

This prompt instructs AI models to follow type-safe conventions when writing Prisma schemas and database queries. It enforces PascalCase naming, explicit cascade settings on both sides of every relation, and public identifiers using cuid() or uuid() instead of autoincrement integers.

Database operations stay behind a dedicated repository module rather than scattered across React Server Components or route handlers. For deployment, the prompt bans prisma db push on production, requiring versioned migrations via Prisma Migrate with backward-compatible column additions.

Multi-step writes rely on prisma.$transaction without external HTTP calls inside the transaction block. Raw queries require Prisma.sql tagged template literals to prevent unsafe string concatenation.

What it helps with

  • enforce strict conventions in schema.prisma and model relations
  • prevent unsafe production schema changes by blocking db push
  • decouple database queries from route handlers and server components
  • stop SQL injection by mandating Prisma.sql tagged templates

Example prompts for the agent

  • Audit this schema.prisma file against Prisma ORM taste rules.
  • Draft a zero-downtime migration to add a new column to the User table.
  • Write a findMany query using select to retrieve only the required user fields.

How to install Prisma ORM taste

How to use

Paste the text at the start of a chat or into project instructions

Questions about Prisma ORM taste

How to install Prisma ORM taste in Claude Code?

Add the prompt entry to .claude/commands/prompts.csv.md or paste the prompt text into your prompt instructions.

What does Prisma ORM taste do?

It guides the assistant to generate clean schema.prisma files, safe database migrations, and isolated query calls following production practices.

What does the prompt require for raw SQL queries?

It mandates using Prisma.sql tagged template literals and prohibits string concatenation with external user data.

Source text

prompts.csv · CC0-1.0
# Prisma ORM taste of a type-safe database pragmatist
- Treat `schema.prisma` as the source of truth for models, and generate the client in CI so `node_modules/.prisma` never drifts. Confidence: 0.95
- Prefer one Prisma schema per deployable service; split only when bounded contexts truly own separate databases. Confidence: 0.85
- Name models in PascalCase singular (`User`, `OrderItem`) and map table names explicitly when the database already exists. Confidence: 0.80
- Use `@id` with `cuid()` or `uuid()` for public IDs, and keep autoincrement integers for internal-only keys when you must. Confidence: 0.75
- Declare every relation with both sides and an explicit `onDelete` / `onUpdate` so cascade behavior is never accidental. Confidence: 0.90
- Add `@@index` and `@@unique` in the schema for every query pattern you rely on, and verify with `EXPLAIN` in staging. Confidence: 0.85
- Ship schema changes as Prisma Migrate migrations checked into git; never use `db push` against production. Confidence: 0.95
- Review generated SQL in each migration file before merging, especially drops, renames and type changes. Confidence: 0.90
- Keep migrations backward compatible across a rolling deploy: add columns nullable first, backfill, then tighten. Confidence: 0.85
- Use `prisma generate` in the Docker build and in postinstall only when the schema changed; avoid surprising local regenerations. Confidence: 0.75
- Prefer `findMany` with `select` or `include` that lists only needed fields; never return full rows to the API by default. Confidence: 0.85
- Wrap multi-step writes in `prisma.$transaction`, and keep transactions short with no external HTTP inside them. Confidence: 0.90
- Use interactive transactions sparingly; for simple batches prefer the array form of `$transaction`. Confidence: 0.80
- Put database access behind a small repository or data module, not sprinkled through React Server Components and route handlers. Confidence: 0.80
- Seed with `prisma db seed` using idempotent upserts so preview environments can rebuild safely. Confidence: 0.80
- Enable query logging in development and slow-query logging in production; treat N+1 patterns as bugs. Confidence: 0.85
- Use Prisma's typed `Prisma.XxxGetPayload` helpers for shared query shapes instead of hand-rolled interfaces that drift. Confidence: 0.80
- Pin the Prisma CLI and engine versions together, and upgrade them in a dedicated PR after reading the release notes. Confidence: 0.85
- For raw SQL, use `Prisma.sql` tagged templates only, never string concatenation with user input. Confidence: 0.95
- Run `prisma migrate diff` in CI against production's shadow database expectations so drift fails the build. Confidence: 0.75
- Document connection pooling (PgBouncer / driver adapter) in the runbook; serverless without a pool will exhaust connections. Confidence: 0.85

© f · CC0-1.0 · f/prompts.chat

Similar prompts

All prompts for Data and databases →

From the same set218

The whole set →
Solidity Smart Contract taste The Solidity Smart Contract taste prompt for ChatGPT, Claude.ai, and Claude Code sets security standards for writing Solidity smart contracts. It helps protocol engineers implement best practices during development. GP ChatGPT ★ 178,201repo stars Pandas Data Analysis taste The Pandas Data Analysis taste prompt for ChatGPT and Claude.ai offers a set of best practices for working with the Pandas library. It helps apply principles of reproducible data analysis. GP ChatGPT ★ 178,201repo stars Kafka Streaming taste Kafka Streaming taste is a prompt for ChatGPT, Claude.ai, and Claude Code that defines Kafka streaming architecture and design rules. GP ChatGPT ★ 178,201repo stars Helm Chart taste The Helm Chart taste ChatGPT prompt sets criteria for designing Helm charts. It helps review templates, security settings, and chart tests before release. GP ChatGPT ★ 178,201repo stars GitHub Actions taste The GitHub Actions taste ChatGPT prompt sets out practices for building CI with GitHub Actions. It covers checks, releases, and deployment safeguards. GP ChatGPT ★ 178,201repo stars Cloudflare Worker taste Cloudflare Worker taste — a prompt for ChatGPT and Claude.ai that sets engineering standards for Cloudflare Workers development. It enforces architectural principles for coding, secret management, and deployment. GP ChatGPT ★ 178,201repo stars Playwright E2E taste The Playwright E2E taste prompt for ChatGPT sets conventions for Playwright end-to-end tests. It covers core user journeys and test isolation, from local runs to CI. GP ChatGPT ★ 178,201repo stars Next.js App taste Next.js App taste — a prompt for ChatGPT and Claude.ai that enforces pragmatic Next.js App Router conventions. It steers code generation toward Server Components, safe caching, and strict data validation. GP ChatGPT ★ 178,201repo stars

Project sponsors

Companies that keep this analytics open