← topics
---
title: MC ER Diagram
updated: 2026-06-11
---
MC v2 Entity-Relationship Diagram
The ER diagram is available as an SVG: `projects/agent-mission-control/docs/mc-er-diagram.svg`
Tables
mc_agents
| agent_id | TEXT PK | Agent identifier (e.g. "main") |
| name | TEXT | Display name from openclaw.json |
| model | TEXT | Primary model |
| workspace | TEXT | Workspace path |
| status | TEXT | running / idle / stalled / unknown |
| last_seen | TEXT | ISO datetime of last activity |
| task_count | INTEGER | Total assistant messages |
| tokens_in | INTEGER | Total input tokens |
| tokens_out | INTEGER | Total output tokens |
| cost_usd | REAL | Total cost in USD |
| max_concurrent | INTEGER | Max concurrent subagents |
| raw_config | TEXT | Full agent config JSON |
| created_dttm | TEXT | Auto-set |
| updated_dttm | TEXT | Auto-set |
mc_sessions
| id | TEXT PK | Session UUID |
| agent_id | TEXT FK | Link to mc_agents |
| status | TEXT | active / idle / stalled |
| model | TEXT | Model used during session |
| started_at | TEXT | ISO datetime |
| last_seen | TEXT | ISO datetime of last message |
| task_count | INTEGER | Assistant message count |
| tokens_in | INTEGER | Total input + cache tokens |
| tokens_out | INTEGER | Total output tokens |
| cost_usd | REAL | Total cost |
| raw_data | TEXT | JSON blob with file metadata |
mc_events
| id | INTEGER PK | Auto-increment |
| event_id | TEXT | Event identifier |
| time | TEXT | ISO datetime |
| agent_id | TEXT FK | Link to mc_agents |
| level | TEXT | error / warn / success / info |
| message | TEXT | Event description |
| handoff_to | TEXT | Subagent target |
| project | TEXT | Project reference |
| created_dttm | TEXT | Auto-set |
mc_scan_log
| id | INTEGER PK | Auto-increment |
| scan_dttm | TEXT | Scan execution time |
| files_processed | INTEGER | Files read |
| sessions_found | INTEGER | Sessions extracted |
| errors | INTEGER | Parse errors |
| duration_ms | INTEGER | Total wall time |
Indexes
- `idx_mc_events_time` — `mc_events(time)` — For date-range event queries
- `idx_mc_events_agent` — `mc_events(agent_id)` — For per-agent event filtering
- `idx_mc_sessions_agent` — `mc_sessions(agent_id)` — For per-agent session queries
- `idx_mc_sessions_last_seen` — `mc_sessions(last_seen)` — For active/idle sorting
Relationships
```
mc_agents 1 ──── mc_sessions
mc_agents 1 ──── mc_events
mc_scan_log references mc_agents
```
Data Sources
- mc_agents: populated from `~/.openclaw/openclaw.json` agents list
- mc_sessions: populated from `~/.openclaw/agents//sessions/.jsonl` files
- mc_events: generated during mc_sessions parsing (message, tool, error events)
- mc_scan_log: written on each mc-sync.py run