search-prompts

Search across all your Claude Code conversation history for: $ARGUMENTS

Multi-Source Prompt Search

Search through your Claude Code conversation history using multiple methods to find relevant prompts, discussions, and insights.

Database Search (SQLite)

First, search the main conversation database:

# Search user messages for keywords
sqlite3 ~/.claude/__store.db "
SELECT 
    b.session_id,
    datetime(b.timestamp, 'unixepoch') as date,
    substr(u.message, 1, 100) as preview
FROM user_messages u 
JOIN base_messages b ON u.uuid = b.uuid 
WHERE u.message LIKE '%$ARGUMENTS%' 
ORDER BY b.timestamp DESC 
LIMIT 10;"

Project History Search (JSON)

Search through project-specific conversation history:

import json
import re
from datetime import datetime

def search_project_history(search_term):
    try:
        with open('/Users/YOUR_USERNAME/.claude.json', 'r') as f:
            data = json.load(f)
        
        results = []
        if 'projects' in data:
            for project_path, project_data in data['projects'].items():
                if 'history' in project_data:
                    for i, item in enumerate(project_data['history']):
                        text = ""
                        if isinstance(item, dict) and 'display' in item:
                            text = item['display']
                        elif isinstance(item, str):
                            text = item
                        
                        if search_term.lower() in text.lower():
                            results.append({
                                'project': project_path.split('/')[-1],
                                'index': i,
                                'text': text[:200] + "..." if len(text) > 200 else text,
                                'relevance': text.lower().count(search_term.lower())
                            })
        
        # Sort by relevance
        results.sort(key=lambda x: x['relevance'], reverse=True)
        return results[:15]  # Top 15 results
    
    except Exception as e:
        return [{'error': f"Search failed: {e}"}]

# Execute search
results = search_project_history("$ARGUMENTS")
for result in results:
    if 'error' in result:
        print(f"❌ {result['error']}")
    else:
        print(f"📁 Project: {result['project']}")
        print(f"🔢 Relevance: {result['relevance']} matches")
        print(f"💬 Text: {result['text']}")
        print("---")