Set up Prisma with an AI agent

name: prisma
description: Build type-safe TypeScript and Node.js apps with Prisma ORM and Prisma Postgres. Covers the core Prisma CLI workflow (init, migrate, generate, studio), connecting to a Prisma Postgres database, and the remote Prisma MCP server for managing databases, Compute deployments, and Object Storage from AI tools.
license: Apache-2.0
compatibility: ">=0.1.0"
metadata:
  homepage: https://www.prisma.io
  documentation: https://www.prisma.io/docs
  vendor: Prisma
  version: "1.0.0"
allowed-tools:
  - Bash
  - Read
  - Edit
  - Write

Prisma

Use this skill to model and query data with Prisma ORM, connect to Prisma Postgres databases, and manage Prisma Compute apps and Object Storage buckets through the Prisma MCP server.

Prisma changes frequently. Before implementing Prisma features, check the changelog at https://www.prisma.io/changelog.md and the documentation at https://www.prisma.io/docs. Do not rely solely on training data for Prisma APIs, configuration, or conventions — these can change between versions.

Core workflow (Prisma CLI)

Run the Prisma CLI with npx prisma. The typical workflow for a new project:

1. Set up a TypeScript project with ESM. Initialize the project, install dependencies, and enable ESM before scaffolding Prisma:

   npm init -y
   npm install typescript tsx @types/node --save-dev
   npx tsc --init
   npm install prisma@7.9.1 @types/pg --save-dev
   npm install @prisma/client@7.9.1 @prisma/adapter-pg pg dotenv
   

   Set "module": "ESNext" (along with "moduleResolution": "bundler", "target": "ES2023", "strict": true, "esModuleInterop": true, and "ignoreDeprecations": "6.0") in tsconfig.json, and add "type": "module" to package.json.

2. Initialize Prisma ORM. Creates the prisma/ directory with a schema.prisma file, a .env file, and a prisma.config.ts file:

   npx prisma init --output ../generated/prisma
   

3. Create a Prisma Postgres database. Ask the user for approval before provisioning a hosted Prisma Postgres database — npx create-db creates a cloud resource. After approval, run it and copy the postgres://... connection string into DATABASE_URL in your .env file:

   npx create-db
   

4. Create and apply a migration after defining models in prisma/schema.prisma. This creates the database tables based on your schema:

   npx prisma migrate dev --name init
   

5. Generate Prisma Client for type-safe database access:

   npx prisma generate
   

6. Explore your data in Prisma Studio, a visual database editor:

   npx prisma studio
   

Example schema

generator client {
  provider = "prisma-client"
  output   = "../generated/prisma"
}

datasource db {
  provider = "postgresql"
}

model User {
  id    Int     @id @default(autoincrement())
  email String  @unique
  name  String?
  posts Post[]
}

model Post {
  id        Int     @id @default(autoincrement())
  title     String
  content   String?
  published Boolean @default(false)
  author    User    @relation(fields: [authorId], references: [id])
  authorId  Int
}

Remote MCP server

Prisma runs a remote Model-Context-Protocol (MCP) server that lets AI tools manage Prisma Postgres databases, Prisma Compute deployments, and Object Storage over Streamable HTTP. It authenticates with Prisma Console on first use so your AI tool can access the workspace you choose.

Endpoint: https://mcp.prisma.io/mcp

Standard MCP configuration:

{
  "mcpServers": {
    "Prisma": {
      "url": "https://mcp.prisma.io/mcp"
    }
  }
}

The server can manage databases and connection strings, list and restore automated backups, run SQL queries, inspect schemas, and manage Object Storage buckets and keys. Compute tools list apps and builds, read runtime logs, manage existing deployments, and set environment variables. The Composer topology tool shows how services connect and returns Console links; it does not check live app health. The MCP server does not build or upload source code.

The search_prisma_documentation tool answers Prisma questions with citations from the official docs. Full tool list: https://www.prisma.io/docs/ai/mcp-tools.md

Installable agent skills

Prisma publishes deeper, task-specific skills in the Agent Skills format (https://agentskills.io/). Installing them into a project gives you version-accurate command and API knowledge without re-reading the docs:

npx skills add prisma/skills          # Prisma CLI, Prisma Client, Prisma Postgres, Prisma Compute, upgrade guides
npx prisma@latest skills sync         # Prisma 8 and Prisma Composer: copies the skills that ship inside the installed @prisma/orm-* and @prisma/composer packages

The catalog of skills and what each one teaches: https://www.prisma.io/docs/ai/tools/skills.md

Where to read the docs

• Docs index (machine-readable): https://www.prisma.io/docs/llms.txt
• Full docs corpus: https://www.prisma.io/docs/llms-full.txt
• Any docs page as markdown: append .md to the URL (e.g. https://www.prisma.io/docs/getting-started.md)
• Changelog (machine-readable): https://www.prisma.io/changelog.md