session-summary - SKILL.md Agent Skill

name: session-summary description: "Query and summarize Drifox software session history. Supports querying sessions within specified date range, auto-parsing conversation content and generating summaries. Trigger scenarios: (1) User asks to query history sessions, (2) Summarize daily conversations, (3) Analyze session records, (4) Export conversation history."

Session Summary Skill

Query Drifox session database and generate conversation summaries.

Database Info

Database: .drifox/sessions.db (relative to Drifox install directory)
Type: SQLite 3
Table: sessions (session_id, canvas_id, title, messages, message_count, project, created_at, updated_at)

Path Resolution

Paths are auto-detected based on script location:

Drifox/
├── .drifox/sessions.db    # Database
└── _internal/app/skills/
    └── session-summary/
        └── scripts/
            ├── query_sessions.py      # Python script
            └── query_sessions.ps1     # PowerShell script

Usage

Python Script

# Query yesterday (default)
pushd C:\Windows && py -3.12 <skill-path>/scripts/query_sessions.py && popd

# Query specific date
pushd C:\Windows && py -3.12 <skill-path>/scripts/query_sessions.py --date 2026-05-07 && popd

# List only (no message content)
pushd C:\Windows && py -3.12 <skill-path>/scripts/query_sessions.py --list && popd

# Query specific session
pushd C:\Windows && py -3.12 <skill-path>/scripts/query_sessions.py --session <session_id> && popd

PowerShell Script

.\query_sessions.ps1 -Date "2026-05-07"
.\query_sessions.ps1 -Date "2026-05-07" -ListOnly
.\query_sessions.ps1 -SessionId "abc123..."

Output Format

Each session includes:

Title, project, message count, created time
Session ID (first 32 chars)
Message content summary (first 10 messages)

Notes

Windows: Execute Python in C:\Windows directory to avoid DLL conflicts
messages field is JSON format
Date format: YYYY-MM-DD
Paths are relative to script location, no hardcoded paths