/summaries - Conversation Summary Query

Query conversation summaries extracted from session history. Summaries provide quick overviews of conversations and are automatically extracted from session files.

Usage

# List recent summaries
/summaries

# Search summaries
/summaries "authentication"
/summaries "database migration"

# Filter by time
/summaries --today
/summaries --week
/summaries --since 2025-12-01

# Filter by session
/summaries --session abc123

# Get specific summary
/summaries --leaf-uuid "62a64845-97ca..."

# Full-text search
/summaries --search "error handling"

System Prompt

System Prompt

⚠️ EXECUTION DIRECTIVE: When the user invokes this command, you MUST:

1. IMMEDIATELY execute - no questions, no explanations first
2. ALWAYS show full output from script/tool execution
3. ALWAYS provide summary after execution completes

DO NOT:

• Say "I don't need to take action" - you ALWAYS execute when invoked
• Ask for confirmation unless requires_confirmation: true in frontmatter
• Skip execution even if it seems redundant - run it anyway

The user invoking the command IS the confirmation.

---

You are querying the CODITECT conversation summaries from the context database.

Database: context-storage/sessions.db (ADR-118 Tier 3) (SQLite with FTS5)

Execute the summary query:

python3 scripts/context-db.py --summaries $ARGS

Note: Summaries are extracted during /cx or --index-comprehensive operations. If no summaries exist, run /cx first.

Quick Reference

Basic Operations

Command	Description
/summaries	List recent summaries (default: 20)
/summaries "query"	Search summary text (FTS5)
/summaries --today	Summaries from today
/summaries --week	Summaries from last 7 days

Filtering

Command	Description
/summaries --session ID	Summaries for specific session
/summaries --leaf-uuid UUID	Get specific summary by UUID
/summaries --since DATE	Summaries since date (YYYY-MM-DD)
/summaries --until DATE	Summaries until date

Output Options

Command	Description
/summaries --limit N	Show N summaries (default: 20)
/summaries --full	Show full summary text (no truncation)
/summaries --json	Output as JSON
/summaries --count	Just show count

Analysis

Command	Description
/summaries --stats	Summary statistics
/summaries --search "term"	Full-text search with FTS5

Examples

List Recent Summaries

# Default: 20 most recent
/summaries

# Last 50 summaries
/summaries --limit 50

# Today's summaries
/summaries --today

# This week's summaries
/summaries --week

Search Summaries

# Simple search
/summaries "authentication"
/summaries "error handling"

# Full-text search (FTS5)
/summaries --search "database OR migration"
/summaries --search "api AND webhook"

# Search with time filter
/summaries "bug fix" --week
/summaries "deployment" --since 2025-12-01

Session-Specific Summaries

# Get summaries for a specific session
/summaries --session abc123

# Get specific summary by leaf UUID
/summaries --leaf-uuid "62a64845-97ca-4e3b-8f2a-1234567890ab"

Date Filtering

# Summaries since specific date
/summaries --since 2025-12-01

# Summaries until specific date
/summaries --until 2025-12-15

# Summaries from specific date range
/summaries --since 2025-12-01 --until 2025-12-15

# Recent summaries
/summaries --today
/summaries --week

Output Formatting

# Full summary text (no truncation)
/summaries --full

# JSON output for programmatic use
/summaries --json

# Just count
/summaries --count
/summaries "authentication" --count

# Statistics
/summaries --stats

Combined Filters

# Search summaries from this week
/summaries --search "deployment" --week

# Session summaries with full text
/summaries --session abc123 --full

# Search with date range
/summaries "API" --since 2025-12-01 --until 2025-12-15

Options

Query Options

Option	Description
QUERY	Search term (FTS5 full-text search on summary text)
--search QUERY	Explicit FTS5 search (same as positional query)
--leaf-uuid UUID	Get specific summary by leaf UUID

Filtering Options

Option	Description
--session ID	Filter by session ID (partial match)
--today	Summaries from today
--week	Summaries from last 7 days
--since DATE	Summaries since DATE (YYYY-MM-DD)
--until DATE	Summaries until DATE (YYYY-MM-DD)

Output Options

Option	Description
--limit N	Show N summaries (default: 20)
--full	Show full summary text (no truncation)
--json	Output as JSON
--count	Just show count
--stats	Show summary statistics

Information

Option	Description
-h, --help	Show help message

FTS5 Search Syntax

The --search option (or positional query) uses SQLite FTS5:

word1 word2       Both words (AND)
word1 OR word2    Either word
"exact phrase"    Exact match
word*             Prefix match
-word             Exclude word

Database Schema

Summaries are stored in two tables:

summaries table

• id - Auto-increment primary key
• entry_id - Foreign key to entries table
• summary_text - The summary content
• leaf_uuid - UUID of the leaf message being summarized

summaries_fts table

• FTS5 virtual table for full-text search on summary_text

How Summaries Are Created

Summaries are automatically extracted during:

1. Session indexing: /cx command processes JSONL session files
2. Comprehensive indexing: --index-comprehensive extracts all entry types
3. Summary entries: Messages with entry_type=summary are indexed

Workflow Integration

# At session start: Check recent summaries for context
/summaries --week

# During work: Search for relevant past summaries
/summaries "topic you're working on"

# At session end: Preserve new summaries
/export && /cx

Related Commands

• /cxq - Full context query with messages, decisions, patterns, errors
• /cxq --entry-type summary - Alternative way to query summaries via comprehensive entries
• /cx - Extract and index session data (creates summaries)
• /export - Export current session before indexing

Differences from /cxq

Feature	/summaries	/cxq --entry-type summary
Focus	Summary-specific queries	General comprehensive entries
Table	summaries + summaries_fts	comprehensive_entries + comprehensive_entries_fts
Speed	Faster (dedicated table)	Slower (filters larger table)
Features	Summary-specific (leaf_uuid)	General entry features
Use Case	Quick summary overview	Comprehensive entry analysis

---

Action Policy

<default_behavior> This command queries and displays without making changes. Provides:

• Summary list from session history
• Full-text search results
• Filtered summaries by time/session
• Statistics on summary data

Read-only operation on context database. </default_behavior>

After execution, verify: - Query executed successfully - Results displayed - Filters applied correctly - Count/stats accurate

Success Output

When summary query completes:

✅ COMMAND COMPLETE: /summaries
Query: <search-term or "recent">
Results: N summaries
Filter: <time-filter if applied>
Database: context-storage/sessions.db (ADR-118 Tier 3)

Completion Checklist

Before marking complete:

• Database connected
• Query executed
• Results formatted
• Output displayed

Failure Indicators

This command has FAILED if:

• ❌ Database not found
• ❌ No summaries indexed
• ❌ Query syntax error
• ❌ No results displayed

When NOT to Use

Do NOT use when:

• Need full context entries (use /cxq)
• Need to index new sessions (use /cx)
• No sessions have been indexed

Anti-Patterns (Avoid)

Anti-Pattern	Problem	Solution
Skip /cx first	No summaries exist	Run /cx to index
Vague search	Too many results	Use specific terms
Ignore --full	Truncated output	Use --full for complete text

Principles

This command embodies:

• #9 Based on Facts - Queries actual session data
• #6 Clear, Understandable - FTS5 search syntax

Full Standard: CODITECT-STANDARD-AUTOMATION.md

---

Script: scripts/context-db.py --summaries Database: context-storage/sessions.db (ADR-118 Tier 3) Version: 1.0.0 Last Updated: 2025-12-23 Related Commands: /cx, /cxq, /export Related ADRs: ADR-020 (Context Extraction), ADR-025 (Comprehensive Entry Schema)