1  -- Migration 133: Add weekly Claude Code session cleanup cron job
 2  --
 3  -- Automated (sdk-cli) sessions accumulate thousands of JSONL files in
 4  -- ~/.claude/projects/ and overwhelm the Claude Code session picker.
 5  -- This job deletes non-interactive sessions weekly.
 6  
 7  INSERT INTO ops.cron_jobs (
 8    task_key, name, description, handler_type, handler_value,
 9    interval_value, interval_unit, enabled
10  ) VALUES (
11    'cleanupClaudeSessions',
12    '9.10 Cleanup Claude Sessions',
13    'Delete non-interactive (sdk-cli) Claude Code session files from ~/.claude/projects/ to keep the session picker usable. Keeps all interactive (claude-vscode) sessions.',
14    'command',
15    'node src/cron/cleanup-claude-sessions.js',
16    1,
17    'weeks',
18    true
19  ) ON CONFLICT (task_key) DO NOTHING;