# Run the script (loads data on first run, incremental updates after)
scripts/ai-coding-usage

# Show database schema and example queries
scripts/ai-coding-usage --schema

# Query your data
scripts/ai-coding-usage query "SELECT * FROM tool_summary"

# ILIKE search on conversation content (default)
scripts/ai-coding-usage search "memory"

# BM25 full-text search (covers content + thinking)
scripts/ai-coding-usage search "memory" --fts

# Search reasoning traces
scripts/ai-coding-usage search "memory" --thinking

# Search both content and thinking
scripts/ai-coding-usage search "memory" --all

# Filter by role, repo, time
scripts/ai-coding-usage search "refactor" --user --repo bertram-chat --since 7d

# Limit results
scripts/ai-coding-usage search "deploy" -n 20

-- Most used tools
SELECT * FROM tool_summary;

-- Daily usage (last 2 weeks)
SELECT * FROM daily_summary ORDER BY date DESC LIMIT 14;

-- Skill popularity
SELECT regexp_extract(context, '"skill":"([^"]+)"', 1) as skill, COUNT(*) as uses
FROM claude_tools WHERE tool_name = 'Skill'
GROUP BY skill ORDER BY uses DESC;

-- Peak coding hours
SELECT hour_of_day, SUM(interactions) as total
FROM peak_hours GROUP BY hour_of_day ORDER BY total DESC LIMIT 5;

-- Activity by repository (aggregates worktrees)
SELECT repo_name, SUM(interactions) as total, SUM(worktrees) as branches
FROM repo_activity GROUP BY repo_name ORDER BY total DESC LIMIT 10;

-- Turn durations
SELECT * FROM turn_durations ORDER BY duration_ms DESC LIMIT 10;

-- Session overview with summaries
SELECT session_id, repo_name, summary FROM session_overview
WHERE summary IS NOT NULL ORDER BY started_at DESC LIMIT 10;

-- API errors
SELECT * FROM api_errors ORDER BY timestamp DESC LIMIT 10;

-- PR links
SELECT * FROM pr_links;

-- Cost by repo
SELECT repo_name, ROUND(SUM(cost_usd), 2) as cost
FROM usage_with_cost
WHERE CAST(timestamp AS TIMESTAMP) >= CURRENT_DATE - INTERVAL 7 DAY
GROUP BY repo_name ORDER BY cost DESC;

-- Full cost summary by repo and model
SELECT * FROM cost_summary ORDER BY cost_usd DESC;