Method getSkillEmbeddings

packages/memos-core/src/storage/sqlite.ts:1826–1848

(scope: "self" | "public" | "mix", currentOwner: string)

  }

  getSkillEmbeddings(scope: "self" | "public" | "mix", currentOwner: string): Array<{ skillId: string; vector: number[] }> {
    let sql = `SELECT se.skill_id, se.vector, se.dimensions
       FROM skill_embeddings se
       JOIN skills s ON s.id = se.skill_id
       WHERE s.status = 'active'`;
    const params: any[] = [];

    if (scope === "self") {
      sql += ` AND s.owner = ?`;
      params.push(currentOwner);
    } else if (scope === "public") {
      sql += ` AND s.visibility = 'public'`;
    } else {
      sql += ` AND (s.owner = ? OR s.visibility = 'public')`;
      params.push(currentOwner);
    }

    const rows = this.db.prepare(sql).all(...params) as Array<{ skill_id: string; vector: Buffer; dimensions: number }>;
    return rows.map((r) => ({
      skillId: r.skill_id,
      vector: Array.from(new Float32Array(r.vector.buffer, r.vector.byteOffset, r.dimensions)),
    }));
  }

  skillFtsSearch(query: string, limit: number, scope: "self" | "public" | "mix", currentOwner: string): Array<{ skillId: string; score: number }> {
    const sanitized = sanitizeFtsQuery(query);