# List all executions
smithers db executions

# List executions for a specific workflow
smithers db executions --source my-workflow.tsx

# View execution details
smithers db execution <execution-id>

# View current state
smithers db state

# View state for specific execution
smithers db state --execution <execution-id>

# View database statistics
smithers db stats

# Using SQLite directly
sqlite3 .smithers/my-workflow/db.sqlite "SELECT * FROM phases ORDER BY created_at"

sqlite3 .smithers/my-workflow/db.sqlite "SELECT * FROM steps ORDER BY created_at"

sqlite3 .smithers/my-workflow/db.sqlite "SELECT * FROM tasks WHERE status = 'running'"

sqlite3 .smithers/my-workflow/db.sqlite "SELECT * FROM state ORDER BY updated_at DESC"

~/.claude/projects/<project-path>/sessions/

// Log session IDs in your workflow
<Claude
  onFinished={(result) => {
    console.log("Session:", result.sessionId);
  }}
>

ls -la ~/.claude/projects/*/sessions/ | grep <session-id>

# Check for stuck tasks
sqlite3 .smithers/my-workflow/db.sqlite "SELECT * FROM tasks WHERE status = 'running'"

# Check last state change
sqlite3 .smithers/my-workflow/db.sqlite "SELECT * FROM state ORDER BY updated_at DESC LIMIT 5"

# Check step status
sqlite3 .smithers/my-workflow/db.sqlite "SELECT * FROM steps WHERE phase_id = '<phase-id>'"

const incomplete = await db.execution.findIncomplete();
if (incomplete) {
  executionId = incomplete.id;
}