Skip to content
Automation
Skill

/db-migrate

Create and apply a Prisma migration safely against the remote (tunneled) PostgreSQL. Use for schema changes - "create a migration", "apply migrations", "add a column/table".

From plugin
jobpilot
6931 skills2 agents2 MCP
Install
$ npx -y skills add suxrobGM/jobpilot --skill db-migrate --agent claude-code

How it fires

How this skill gets triggered: by you, by Claude, or both.

  • Fires itselfAuto-invocation. Claude auto-loads it when your prompt matches the work.Auto-invocation is when the right skill fires by itself at the right moment, driven by a FLOW.md router and a hook, instead of you invoking it by name. It is the difference between a skill being installed and a skill actually getting used.Read the full definition →
  • You can call itInvoke it directly when you want it.
  • Slash command/db-migrate

Context preview

The summary Claude sees to decide when to auto-load this skill.

Create and apply a Prisma migration safely against the remote (tunneled) PostgreSQL. Use for schema changes - "create a migration", "apply migrations", "add a column/table".

SKILL.md

db-migrate.SKILL.md
name: db-migrate
description: Create and apply a Prisma migration safely against the remote (tunneled) PostgreSQL. Use for schema changes - "create a migration", "apply migrations", "add a column/table".

DB migrate

The database is remote; `DATABASE_URL` points at the SSH tunnel's local port (5433). All commands are `bun --cwd=apps/api run …`.

1. Confirm the tunnel is up (`bunx prisma migrate status` from `apps/api`). If it isn't, ask the user to run `bun run db:tunnel` in a separate terminal - don't start it yourself. 2. Edit the schema - split by domain under `apps/api/prisma/schema/*.prisma`. 3. `db:migrate` - creates the migration SQL only (`--create-only`), never applies. 4. Read the generated SQL and confirm it matches intent. Prisma turns renames into drop + add - hand-edit to `ALTER` when data must survive. 5. `db:migrate:apply`, then `db:generate`.

Never run `db:reset` without explicit user confirmation - it wipes the remote database.

Ships withjobpilot

An AI agent that applies to jobs for you, on the Claude or Codex subscription you already have.

Get the whole plugin

Other skills on jobpilot.