tomevault-io Claude Pulse — Projects
Show all tracked projects or details for a specific one.
Instructions
If the user provided a project name in $ARGUMENTS, show details for that project. Otherwise list all projects.
List all projects
sqlite3 ~/.claude-pulse/tracker.db "
SELECT
s.project,
COUNT(DISTINCT s.id) as sessions,
COALESCE(SUM(s.duration_seconds), 0) / 60 as total_minutes,
MAX(s.started_at) as last_active,
(SELECT COUNT(*) FROM insights i WHERE i.project = s.project) as insights,
(SELECT content FROM insights i WHERE i.project = s.project AND i.type = 'progress' ORDER BY i.created_at DESC LIMIT 1) as last_progress
FROM sessions s
GROUP BY s.project
ORDER BY last_active DESC;
"
Details for a specific project
sqlite3 ~/.claude-pulse/tracker.db "
SELECT type, content, created_at FROM insights
WHERE project = '<project-name>'
ORDER BY created_at DESC LIMIT 10;
"
Format the output as a clean table. For each project show:
- Project name
- Total sessions and time spent
- Last active date (as relative time like "2h ago" or "3 days ago")
- Number of insights
- Most recent progress entry (if any)
If showing a specific project, show the last 10 insights as a timeline.
Source: Clemens865/Claude-Pulse — distributed by TomeVault.