Review Game Log Skill

This skill activates when you need to review a saved MTG game simulation log.

When This Skill Activates

Automatically engage when:

• User asks to review a game log by ID
• User wants to analyze a saved game
• User provides a game ID (UUID format) and asks about game events

Workflow

1. Identify Game ID

The game ID is a UUID like a1b2c3d4-e5f6-7890-abcd-ef1234567890. Users may provide:

• Full UUID
• Partial UUID (first 8 characters)
• Reference like "the game I just saved"

2. Fetch Game Data

Use the Bash tool to invoke the Tauri command via the app's API or read directly from the SQLite database:

# Option 1: Query SQLite directly (preferred for Claude)
sqlite3 ~/.local/share/com.scrye3.app/scrye3.db "
SELECT
  s.game_id,
  s.player1_name,
  s.player2_name,
  s.winner,
  s.final_turn,
  s.total_log_entries,
  s.saved_at
FROM saved_games s
WHERE s.game_id LIKE 'GAME_ID_PREFIX%'
LIMIT 1;
"

# Then fetch logs
sqlite3 ~/.local/share/com.scrye3.app/scrye3.db "
SELECT
  timestamp,
  event_type,
  turn_number,
  phase,
  step,
  message,
  details
FROM game_logs
WHERE game_id = 'FULL_GAME_ID'
ORDER BY timestamp ASC, id ASC;
"

3. Format Output

Present the game summary and key events:

## Game Summary
- **Game ID**: {game_id}
- **Players**: {player1_name} vs {player2_name}
- **Result**: {winner} won on turn {final_turn}
- **Total Events**: {total_log_entries}
- **Saved**: {saved_at}

## Key Events

| Turn | Phase | Event | Details |
|------|-------|-------|---------|
| 1 | beginning | Game started | ... |
| 1 | precombat_main | Land played | Forest |
| ... | ... | ... | ... |

4. Analysis

After presenting the log, offer to:

• Summarize the game flow
• Identify key turning points
• Analyze player decisions
• Find specific events (combat, spells cast, etc.)

Constraints

• Only access games that have been explicitly saved
• Game logs are read-only (cannot modify saved games)
• Database path may vary by platform:
  • Linux: ~/.local/share/com.scrye3.app/scrye3.db
  • macOS: ~/Library/Application Support/com.scrye3.app/scrye3.db
  • Windows: %APPDATA%/com.scrye3.app/scrye3.db

Examples

User: "Review game a1b2c3d4"

Claude:

1. Query database for game starting with a1b2c3d4
2. Present summary and log table
3. Offer analysis options

User: "What happened in turn 5 of that game?"

Claude:

1. Filter logs for turn_number = 5
2. Present relevant events
3. Explain the game state