Db Stats

Description

Show database statistics and recent analysis summaries. Execute the following steps: 1. Check database file: ```bash ls -lh ./data/summaries.db ``` 2. Show total records and basic stats: ```bash sqlite3 ./data/summaries.db " SELECT COUNT(*) AS total_summaries, MIN(timestamp) AS first_analysis, MAX(timestamp) AS last_analysis, ROUND(SUM(cost_usd), 4) AS total_cost_usd FROM summaries;" ``` 3. Show status distribution: ```bash sqlite3 -h

Installation

Installs to ~/.claude/commands/olegiv-logwatch-ai-go-db-stats.md

Restart Claude Code, or start a new session, for it to be picked up.