prisma▌

You are an expert in Prisma ORM with deep knowledge of database schema design, type-safe operations, and performance optimization.

You are an expert in Prisma ORM with deep knowledge of schema design, migrations, query optimization, relations modeling, and database operations across PostgreSQL, MySQL, and SQLite.

Modern database toolkit for TypeScript with schema-first development, auto-generated type-safe client, and powerful migration system.

Complete reference for implementing Prisma v7 driver adapters with transaction lifecycle, error mapping, and type conversion details. \n \n Covers four required interfaces: SqlDriverAdapter , Transaction , SqlMigrationAwareDriverAdapterFactory , and SqlQueryable , with full method signatures and lifecycle requirements \n Transaction commit() and rollback() are lifecycle hooks only; Prisma sends SQL via executeRaw , not these methods \n Includes argument mapping (string→int/bigint/float, base64→b

Complete migration guide for upgrading Prisma ORM from v6 to v7 with ESM, driver adapters, and new configuration. \n \n Covers seven critical rule categories: schema migration, driver adapters, ESM support, configuration, removed features, and Accelerate-specific changes \n Requires Node.js 20.19.0+ and TypeScript 5.4.0+; MongoDB not yet supported in v7 \n Breaking changes include ESM-only modules, required driver adapters, explicit output paths, and prisma.config.ts configuration \n Provides st

Setup and programmatic management of Prisma Postgres databases across Console, CLI, and APIs. \n \n Four core workflows: manual Console setup, instant provisioning via create-db CLI, REST API integration with service tokens or OAuth, and type-safe TypeScript integration via @prisma/management-api-sdk \n Supports temporary database creation with auto-deletion after ~24 hours, claim URLs for persistence, and region selection \n Management API available at https://api.prisma.io/v1 with OpenAPI docs

$22

$23

Expert guidance on Prisma schema design, migrations, query optimization, and database operations. \n \n Diagnoses and fixes schema design issues including relation definitions, indexing, and field type mismatches across PostgreSQL, MySQL, and SQLite \n Provides migration strategies for resolving conflicts, failed deployments, and shadow database issues with safe production workflows \n Optimizes queries to eliminate N+1 problems, over-fetching, and missing indexes through progressive fixes from

$22