菜单
PostgreSQL custom-format backup for image-scoring-backend via Backup-Postgres.ps1. Use when the user runs /backup-db, asks for a local pg_dump, database backup, or Postgres dump. Default workflow keeps at most 3 dumps in backups/postgres and mirrors the latest copy to D:\Dropbox\Photos\Scoring (also capped at 3 files).
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Bump semver + promote CHANGELOG Unreleased via compiled harness. Use for /release, version bumps, or tagging. Runs scripts/agent_skills/release_bump.py; LLM only when Unreleased is ambiguous. Never commit/push unless the user asks.
Vexlum Scoring MCP — compact search+dispatch on is-be-mcp / is-be-live and gallery is-ui-mcp / is-ui-live.
Choose CLI tools and safe patterns before repo work. Install checklist, bounded search/read commands, and confirmation gates. Use when navigating the codebase, running shell commands, or setting up agent tooling on Windows, WSL2, or macOS.
Inspect JSON, YAML, and API responses with jq, yq, dasel, curl, and httpie. Use for package.json, config.json, and backend health checks. Never output secrets or full credential-bearing config.
Backend build, test, lint, and verify workflows via WSL pytest, ruff, doctor, and docker compose. Use before claiming work complete or opening a PR. Do not invent ad hoc Python commands outside documented venvs.
Choose and run the right search tool: rg vs grep vs ast-grep vs fd vs fzf. Bounded repo navigation with ripgrep, fd, tree, bat, and structural search. Use when finding symbols, files, syntax patterns, or deciding which CLI search to use before reading or editing code.
| name | backup-db |
| description | PostgreSQL custom-format backup for image-scoring-backend via Backup-Postgres.ps1. Use when the user runs /backup-db, asks for a local pg_dump, database backup, or Postgres dump. Default workflow keeps at most 3 dumps in backups/postgres and mirrors the latest copy to D:\Dropbox\Photos\Scoring (also capped at 3 files). |
Run scripts/powershell/Backup-Postgres.ps1 from repo root so the dump uses merged config (config.json + environment.json via Python when available). Report primary dump path, mirror path (if used), sizes, exit code, and prune counts.
Always pass mirror arguments and count-based retention so both locations keep at most 3 newest image_scoring_*.dump files:
powershell -NoProfile -ExecutionPolicy Bypass -File .\scripts\powershell\Backup-Postgres.ps1 `
-MaxBackups 3 `
-MirrorDir "D:\Dropbox\Photos\Scoring" `
-MirrorMaxBackups 3 `
-RetentionDays 0 `
-MirrorRetentionDays 0
backups\postgres under repo root (default).D:\Dropbox\Photos\Scoring — created if missing.LastWriteTime).If the user explicitly wants no Dropbox copy:
powershell -NoProfile -ExecutionPolicy Bypass -File .\scripts\powershell\Backup-Postgres.ps1 `
-MaxBackups 3 `
-RetentionDays 0
-BackupDir <path> — primary dump folder (default: backups\postgres under repo root).-MaxBackups <n> — keep newest n dumps in primary folder; 0 skips count prune.-RetentionDays <n> — age-based prune in primary folder (used only when -MaxBackups 0); 0 skips.-MirrorMaxBackups <n> — keep newest n mirror dumps; 0 skips count prune.-MirrorRetentionDays <n> — age-based mirror prune (used only when -MirrorMaxBackups 0); 0 skips.-ConfigPath <path> — non-default config.json..dump exists and is non-empty..dump exists, non-empty, and prune step completed without fatal errors.image_scoring_*.dump files in each retention-enabled folder.Restoring into a DB that already has data may require scripts/python/postgres_sequence_repair.py (see repo docs / CHANGELOG).
Cursor slash command .cursor/commands/backup-db.md and Claude .claude/commands/backup-db.md should match this workflow.