Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx skills add suxrobGM/jobpilot --skill db-migrategit clone --depth 1 https://github.com/suxrobGM/jobpilotWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/skills/suxrobgm/jobpilot/db-migrate)<a href="https://agentmods.dev/skills/suxrobgm/jobpilot/db-migrate"><img src="https://agentmods.dev/badge/skills/suxrobgm/jobpilot/db-migrate/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/skills/suxrobgm/jobpilot/db-migrate"><img src="https://agentmods.dev/badge/skills/suxrobgm/jobpilot/db-migrate.svg" alt="Reviewed on agentmods" width="80" height="20"></a>- NVIDIA SkillSpector pass
What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00042 | $0.00541 |
| Opus 5.5 | $0.00017 | $0.00216 |
| Sonnet 5.5 | $0.00008 | $0.00108 |
| Haiku 4.5 | $0.00004 | $0.00054 |
Grade A, and why
db-migrate scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured today.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
What it actually says
DB migrate
The tunneled database (bun run db:tunnel, localhost:5433) is production. prisma migrate dev can demand a reset there, which wipes it, so never run it. All commands
are bun --cwd=apps/api run ….
- Edit the schema - split by domain under
apps/api/prisma/schema/*.prisma. - Restore a throwaway copy:
pg_dumpprod through the tunnel, restore it into a local PostgreSQL on another port (e.g. 5434), and pointDATABASE_URLat it for every step below until step 6. A local PostgreSQL and the tunnel both default to 5433 - checkdocker psfirst. db:diffprints the SQL from the database to the schema (read-only). Save it asapps/api/prisma/migrations/<yyyymmddhhmmss>_<name>/migration.sqland edit it: Prisma turns renames into drop + add - hand-edit toALTER ... RENAMEwhen data must survive. Data fixes that need TS logic go in a one-offapps/api/scripts/<name>.tswith a--dry-runreport.migrate deployapplies every pending migration at once, so a script can't run between two of them. When the migration needs the script's output, run the script first against the old schema, have it fill a staging table the migration joins on, and make the migrationRAISE EXCEPTIONbefore any change if rows are left unmapped (20261026070000_board_idsin git history). Partial unique indexes aren't in the Prisma schema;db:diffwon't emit them, so write them by hand.db:migrate:applyagainst the copy, run the data script, spot-check counts and samples, and run the app against the copy. Thendb:generate.- Ask the user before touching production.
- Production: fresh
pg_dumpbackup,db:migrate:applythrough the tunnel, the data script, then deploy the matching images back to back. Never leave code that accepts both shapes.
Never run db:reset without explicit user confirmation - it wipes the database it points at.
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- today Changed · +12 lines fd953321ecb3
- 1mo ago First seen · 20 lines · 42 tokens per session scan A a357c9145a1c
db-migrate is a skill published in the GitHub repository suxrobGM/jobpilot (102 stars, last pushed yesterday), licensed MIT. It adds 42 tokens to every session and 541 once invoked, about $0.0002 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.
Other skills, from other repositories
ecto-patterns
Use when a task touches Ecto, even a how-to question: schemas, changesets, validations, queries, preloads, Multi, migrations, constraints, money fields. Load it before writing Ecto code. Skip for Ash.
cloudflare-hyperdrive
Cloudflare Hyperdrive for Workers-to-database connections with pooling and caching. Use for PostgreSQL/MySQL, Drizzle/Prisma, or encountering pool errors, TLS issues, connection refused.
ecto-constraint-debug
Debug Ecto constraint violations - trace triggers, check migrations, find duplicate data. Use when seeing uniqueconstraint, foreignkeyconstraint, or checkconstraint errors.
postgresql
PostgreSQL schema design, query optimization, indexing, and administration. Use when writing schemas, queries, migrations, or mentions PostgreSQL, Postgres, JSONB, partitioning, RLS, CTEs, window functions, EXPLAIN ANALYZE, or connection pooling.
laravel-vector-search
Use when implementing semantic/vector search in Laravel 13 with PostgreSQL + pgvector.
pytest-databases
Auto-activate for pytestdatabases, Docker DB fixtures, PostgreSQL/pgvector/ParadeDB, MySQL/MariaDB, Oracle/SQL Server, CockroachDB, MongoDB, Redis/Valkey, BigQuery/Spanner, MinIO, or RustFS. Not for mocked DBs.