cc-query

cc-query

SQL REPL for querying Claude Code session data using DuckDB.

Installation

As a Claude Code Plugin

1. Add the marketplace:

   /plugin marketplace add dannycoates/cc-query
   

2. Install the plugin:

   /plugin install cc-query@dannycoates-cc-query
   

The plugin automatically installs the ccq binary on first session start.

Standalone CLI Access (Plugin Install)

When installed as a plugin, the CLI binary is inside a versioned cache directory that isn't on your shell's PATH. To use cc-query directly from the terminal, create a wrapper script that resolves the current version via glob:

#!/usr/bin/env bash
exec ~/.claude/plugins/cache/cc-query-dev/cc-query/*/bin/cc-query "$@"

Save this as cc-query somewhere on your PATH (e.g. ~/bin/cc-query or ~/.local/bin/cc-query) and make it executable:

chmod +x ~/bin/cc-query

The glob matches whichever version directory is present, so the wrapper survives plugin updates without changes.

Usage

# Query all projects
cc-query

# Query a specific project
cc-query ~/code/my-project

# Filter by session ID prefix
cc-query -s abc123 .

# Pipe queries (like psql)
echo "SELECT count(*) FROM messages;" | cc-query .

Available Views

• messages - All messages with parsed fields
• user_messages - User messages only
• assistant_messages - Assistant responses only
• human_messages - Human-typed messages (no tool results)
• tool_uses - Tool invocations from assistant messages
• tool_results - Tool results with duration and error status
• token_usage - Token consumption per message
• bash_commands - Bash command details
• file_operations - File read/write/edit operations
• raw_messages - Unparsed JSONL data

REPL Commands

• .help - Show tables and example queries
• .schema - Show table schema
• .quit - Exit

Skills

The plugin includes three skills for session analysis:

/reflect

Query and analyze Claude Code session history. Use for:

• Token usage analysis
• Tool patterns across projects
• Finding user corrections/preferences
• Weekly summaries

See skills/reflect/SKILL.md for query reference.

/handoff

Create detailed handoff documents for work continuation. Produces:

• Task status and progress
• Files modified with change summaries
• Key conversation flow
• Actionable next steps

See skills/handoff/SKILL.md for output format.

/pickup

Resume work from a handoff document. Reads a handoff file and:

• Presents actionable options from Next Steps and incomplete Tasks
• Retrieves full content for key messages using get-content.sh
• Restores working context from Files of Interest

See skills/pickup/SKILL.md for workflow.

Example Questions

• Across all projects what bash commands return the most errors?
• Let's analyze the last session and identify how we might improve the CLAUDE.md file
• Give me a summary of what we worked on this past week
• Create a handoff document for this session
• /pickup (resume from most recent handoff)

License

MIT