Back to the catalog

prisma-client-api

Prisma Client API reference covering model queries, filters, operators, and client methods. Use when writing database queries, using CRUD op

Open source Repository Open in the app JSON README (API)

About

Prisma Client API reference covering model queries, filters, operators, and client methods. Use when writing database queries, using CRUD operations, filtering data, or configuring Prisma Client. Triggers on "prisma query", "findMany", "create", "update", "delete", "$transaction".

Details

Kind
Agent skills
Topic
Databases
Publisher
prisma
Origin
skillssh
Category
ferramentas
Stars
55
Forks
5
Open pull requests
1
Last push
2026-08-04T12:21:31Z
Repository state
ativo
License
MIT
Added
2026-08-30 15:21:04
Updated
2026-09-06 14:00:55
Origin id
prisma/skills/prisma-client-api

README

# Prisma Skills

A collection of skills for AI coding agents working with Prisma ORM. Skills are packaged instructions that extend agent capabilities for database development.

Skills follow the [Agent Skills](https://agentskills.io/) format and are compatible with `npx skills add`.

## Available Skills

### prisma-cli

Complete reference for current Prisma ORM CLI commands. For Prisma Compute app deployment, use `prisma-compute`.

**Use when:**
- Running Prisma ORM/database commands
- Setting up new projects (`prisma init`)
- Managing migrations and database schema
- Generating Prisma Client

**Commands covered:**
- `init`, `generate`, `dev` (local Prisma Postgres)
- `migrate dev`, `migrate deploy`, `migrate reset`
- `db push`, `db pull`, `db seed`, `db execute`
- `studio`, `mcp`

---

### prisma-upgrade-v7

Step-by-step migration guide from Prisma v6 to v7, covering all breaking changes.

**Use when:**
- Upgrading existing projects to Prisma 7
- Troubleshooting v7 compatibility issues
- Understanding what changed in v7

**Topics covered:**
- ESM-first module configuration plus CommonJS fallback
- Driver adapter requirements
- New `prisma.config.ts` file
- Manual environment variable loading
- Generated client entrypoints (`client`, `browser`, `models`, `enums`)
- `Prisma.validator` to `satisfies` migration
- Removed features (middleware, metrics, CLI flags)
- Special handling for Accelerate users

---

### prisma-mongodb-upgrade

Decision and migration guide for MongoDB projects on Prisma v6, which have no path to Prisma 7.

**Use when:**
- A MongoDB project asks about upgrading Prisma versions
- Evaluating a move from Prisma v6 to Prisma Next
- Preventing an impossible "upgrade MongoDB to v7" plan

**Topics covered:**
- The version landscape (v6 terminal for MongoDB; v7 has no connector; Prisma Next is the successor path)
- Stay-on-v6 vs migrate-now decision table with no-go signals
- Schema/contract, client API, and migrations mapping between v6 and Prisma Next
- No-data-moves cutover verification checklist

---

### prisma-client-api

Comprehensive Prisma Client API reference.

**Use when:**
- Writing Prisma Client queries
- Understanding query options (select, include, where)
- Working with transactions
- Using raw SQL queries

**Topics covered:**
- PrismaClient constructor and configuration
- CRUD operations (findMany, create, update, delete)
- Query options (select, include, omit, orderBy, pagination)
- Filter operators and conditions
- Transactions ($transaction)
- Raw queries ($queryRaw, $executeRaw)
- Client methods ($connect, $disconnect, $extends)

---

### prisma-driver-adapter-implementation

Implementation guide for Prisma SQL driver adapter development.

**Use when:**
- Implementing a new SQL driver adapter
- Modifying `SqlDriverAdapter` or `Transaction` behavior
- Wiring migration-aware adapter factories
- Debugging adapter type mapping or transaction issues

**Topics covered:**
- Required adapter interfaces and contracts
- Transaction lifecycle protocol (including nested transactions)
- `SqlQuery` argument mapping and `SqlResultSet` mapping
- `ColumnTypeEnum` mapping strategy
- Error conversion to `DriverAdapterError` / `MappedError`
- Unit and E2E verification checklist

---

### prisma-database-setup

Guides for configuring Prisma with different database providers.

**Use when:**
- Setting up a new project with a specific database
- Connecting to PostgreSQL, MySQL, SQLite, MongoDB, etc.
- Troubleshooting connection issues
- Configuring connection strings

**Databases covered:**
- PostgreSQL & Prisma Postgres
- MySQL / MariaDB
- SQLite
- MongoDB
- SQL Server
- CockroachDB

---

### prisma-postgres

Prisma Postgres workflows across Console, `create-db`, Management API, and SDK integrations.

**Use when:**
- Setting up and managing Prisma Postgres in Prisma Console
- Creating instant databases with `npx create-db`
- Integrating programmatic provisioning with Management API
- Building typed API integrations using `@prisma/management-api-sdk`
- Handling auth, regions, claim flow, and connection details

**Workflows covered:**
- `npx create-db@latest`
- `npx create-db@latest create --help`
- `npx create-db@latest regions --help`
- Programmatic `create-db` usage (`create()` and `regions()`)
- Console operations (`https://console.prisma.io`)
- Management API (`https://api.prisma.io/v1`)
- Management API SDK (`@prisma/management-api-sdk`)

---

### prisma-compute

Prisma Compute deployment and hosting workflows centered on the Prisma Platform CLI, with `create-prisma` covered as the new-project scaffold path, plus framework readiness, SDK automation, and operational debugging.

**Use when:**
- Creating a new Prisma app with optional Compute deploy
- Deploying or redeploying an existing app to Prisma Compute
- Checking framework deploy readiness for Hono, Elysia, Next.js, TanStack Start, Astro, Nuxt, Svelte, Nest, Turborepo, or custom/prebuilt artifacts
- Managing Compute app logs, deployments, environment variables, branches, and domains
- Building programmatic Compute integrations with SDK/API tooling

**Workflows covered:**
- `@prisma/cli app build/run/deploy`
- Generated `compute:deploy` scripts
- `create-prisma --deploy` for new project scaffolds
- Framework-specific build output requirements
- `@prisma/compute-sdk` and Management API App/Deployment concepts
- Troubleshooting auth, env, build, deploy, log, and port issues

## Installation

Install all skills:

```bash
npx skills add prisma/skills
```

Or install specific skills:

```bash
npx skills add prisma/skills --skill prisma-cli
npx skills add prisma/skills --skill prisma-upgrade-v7
npx skills add prisma/skills --skill prisma-mongodb-upgrade
npx skills add prisma/skills --skill prisma-client-api
npx skills add prisma/skills --skill prisma-driver-adapter-implementation
npx skills add prisma/skills --skill prisma-database-setup
npx skills add prisma/skills --skill prisma-postgres
npx skills add prisma/skills --skill prisma-compute
```

List available skills:

```bash
npx skills add prisma/skills --list
```

List installed skills:

```bash
npx skills list
```

## Usage

Skills are automatically available once installed. The agent will use them when relevant tasks are detected.

**Examples:**
```
Help me run Prisma migrations in production
```
```
Upgrade my project from Prisma 6 to Prisma 7
```
```
How do I use transactions in Prisma?
```

## Skill Structure

Each skill contains:
- `SKILL.md` - Main instructions with YAML frontmatter (name, description, metadata)
- `references/` (optional) - Individual reference files with detailed explanations and code examples

## Prisma Version

The ORM-focused skills target **Prisma ORM 7.6.x**.

The `prisma-compute` skill tracks the active Prisma Compute launch flow and instructs agents to verify the current Prisma Platform CLI and `create-prisma` command surfaces before acting.

If you're upgrading from Prisma 6, use the `prisma-upgrade-v7` skill for migration-specific guidance.

## Contributing

See [AGENTS.md](./AGENTS.md) for guidelines on creating and modifying skills.

## License

MIT

More