Agent skill · software engineering · aiskillstore

prisma-v7

Expert guidance for Prisma ORM v7 (7.0+). Use when working with Prisma schema files, migrations, Prisma Client queries, database setup, or when the user mentions Prisma, schema.prisma, @prisma/client, database models, or ORM. Covers ESM modules, driver adapters, prisma.config.ts, Rust-free client, and migration from v6.

Why this skill is useful

Provides specific guidance on Prisma ORM v7 features, including configuration and adapter usage that the AI wouldn't reliably generate on its own.

What it needs

Requires @prisma/adapter-better-sqlite3, @prisma/adapter-mariadb, @prisma/adapter-pg, @prisma/client, better-sqlite3, dotenv, mariadb, pg, prisma, tsx installed locally. About 8k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.

What this skill does

Prisma ORM v7 Expert Skill Comprehensive guidance for working with Prisma ORM version 7.x and later. Core v7 Changes 1. ES Modules (ESM) Required Prisma v7 ships as an ES module. Your project must use ESM: package.json: tsconfig.json: 2. Driver Adapters Required All databases now require driver adapters. The Rust-free client provides better performance and smaller bundle sizes. Available Adapters: PostgreSQL: @prisma/adapter-pg (with pg driver) MySQL/MariaDB: @prisma/adapter-mariadb (with mariadb driver) SQLite: @prisma/adapter-better-sqlite3 (with better-sqlite3) CockroachDB: @prisma/adapter-pg (with pg driver) Neon: @prisma/adapter-neon (with @neondatabase/serverless) PlanetScale: @prisma/adapter-planetscale (with @planetscale/database) D1 (Cloudflare): @prisma/adapter-d1 MSSQL: @prisma/adapter-mssql 3. Generator Configuration The output field is now required and the new prisma-client provider is standard: Note: Client is no longer generated in nodemodules by default. 4. Prisma Config File (prisma.config.ts) Database URLs and CLI configuration now live in prisma.config.ts instead of the schema file. Basic setup: Note: For Bun, skip import 'dotenv/config' as it auto-loads .env files. 5. Schema Datasource Block Remove url, directUrl, and shadowDatabaseUrl from schema.prisma: v7 schema.prisma: Installation & Setup New Project Upgrading from v6 Client Instantiation PostgreSQL Example MySQL/MariaDB Example SQLite Example Prisma Accelerate (Caching/Pooling) If using Prisma Accelerate for caching, do NOT use a driver adapter: Important: Never pass prisma:// or prisma+postgres:// URLs to driver adapters. Schema Best Practices Complete Schema Example Relations One-to-Many: Many-to-Many: One-to-One: Common Commands Prisma Client Queries Basic CRUD Relations Advanced Queries Migration Workflow Development Production Prototyping Environment Variables .env: Connection Pooling In v7, connection pooling is handled by the driver adapter, not by Prisma's URL parameters. …

How to use it

Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:

@skills aiskillstore/prisma-v7

View the source on GitHub

Browse the @skills marketplace