Ralph Status Dashboard Skill

Display project status and offer to continue autonomous development if tasks remain.

WORKFLOW

Step 1: Detect Platform

# Detect operating system
if [[ "$OSTYPE" == "msys" ]] || [[ "$OSTYPE" == "win32" ]] || [[ -n "$WINDIR" ]]; then
    PLATFORM="windows"
else
    PLATFORM="unix"
fi

Step 2: Check Prerequisites

Unix:

sqlite3 --version 2>/dev/null || echo "SQLite not found"

Windows:

sqlite3 --version 2>$null
if (-not $?) { Write-Host "SQLite not found" }

If SQLite not available:

SQLite is required. Install it:
- Windows: winget install SQLite.SQLite
- macOS: brew install sqlite3
- Linux: sudo apt install sqlite3

Step 3: Locate Database

# Check for ralph.db
if [[ -f "ralph.db" ]]; then
    echo "Database found"
else
    echo "Database not found"
fi

If not found:

Ralph database not found.
Run /ralph-new to create a new project, or
Run /ralph-enhance to add features to an existing project.

Step 4: Query Database Status

Get task counts:

PLANNED=$(sqlite3 ralph.db "SELECT COUNT(*) FROM tasks WHERE status='planned';")
IN_PROGRESS=$(sqlite3 ralph.db "SELECT COUNT(*) FROM tasks WHERE status='in-progress';")
COMPLETED=$(sqlite3 ralph.db "SELECT COUNT(*) FROM tasks WHERE status='completed';")
FAILED=$(sqlite3 ralph.db "SELECT COUNT(*) FROM tasks WHERE status='failed';")
TOTAL=$((PLANNED + IN_PROGRESS + COMPLETED + FAILED))

Get current work:

sqlite3 ralph.db "SELECT task_id, name, started_at FROM tasks WHERE status='in-progress';"

Get next up:

sqlite3 ralph.db "SELECT task_id, name, priority FROM tasks WHERE status='planned' ORDER BY priority, created_at LIMIT 5;"

Get recent activity:

sqlite3 ralph.db "SELECT datetime(created_at, 'localtime'), task_id, outcome FROM iterations ORDER BY created_at DESC LIMIT 10;"

Get blockers (3+ failures):

sqlite3 ralph.db "SELECT t.task_id, t.name, t.iteration_count FROM tasks t WHERE t.status='failed' OR t.iteration_count >= 3;"

Step 5: Display Dashboard

╔══════════════════════════════════════════════════════════════════╗
║                     RALPH PROJECT STATUS                          ║
║                     [Project Name]                                 ║
╠══════════════════════════════════════════════════════════════════╣

TASK SUMMARY
────────────────────────────────────────────────────────────────────
  ● In Progress:  [N]
  ○ Planned:      [N]
  ✓ Completed:    [N]
  ✗ Failed:       [N]
  ─────────────────
    Total:        [N]

PROGRESS
────────────────────────────────────────────────────────────────────
  [████████████████████░░░░░░░░░░] [XX]% Complete

  Iterations: [N] total | [N] success | [N] failed
  Success Rate: [XX]%

CURRENTLY WORKING ON
────────────────────────────────────────────────────────────────────
  🔄 [US-XXX]: [Task name]
     Started: [timestamp] | Iterations: [N]

NEXT UP
────────────────────────────────────────────────────────────────────
  1. [US-XXX]: [Task name]    Priority: [N]
  2. [US-XXX]: [Task name]    Priority: [N]

BLOCKERS (if any)
────────────────────────────────────────────────────────────────────
  ⚠️  [US-XXX]: [Task name] - Failed [N] times

╚══════════════════════════════════════════════════════════════════╝

Step 6: Offer Options

If there are pending or in-progress tasks, ask:

Tasks remaining: [N] planned, [N] in-progress

Would you like to:
A) Continue development (run Ralph Loop automatically)
B) View web dashboard (Kanban board)
C) Exit (status only)

Use AskUserQuestion tool for this.

Step 7: Handle User Choice

If A) Continue development:

Automatically start the Ralph Loop inline:

WHILE there are pending tasks:
    1. Get next task from database
    2. Mark as in-progress
    3. Implement the task
    4. Run Playwright tests
    5. If pass: mark complete, commit
    6. If fail: log learnings, increment failure count
    7. Continue to next task
END WHILE

When complete, output:

<promise>COMPLETE</promise>

If B) View web dashboard:

Generate dashboard data and start HTTP server:

Unix:

# Generate dashboard JSON
./scripts/ralph-db.sh dashboard

# Start HTTP server (runs in background)
echo "Starting HTTP server on port 8080..."
python3 -m http.server 8080 &
SERVER_PID=$!

echo ""
echo "═══════════════════════════════════════════════════════"
echo "  Dashboard running at: http://localhost:8080/dashboard.html"
echo "  Press Ctrl+C to stop the server"
echo "═══════════════════════════════════════════════════════"

Windows:

# Generate dashboard JSON
.\scripts\ralph-db.ps1 dashboard

# Start HTTP server
Write-Host ""
Write-Host "Starting HTTP server on port 8080..."
Write-Host ""
Write-Host "═══════════════════════════════════════════════════════"
Write-Host "  Dashboard running at: http://localhost:8080/dashboard.html"
Write-Host "  Press Ctrl+C to stop the server"
Write-Host "═══════════════════════════════════════════════════════"
python -m http.server 8080

After starting the server, open http://localhost:8080/dashboard.html in the browser.

If C) Exit: Just show status, no further action.

Step 8: If All Complete

If all tasks are completed:

🎉 ALL TASKS COMPLETE!

Summary:
- Total tasks: [N]
- Completed: [N]
- Failed: [N]
- Success rate: [XX]%

Final verification recommended:
- Run full test suite
- Review git log
- Check for any cleanup needed

Output:

<promise>COMPLETE</promise>

CROSS-PLATFORM COMMANDS

Action	Windows (PowerShell)	Unix (Bash)
Check file exists	Test-Path "file"	[[ -f file ]]
Run SQLite	sqlite3 ralph.db "query"	sqlite3 ralph.db "query"
Run dashboard script	.\scripts\ralph-db.ps1 dashboard	./scripts/ralph-db.sh dashboard
Count in variable	$count = sqlite3 ...	COUNT=$(sqlite3 ...)

QUICK COMMANDS REFERENCE

# View CLI status
./scripts/ralph-db.sh status      # Unix
.\scripts\ralph-db.ps1 status     # Windows

# List all tasks
./scripts/ralph-db.sh list

# List by status
./scripts/ralph-db.sh list planned
./scripts/ralph-db.sh list failed

# View recent activity
./scripts/ralph-db.sh log

# Generate web dashboard
./scripts/ralph-db.sh dashboard

WEB DASHBOARD FEATURES

The dashboard.html provides:

• 4-column Kanban board: Planned → In Progress → Done → Failed
• Auto-refresh every 5 seconds
• Manual refresh button
• Light/Dark mode toggle
• Progress bar and statistics
• Task cards with details