midjourney-cc-skill: Command for Claude Code

Research

Research community techniques for a specific Midjourney generation challenge. Usable standalone or mid-session.

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. Determine context — check for an active session:

   SELECT id, intent, total_iterations, approach_rationale FROM sessions WHERE status = 'active' LIMIT 1
   

   • Mid-session: The user hit a wall during iteration. Research focus comes from the gap analysis of recent failures.
   • Standalone: No active session. Research is exploratory — produce a brief for future sessions.

3. Parse research focus from user input ($ARGUMENTS). If empty and mid-session, derive focus from the last 3 iterations:

   SELECT iteration_number, what_failed, gap_analysis, prompt
   FROM iterations
   WHERE session_id = ?
   ORDER BY iteration_number DESC
   LIMIT 3
   

   Extract the recurring failure themes and use them as the research focus.

4. Check internal knowledge first — what do we already know about this topic?

   SELECT id, category, problem, solution, confidence, success_rate
   FROM patterns
   WHERE is_active = 1
     AND (problem LIKE '%' || ? || '%' OR solution LIKE '%' || ? || '%')
   ORDER BY confidence DESC
   

   SELECT keyword, intended_effect, effectiveness, notes
   FROM keyword_effectiveness
   WHERE intended_effect LIKE '%' || ? || '%'
   ORDER BY effectiveness DESC
   

   Note what's available internally so research can fill the gaps rather than duplicate.

5. Construct targeted search queries (pick 3-5 most relevant):

   1. Core technique: "midjourney v7" "{primary_concept}" prompt
   2. Reddit community: site:reddit.com/r/midjourney "{concept}" tips
   3. Failure-specific: "midjourney" "{hard_aspect}" how to
   4. Parameter-specific: "midjourney v7" --style raw "{concept}"
   5. Prompt examples: "midjourney prompt" "{concept}" example