# Event log replay (sync backup databases)
./skraak replay events --db ./backup.duckdb --log ./skraak.duckdb.events.jsonl
./skraak replay events --db ./backup.duckdb --log ./events.jsonl --dry-run
./skraak replay events --db ./backup.duckdb --log ./events.jsonl --last 10

**Event Log:**
- `replay events` - Replay event log on backup database for synchronization

## Event Log
All mutating SQL operations (INSERT, UPDATE, DELETE) are automatically logged for backup synchronization.
**Event log location:** `<database>.events.jsonl`

**Features:**
- SQL-level capture for complete fidelity
- Only successful transactions logged (rollbacks discarded)
- Includes tool name, SQL, parameters, timestamp
**Replay on backup database:**
```bash
# Replay all events
./skraak replay events --db ./backup.duckdb --log ./skraak.duckdb.events.jsonl
# Preview without executing
./skraak replay events --db ./backup.duckdb --log ./events.jsonl --dry-run
# Replay last N events
./skraak replay events --db ./backup.duckdb --log ./events.jsonl --last 10
```
**Event format (JSONL):**
```json
{
  "id": "V1StGXR8_Z5jdHi6B-myT",
  "timestamp": "2026-02-18T14:30:22+13:00",
  "tool": "create_or_update_dataset",
  "queries": [{"sql": "INSERT INTO ...", "parameters": [...]}],
  "success": true,
  "duration_ms": 45
}
```

**Testing:**
- `db/tx_logger_test.go` — 123 unit tests, 75.9% coverage
- Pure function tests (isMutation, marshalParam, JSON marshaling)
- Integration tests with real DuckDB and file system
- Race detector verified