Skip to content

peterfei/ai-agent-team / .claude/skills/thread-manager

thread-manager

Flagged

FileKindSize
.claude/.threads/current-context.mdmarkdown648 B
.gitignoreother76 B
.npmignoreother138 B
CHANGELOG.mdmarkdown1.1 KB
README.mdmarkdown4.7 KB
SKILL.mdskill md1.7 KB
USAGE_GUIDE.mdmarkdown6.7 KB
docs/clt-aliases.mdmarkdown2.2 KB
find-module.jsscript166 B
jest.config.jsscript1.1 KB
models/Xenova/all-MiniLM-L6-v2/config.jsonconfig650 B
models/Xenova/all-MiniLM-L6-v2/onnx/model_quantized.onnxother21.9 MB
models/Xenova/all-MiniLM-L6-v2/special_tokens_map.jsonconfig125 B
models/Xenova/all-MiniLM-L6-v2/tokenizer.jsonconfig695.0 KB
models/Xenova/all-MiniLM-L6-v2/tokenizer_config.jsonconfig366 B
package-lock.jsonmanifest406.8 KB
package.jsonmanifest1.1 KB
scripts/download-model.jsscript1.7 KB
scripts/migrate-embeddings.tsscript3.4 KB
src/core/embedding-service.tsscript4.3 KB
src/core/thread-manager.tsscript14.3 KB
src/core/vector-search-engine.tsscript1.2 KB
src/core/vector-utils.tsscript1.0 KB
src/database/db.tsscript4.5 KB
src/database/file-changes-dao.tsscript2.8 KB
src/database/index.tsscript121 B
src/database/messages-dao.tsscript5.1 KB
src/database/threads-dao.tsscript6.4 KB
src/git/git-integration.tsscript5.6 KB
src/index.tsscript257 B
src/server.tsscript6.1 KB
src/tools/add-message.tsscript1.5 KB
src/tools/create-thread.tsscript1.3 KB
src/tools/delete-thread.tsscript925 B
src/tools/get-current-thread.tsscript2.6 KB
src/tools/get-thread.tsscript1.2 KB
src/tools/list-threads.tsscript1.2 KB
src/tools/search-messages.tsscript4.4 KB
src/tools/switch-thread.tsscript1.4 KB
src/tools/track-file-change.tsscript1.7 KB
src/tools/update-thread.tsscript1.2 KB
src/types/index.tsscript2.6 KB
test-add-message.jsscript2.3 KB
test-output-format.jsscript546 B
tests/integration/file-tracker.test.tsscript3.3 KB
tests/integration/mcp-tools.test.tsscript5.4 KB
tests/integration/search-messages.test.tsscript5.8 KB
tests/unit/__mocks__/embedding-service.tsscript1.3 KB
tests/unit/database.test.tsscript1.6 KB
tests/unit/file-changes-dao.test.tsscript3.6 KB
tests/unit/git-integration.test.tsscript4.9 KB
tests/unit/messages-dao.test.tsscript3.9 KB
tests/unit/thread-manager.test.tsscript9.2 KB
tests/unit/threads-dao.test.tsscript6.0 KB
tests/unit/vector-search.test.tsscript3.7 KB
tsconfig.jsonconfig464 B

src/database/messages-dao.ts

View on GitHub
import { Database } from 'better-sqlite3';
import { v4 as uuidv4 } from 'uuid';
import { Message } from '../types';
import { DatabaseManager } from './db';
import { IEmbeddingService } from '../core/embedding-service';
import { serializeEmbedding, deserializeEmbedding } from '../core/vector-utils';
import { VectorSearchEngine, SearchResult } from '../core/vector-search-engine';

export class MessagesDAO {
  private dbManager: DatabaseManager;
  private embeddingService: IEmbeddingService;
  private searchEngine: VectorSearchEngine;

  constructor(dbManager: DatabaseManager, embeddingService: IEmbeddingService) {
    this.dbManager = dbManager;
    this.embeddingService = embeddingService;
    this.searchEngine = new VectorSearchEngine();
  }

  private get db(): Database {
    return this.dbManager.getDatabase();
  }

