add-api-route
Add a new JobPilot API route or module the standard way - contracts schema, controller, service, response schema, optional web hook. Use for "add an endpoint",…
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".
$ npx -y skills add suxrobGM/jobpilot --skill db-migrate --agent claude-codeHow it fires
How this skill gets triggered: by you, by Claude, or both.
/db-migrateContext 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".
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".
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.
An AI agent that applies to jobs for you, on the Claude or Codex subscription you already have.
Repo: suxrobGM/jobpilot
Add a new JobPilot API route or module the standard way - contracts schema, controller, service, response schema, optional web hook. Use for "add an endpoint",…
Review and clean up the given file(s)/folder(s)/module(s): rate organization, find dead code, duplication, coupling, over-engineering, deep nesting, structural…
Add knip to a TypeScript project and use it to remove dead exports, collapse pass-through barrels, and narrow every export to what another file actually…
Bump the unified JobPilot version (host + plugin), update the changelog, commit, and tag a new release
Rebuild the .NET terminal host, restart it, and wait for /healthz. Use after any C# change under apps/terminal, or when asked to "restart the terminal host".
Migrate a React @tanstack/react-form codebase from the prop-drilled `useForm` + erased-form-type pattern to the official `createFormHook` composition API…