midjourney-cc-skill: Command for Claude Code

Reflect

Analyze iteration logs and extract/update patterns in the knowledge base.

Updated Role

This command now serves as the deep analysis layer. Lightweight pattern extraction and markdown regeneration happen automatically when sessions close (see "Session Lifecycle & Automatic Reflection" in rules/learn-reflection.md). Pattern confidence graduates automatically based on times_tested and success_rate thresholds — no manual review gate.

/reflect adds:

• Contrastive analysis across sessions (success vs failure comparison)
• Cross-session pattern discovery
• Contradiction resolution (when patterns conflict, produce conditional rules)
• Force full knowledge base regeneration

Instructions

1. Verify database access. Run SELECT COUNT(*) FROM sessions via sqlite-simple MCP. If the query fails, tell the user: "Database not available. Run claude mcp add sqlite-simple -- npx @anthropic-ai/sqlite-simple-mcp mydatabase.db then restart Claude Code." Do not proceed without database access.

2. Gather recent data. Query the database for sessions and iterations that haven't been reflected on yet (or all data if this is the first reflection):

   SELECT s.id, s.intent, s.status, s.final_successful_prompt, s.reference_analysis,
     i.iteration_number, i.prompt, i.parameters, i.result_assessment, i.user_feedback,
     i.gap_analysis, i.success, i.what_worked, i.what_failed, i.action_type, i.parent_image
   FROM sessions s
   JOIN iterations i ON s.id = i.session_id
   WHERE s.reflected = 0
   ORDER BY s.created_at DESC, i.iteration_number ASC
   

3. Analyze successful iterations. Look for recurring themes in what_worked:

   SELECT what_worked FROM iterations WHERE success = 1 AND what_worked IS NOT NULL
   

   Parse the JSON arrays and count frequency of each technique across sessions.

4. Analyze failures. Look for recurring themes in what_failed and gap_analysis:

   SELECT what_failed, gap_analysis FROM iterations WHERE (what_failed IS NOT NULL OR gap_analysis IS NOT NULL)