  public async create(input: Partial<Message> & { threadId: string, role: string, content: string }): Promise<Message> {
    const id = input.id || uuidv4();
    const now = input.timestamp || new Date();

    // Generate embedding (Async)
    let embedding: number[] | undefined;
    let embeddingBlob: Buffer | null = null;
    let embeddingModel: string | null = null;
    let embeddingGeneratedAt: number | null = null;

    try {
      embedding = await this.embeddingService.embed(input.content);
      if (embedding) {
        embeddingBlob = serializeEmbedding(embedding);
        const modelInfo = this.embeddingService.getModelInfo();
        embeddingModel = modelInfo.name;
        embeddingGeneratedAt = Date.now();
      }
    } catch (e) {
      console.error('Failed to generate embedding:', e);
      // Proceed without embedding
    }
    
    const message: Message = {
      id,
      threadId: input.threadId,
      role: input.role as any,
      content: input.content,
      timestamp: now,
      metadata: input.metadata || {},
      embedding
    };

    const stmt = this.db.prepare(`
      INSERT INTO messages (
        id, thread_id, role, content, timestamp, metadata,
        embedding_blob, embedding_model, embedding_generated_at
      ) VALUES (
        ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
    `);

    stmt.run(
      message.id,
      message.threadId,
      message.role,
      message.content,
      message.timestamp.getTime(),
      JSON.stringify(message.metadata || {}),
      embeddingBlob,
      embeddingModel,
      embeddingGeneratedAt
    );

    // Update thread message count
    this.updateThreadMessageCount(message.threadId);

    return message;
  }

  public findByThreadId(threadId: string, options?: { limit?: number, offset?: number }): Message[] {
    const { limit = 50, offset = 0 } = options || {};
    
    const stmt = this.db.prepare(`
      SELECT * FROM messages 
      WHERE thread_id = ? 
      ORDER BY timestamp DESC
      LIMIT ? OFFSET ?
    `);

    const rows = stmt.all(threadId, limit, offset) as any[];

    return rows.map(this.mapRowToMessage);
  }

  /**
   * Semantically search for messages
   */
  public async searchSimilar(
    query: string,
    options: {
      threadId?: string;
      topK?: number;
      minScore?: number;
    } = {}
  ): Promise<Array<Message & { score: number }>> {
    const { threadId, topK = 10, minScore = 0.5 } = options;

    // 1. Generate query vector
    const queryVector = await this.embeddingService.embed(query);

    // 2. Load candidate messages (all messages with embeddings)
    // Optimization: Filter by threadId in SQL if provided to reduce memory usage
    let sql = 'SELECT * FROM messages WHERE embedding_blob IS NOT NULL';
    const params: any[] = [];

    if (threadId) {
      sql += ' AND thread_id = ?';
      params.push(threadId);
    }

    const rows = this.db.prepare(sql).all(...params) as any[];

    // 3. Build corpus
    const corpus = rows.map(row => ({
      id: row.id,
      vector: deserializeEmbedding(row.embedding_blob),
      payload: this.mapRowToMessage(row)
    }));

    // 4. Perform vector search
    const results = this.searchEngine.search(queryVector, corpus, {
      topK,
      minScore
    });

    // 5. Map results
    return results.map(result => ({
      ...result.payload!,
      score: result.score
    }));
  }
  
  public deleteByThreadId(threadId: string): void {
      const stmt = this.db.prepare('DELETE FROM messages WHERE thread_id = ?');
      stmt.run(threadId);
  }

  private updateThreadMessageCount(threadId: string): void {
      const countStmt = this.db.prepare('SELECT COUNT(*) as count FROM messages WHERE thread_id = ?');
      const result = countStmt.get(threadId) as { count: number };
      
      const updateStmt = this.db.prepare('UPDATE threads SET message_count = ? WHERE id = ?');
      updateStmt.run(result.count, threadId);
  }

  private mapRowToMessage(row: any): Message {
    const message: Message = {
      id: row.id,
      threadId: row.thread_id,
      role: row.role,
      content: row.content,
      timestamp: new Date(row.timestamp),
      metadata: JSON.parse(row.metadata || '{}')
    };

    if (row.embedding_blob) {
      message.embedding = deserializeEmbedding(row.embedding_blob);
    }

    return message;
  }
}
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall