analyze-usage - Analyze AI coding assistant usage patterns
Loads AI coding assistant logs from Claude Code, Codex, and Cursor into DuckDB for SQL querying and pattern analysis.
Tags
Updated: 2026-09-17Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Load assistant logs into DuckDB
- Execute SQL queries on logs
- Search conversation content and reasoning traces
- Calculate token usage and API costs
- Display database schema and example queries
Inputs
- Claude Code, Codex, and Cursor log files
- SQL queries
- Search terms and filters
- Canonical agent schema SQL file
Outputs
- DuckDB database file
- SQL query result tables
- Conversation and trace search results
- Usage summary and cost reports
Requirements
- DuckDB
- Bash shell environment
- uv package manager