==================
/// MCP ///
/// PRI ///
==================
[server:online]
[protocol:ready]prisma
by prisma
Next-generation ORM for Node.js & TypeScript supporting PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB.
43.0k
1.8k
Open Source01
Prisma Client
Auto-generated and type-safe query builder for Node.js & TypeScript
02
Prisma Migrate
Declarative data modeling & migration system
03
Prisma Studio
GUI to view and edit data in your database
Installation
1. Install the CLI and runtime dependency in your Node.js/TypeScript project:
• With npm : npm install --save-dev prisma && npm install @prisma/client
• With yarn : yarn add -D prisma && yarn add @prisma/client
• With pnpm : pnpm add -D prisma && pnpm add @prisma/client
2. Initialise Prisma (creates prisma/schema.prisma and .env):
npx prisma init3. Configure your database connection string inside the generated .env file, e.g.
DATABASE_URL="postgresql://USER:PASSWORD@localhost:5432/mydb?schema=public"4. Model your data in prisma/schema.prisma using the Prisma Schema Language (PSL). Example:
model User {
id Int @id @default(autoincrement())
email String @unique
name String?
}5. Create and run the first migration:
npx prisma migrate dev --name init
# Generates SQL, applies it and regenerates the Prisma Client.6. Generate (or regenerate) the Prisma Client manually when required:
npx prisma generate7. Use the generated, type-safe client in your code:
import { PrismaClient } from '@prisma/client';
const prisma = new PrismaClient();
const users = await prisma.user.findMany();8. Optional tooling:
• Inspect data in a GUI – npx prisma studio
• Seed data – npx prisma db seed
• Node.js ≥ 14.17
• A supported database (PostgreSQL, MySQL/MariaDB, SQL Server, SQLite, CockroachDB, MongoDB).
• Access to the database from the deployment environment (ports, credentials).
Build/Runtime prerequisites:Documentation
License: Apache License 2.0
Updated 7/30/2025