Skip to content

NarixHine/uni-chem / .agents/skills/prisma-cli

prisma-cli

Verified

Prisma ORM CLI commands reference covering init, generate, migrate, db, dev, studio, validate, format, debug, and mcp. Use for ORM/database CLI workflows, not Prisma Compute app deployment. For Prisma Compute, `@prisma/cli app deploy`, `compute:deploy`, `create-prisma --deploy`, apps, deployments, logs, or domains, use the `prisma-compute` skill instead. Triggers on "prisma init", "prisma generate", "prisma migrate", "prisma db", "prisma studio", "prisma mcp".

FileKindSize
SKILL.mdskill md7.6 KB
references/db-execute.mdmarkdown1.9 KB
references/db-pull.mdmarkdown4.1 KB
references/db-push.mdmarkdown3.1 KB
references/db-seed.mdmarkdown3.5 KB
references/debug.mdmarkdown1.1 KB
references/dev.mdmarkdown2.8 KB
references/format.mdmarkdown1.1 KB
references/generate.mdmarkdown3.7 KB
references/init.mdmarkdown3.5 KB
references/mcp.mdmarkdown1.1 KB
references/migrate-deploy.mdmarkdown2.8 KB
references/migrate-dev.mdmarkdown3.4 KB
references/migrate-diff.mdmarkdown2.2 KB
references/migrate-reset.mdmarkdown1.6 KB
references/migrate-resolve.mdmarkdown1.8 KB
references/migrate-status.mdmarkdown1.6 KB
references/studio.mdmarkdown2.9 KB
references/validate.mdmarkdown964 B

references/dev.md

View on GitHub
# prisma dev

Starts a local Prisma Postgres database for development. Provides a PostgreSQL-compatible database that runs entirely on your machine.

## Command

```bash
prisma dev [options]
```

## What It Does

- Starts a local PostgreSQL-compatible database
- Runs in your terminal or as a background process
- Perfect for development and testing
- Easy migration to Prisma Postgres cloud in production

## Options

| Option             | Description                           | Default   |
| ------------------ | ------------------------------------- | --------- |
| `--name` / `-n`    | Name for the database instance        | `default` |
| `--port` / `-p`    | HTTP server port                      | `51213`   |
| `--db-port` / `-P` | Database server port                  | `51214`   |
| `--shadow-db-port` | Shadow database port (for migrations) | `51215`   |
| `--detach` / `-d`  | Run in background                     | `false`   |
| `--debug`          | Enable debug logging                  | `false`   |

## Examples

### Start local database

```bash
prisma dev
```

Interactive mode with keyboard shortcuts:

- `q` - Quit
- `h` - Show HTTP URL
- `t` - Show TCP URLs

### Named instance

```bash
prisma dev --name myproject
```

Useful for multiple projects.

### Background mode

```bash
prisma dev --detach
```

Frees your terminal for other commands.

### Custom ports

```bash
prisma dev --port 5000 --db-port 5432
```

## Instance Management

### List all instances

```bash
prisma dev ls
```

Shows all local Prisma Postgres instances with status.

### Start existing instance

```bash
prisma dev start myproject
```

Starts a previously created instance in background.

### Stop instance

```bash
prisma dev stop myproject
```

### Stop with glob pattern

```bash
prisma dev stop "myproject*"
```

Stops all instances matching pattern.

### Remove instance

```bash
prisma dev rm myproject
```

Removes instance data from filesystem.

### Force remove (stops first)

```bash
prisma dev rm myproject --force
```

## Configuration

Configure your `prisma.config.ts` to use local Prisma Postgres:

```typescript
import 'dotenv/config'
import { defineConfig, env } from 'prisma/config'

export default defineConfig({
    schema: 'prisma/schema.prisma',
    migrations: {
        path: 'prisma/migrations',
    },
    datasource: {
        // Local Prisma Postgres URL (from prisma dev output)
        url: env('DATABASE_URL'),
    },
})
```

## Workflow

1. Start local database:

    ```bash
    prisma dev
    ```

2. In another terminal, run migrations:

    ```bash
    prisma migrate dev
    ```

3. Generate client:

    ```bash
    prisma generate
    ```

4. Run your application

## Production Migration

When ready for production, switch to Prisma Postgres cloud:

```bash
prisma init --db
```

Update your `DATABASE_URL` to the cloud connection string.
finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the workStars: 322kUpdated Claude CodeCodexVerifiedInstall
systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixesStars: 322kUpdated Claude CodeCodexVerifiedInstall
test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation codeStars: 322kUpdated Claude CodeCodexVerifiedInstall
skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.Stars: 198kUpdated Claude CodeCodexVerifiedInstall