/session-names - Query Auto-Generated Session Names

Query and display auto-generated session names from the MoE classification system. Use these names to rename sessions via Claude Code's /rename command or session picker.

System Prompt

EXECUTION DIRECTIVE: When the user invokes this command, execute this query:

sqlite3 -header -column ~/PROJECTS/.coditect-data/context-storage/sessions.db \
  "SELECT session_name, content_type, theme,
          printf('%.0f%%', confidence * 100) as conf,
          message_count as msgs,
          datetime(created_at) as created
   FROM session_names
   ORDER BY created_at DESC
   LIMIT 20"

Then display the results in a formatted table with instructions for applying names.

Usage

/session-names              # List recent 20 session names
/session-names --all        # List all session names
/session-names --today      # Today's sessions only
/session-names --type backend  # Filter by content type
/session-names --search auth   # Search in session names

Arguments

Option	Description
--all	Show all session names (no limit)
--today	Filter to today's sessions
--type <type>	Filter by content type (backend, frontend, security, etc.)
--search <term>	Search in session names and themes
--json	Output as JSON

Example Output

session_name                              content_type  theme                 conf  msgs  created
----------------------------------------  ------------  --------------------  ----  ----  -------------------
2026-01-23T14:30-security-auth-oauth2     security      auth-oauth2           92%   47    2026-01-23 14:30:00
2026-01-23T12:15-backend-migration-users  backend       migration-users       95%   23    2026-01-23 12:15:00
2026-01-23T10:00-frontend-dashboard       frontend      dashboard-component   88%   31    2026-01-23 10:00:00

To apply a name:
  1. Run: claude --resume
  2. Select the session
  3. Press 'R' to rename
  4. Paste the session_name from above

Workflow

1. End session - Hook auto-generates name
2. Query names - /session-names to see suggestions
3. Resume session - claude --resume
4. Apply name - Press R, paste suggested name

Database Schema

CREATE TABLE session_names (
    session_id TEXT PRIMARY KEY,
    session_name TEXT NOT NULL,
    content_type TEXT,
    theme TEXT,
    confidence REAL,
    message_count INTEGER,
    created_at TEXT,
    applied_at TEXT  -- Set when user applies the name
);

Content Types

Type	Keywords Detected
backend	api, database, model, migration, django, sql
frontend	react, vue, component, css, tailwind, typescript
devops	docker, kubernetes, deploy, pipeline, terraform
security	auth, oauth, jwt, permission, encrypt
testing	test, spec, pytest, jest, coverage
docs	readme, documentation, markdown, adr
debug	bug, fix, error, debug, issue
refactor	refactor, cleanup, reorganize, optimize
feature	feature, implement, add, create, build
config	config, settings, env, setup

Related Commands

Command	Purpose
/cx	Capture context (triggers post-processing)
/cxq --sessions	Query all sessions from context
/export	Export current session

Success Output

✅ Found 15 auto-named sessions

To apply: claude --resume → select → R → paste name

Files

File	Purpose
~/PROJECTS/.coditect-data/context-storage/sessions.db	SQLite database
~/PROJECTS/.coditect-data/context-storage/session-names.json	JSON log backup
~/.coditect/hooks/auto-session-namer.py	Name generation hook

---

Version: 1.0.0 Created: 2026-01-23 Author: CODITECT Team