메뉴
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.