Skip to main content

sqlite_graphrag/commands/
recall.rs

1//! Handler for the `recall` CLI subcommand.
2
3use crate::cli::MemoryType;
4use crate::errors::AppError;
5use crate::graph::traverse_from_memories_with_hops;
6use crate::i18n::errors_msg;
7use crate::output::{self, JsonOutputFormat, RecallItem, RecallResponse};
8use crate::paths::AppPaths;
9use crate::storage::connection::open_ro;
10use crate::storage::entities;
11use crate::storage::memories;
12
13/// Arguments for the `recall` subcommand.
14///
15/// When `--namespace` is omitted the query runs against the `global` namespace,
16/// which is the default namespace used by `remember` when no `--namespace` flag
17/// is provided. Pass an explicit `--namespace` value to search a different
18/// isolated namespace.
19#[derive(clap::Args)]
20#[command(after_long_help = "EXAMPLES:\n  \
21    # Semantic search for top 5 matches\n  \
22    sqlite-graphrag recall \"authentication design\" --k 5\n\n  \
23    # Disable automatic graph expansion\n  \
24    sqlite-graphrag recall \"JWT tokens\" --k 3 --no-graph\n\n  \
25    # Limit graph traversal depth and minimum edge weight\n  \
26    sqlite-graphrag recall \"auth\" --k 5 --max-hops 2 --min-weight 0.3\n\n  \
27    # Filter by memory type\n  \
28    sqlite-graphrag recall \"deployment\" --type decision --k 10\n\n  \
29    # Cap results by distance threshold\n  \
30    sqlite-graphrag recall \"API design\" --k 5 --max-distance 0.8\n\n  \
31NOTES:\n  \
32    When --no-graph is active, graph traversal is skipped and every result has\n  \
33    source=\"direct\". The source field is therefore redundant with --no-graph and\n  \
34    may be ignored by callers in that mode.")]
35pub struct RecallArgs {
36    #[arg(
37        allow_hyphen_values = true,
38        required_unless_present = "print_schema",
39        help = "Search query string (semantic vector search via sqlite-vec)"
40    )]
41    /// Search query text.
42    pub query: Option<String>,
43    /// Maximum number of direct vector matches to return.
44    ///
45    /// Note: this flag controls only `direct_matches`. Graph traversal results
46    /// (`graph_matches`) are unbounded by default; use `--max-graph-results` to
47    /// cap them independently. The `results` field aggregates both lists.
48    /// Validated to the inclusive range `1..=4096` (the upper bound matches
49    /// `sqlite-vec`'s knn limit; out-of-range values are rejected at parse time).
50    #[arg(short = 'k', long, aliases = ["limit", "top-k"], default_value = "10", value_parser = crate::parsers::parse_k_range)]
51    pub k: usize,
52    /// Filter by memory.type. Note: distinct from graph entity_type
53    /// (project/tool/person/file/concept/incident/decision/memory/dashboard/issue_tracker/organization/location/date)
54    /// used in --entities-file.
55    #[arg(long, value_enum)]
56    pub r#type: Option<MemoryType>,
57    /// Namespace scope.
58    #[arg(long)]
59    pub namespace: Option<String>,
60    /// No graph.
61    #[arg(long)]
62    pub no_graph: bool,
63    /// Disable -k cap and return all direct matches without truncation.
64    ///
65    /// When set, the `-k`/`--k` flag is ignored for `direct_matches` and the
66    /// response includes every match above the distance threshold. Useful when
67    /// callers need the complete set rather than a top-N preview.
68    #[arg(long)]
69    pub precise: bool,
70    /// Max hops.
71    #[arg(long, default_value = "2")]
72    pub max_hops: u32,
73    /// Min weight.
74    #[arg(long, default_value = "0.3")]
75    pub min_weight: f64,
76    /// Cap the size of `graph_matches` to at most N entries.
77    ///
78    /// Defaults to unbounded (`None`) so existing pipelines see the same shape
79    /// as in v1.0.22 and earlier. Set this when a query touches a dense graph
80    /// neighbourhood and the caller only needs a top-N preview. Added in v1.0.23.
81    #[arg(long, value_name = "N")]
82    pub max_graph_results: Option<usize>,
83    /// Filter results by maximum distance. Results with distance greater than this value
84    /// are excluded. If all matches exceed this threshold, the command exits with code 4
85    /// (`not found`) per the documented public contract.
86    /// Default `1.0` disables the filter and preserves the top-k behavior.
87    #[arg(long, alias = "min-distance", default_value = "1.0")]
88    pub max_distance: f32,
89    /// Output format.
90    #[arg(long, value_enum, default_value_t = JsonOutputFormat::Json)]
91    pub format: JsonOutputFormat,
92    /// Path to the SQLite database file.
93    #[arg(long)]
94    pub db: Option<String>,
95    /// Accept `--json` as a no-op because output is already JSON by default.
96    #[arg(long, hide = true, help = "No-op; JSON is always emitted on stdout")]
97    pub json: bool,
98    /// Search across all namespaces instead of a single namespace.
99    ///
100    /// Cannot be combined with `--namespace`. When set, the query runs against
101    /// every namespace and results include a `namespace` field to identify origin.
102    #[arg(long, conflicts_with = "namespace")]
103    pub all_namespaces: bool,
104    /// G58 (v1.0.80): skip the live query embedding and use FTS5 BM25 +
105    /// LIKE prefix exclusively. Useful in CI/CD with tight OAuth quota and
106    /// in deterministic regression tests that need stable ranking.
107    #[arg(
108        long,
109        help = "Skip live query embedding; use FTS5 BM25 + LIKE prefix only"
110    )]
111    pub fallback_fts_only: bool,
112    /// Emit the JSON Schema for this command's stdout envelope and exit 0
113    /// without opening the database or embedding (agent-native R-AN-01).
114    #[arg(
115        long,
116        default_value_t = false,
117        help = "Print JSON Schema for recall output and exit"
118    )]
119    pub print_schema: bool,
120}
121
122/// Run.
123#[tracing::instrument(skip_all, level = "debug", name = "recall")]
124pub fn run(
125    args: RecallArgs,
126    llm_backend: crate::cli::LlmBackendChoice,
127    embedding_backend: crate::cli::EmbeddingBackendChoice,
128) -> Result<(), AppError> {
129    if args.print_schema {
130        return crate::print_schema::emit(crate::print_schema::SchemaId::Recall);
131    }
132    let start = std::time::Instant::now();
133    let _ = args.format;
134    let query = args.query.as_deref().unwrap_or("").to_string();
135    tracing::debug!(target: "recall", query = %query, k = args.k, "searching");
136
137    // G20: reject graph-specific flags when --no-graph is active
138    if args.no_graph {
139        if args.max_hops != 2 {
140            return Err(AppError::Validation(
141                "--max-hops has no effect with --no-graph; remove one".to_string(),
142            ));
143        }
144        if (args.min_weight - 0.3).abs() > f64::EPSILON {
145            return Err(AppError::Validation(
146                "--min-weight has no effect with --no-graph; remove one".to_string(),
147            ));
148        }
149    }
150
151    if query.trim().is_empty() {
152        return Err(AppError::Validation(crate::i18n::validation::empty_query()));
153    }
154    // Resolve the list of namespaces to search:
155    // - empty vec  => all namespaces (sentinel used by knn_search)
156    // - single vec => one namespace (default or --namespace value)
157    let namespaces: Vec<String> = if args.all_namespaces {
158        Vec::new()
159    } else {
160        vec![crate::namespace::resolve_namespace(
161            args.namespace.as_deref(),
162        )?]
163    };
164    // Single namespace string used for graph traversal and error messages.
165    let namespace_for_graph = namespaces
166        .first()
167        .cloned()
168        .unwrap_or_else(|| "global".to_string());
169    let paths = AppPaths::resolve(args.db.as_deref())?;
170
171    crate::storage::connection::ensure_db_ready(&paths)?;
172
173    output::emit_progress_i18n(
174        "Computing query embedding...",
175        "Calculando embedding da consulta...",
176    );
177    let conn = open_ro(&paths.db)?;
178    // G58 (v1.0.80): when the live embedding fails (timeout, OAuth contention,
179    // rate limit, missing CLI), fall back to FTS5 BM25 + LIKE prefix and
180    // surface the degradation through `vec_degraded` + `vec_error` + `warning`
181    // on the response envelope. The `--fallback-fts-only` flag forces the
182    // skip without even attempting the embedding subprocess.
183    // v1.0.84 (ADR-0042): tuple de 4 elementos. `backend_invoked` carrega
184    // o discriminador do backend que efetivamente invocou o LLM (ou `None`
185    // when the caller asked for `--fallback-fts-only` and never invoked the subprocess).
186    let (embedding, vec_degraded, vec_error, backend_invoked) = if args.fallback_fts_only {
187        (
188            None,
189            true,
190            Some("fallback_fts_only requested".to_string()),
191            None,
192        )
193    } else {
194        // v1.0.82 (GAP-003): forward --llm-backend to embed_with_fallback.
195        // v1.0.84 (ADR-0042): extrai o backend que efetivamente invocou o
196        // LLM to populate `backend_invoked` in the response envelope.
197        // v1.0.85 (G58 / ADR-0043): retry determinístico em OAuthQuota
198        // (codex ↔ claude) e backoff 750ms em SlotExhausted antes de
199        // accept degradation to pure FTS5.
200        match crate::embedder::try_embed_query_with_embedding_choice(
201            &paths.models,
202            &query,
203            embedding_backend,
204            llm_backend,
205        ) {
206            Ok((v, backend)) => (Some(v), false, None, Some(backend.as_str())),
207            Err(reason) => {
208                let msg = reason.to_string();
209                tracing::warn!(target: "recall", fallback_reason = %msg, reason_code = %reason.reason_code(), "live embedding failed; falling back to FTS5");
210                (None, true, Some(msg), None)
211            }
212        }
213    };
214
215    let memory_type_str = args.r#type.map(|t| t.as_str());
216    // When --precise is set, lift the -k cap so every match is returned; the
217    // max_distance filter below will trim irrelevant results instead.
218    let effective_k = if args.precise { 100_000 } else { args.k };
219
220    // G58: if the embedding is unavailable, route the entire direct path
221    // through FTS5 BM25 + LIKE prefix. Graph traversal is suppressed because
222    // it depends on the KNN results to seed the expansion; without the
223    // embedding, no seed exists.
224    let (direct_matches, memory_ids): (Vec<RecallItem>, Vec<i64>) =
225        if let Some(emb) = embedding.as_ref() {
226            let knn_results =
227                memories::knn_search(&conn, emb, &namespaces, memory_type_str, effective_k)?;
228            let mut items: Vec<RecallItem> = Vec::with_capacity(knn_results.len());
229            let mut memory_ids: Vec<i64> = Vec::with_capacity(knn_results.len());
230            for (memory_id, distance) in knn_results {
231                let row = {
232                    let mut stmt = conn.prepare_cached(
233                        "SELECT id, namespace, name, type, description, body, body_hash,
234                            session_id, source, metadata, created_at, updated_at
235                     FROM memories WHERE id=?1 AND deleted_at IS NULL",
236                    )?;
237                    stmt.query_row(rusqlite::params![memory_id], |r| {
238                        Ok(memories::MemoryRow {
239                            id: r.get(0)?,
240                            namespace: r.get(1)?,
241                            name: r.get(2)?,
242                            memory_type: r.get(3)?,
243                            description: r.get(4)?,
244                            body: r.get(5)?,
245                            body_hash: r.get(6)?,
246                            session_id: r.get(7)?,
247                            source: r.get(8)?,
248                            metadata: r.get(9)?,
249                            created_at: r.get(10)?,
250                            updated_at: r.get(11)?,
251                            deleted_at: None,
252                        })
253                    })
254                    .ok()
255                };
256                if let Some(row) = row {
257                    let snippet: String = row.body.chars().take(300).collect();
258                    items.push(RecallItem {
259                        memory_id: row.id,
260                        name: row.name,
261                        namespace: row.namespace,
262                        memory_type: row.memory_type,
263                        description: row.description,
264                        snippet,
265                        distance,
266                        score: RecallItem::score_from_distance(distance),
267                        source: "direct".to_string(),
268                        graph_depth: None,
269                    });
270                    memory_ids.push(memory_id);
271                }
272            }
273            (items, memory_ids)
274        } else {
275            // FTS5 BM25 + LIKE prefix fallback path. The same `fts_search` helper
276            // is used as in `hybrid-search`; distance is approximated by
277            // 1.0 / (rank + 1) so the score is in (0, 1] and comparable to the
278            // vector path's `1.0 - distance`. Note: only the FIRST effective_k
279            // results are kept to preserve the top-N contract.
280            let fts_rows = memories::fts_search(
281                &conn,
282                &query,
283                &namespace_for_graph,
284                memory_type_str,
285                effective_k,
286            )?;
287            let mut items: Vec<RecallItem> = Vec::with_capacity(fts_rows.len());
288            for (rank, row) in fts_rows.into_iter().enumerate() {
289                let dist = 1.0 - 1.0 / (rank as f32 + 1.0);
290                let snippet: String = row.body.chars().take(300).collect();
291                items.push(RecallItem {
292                    memory_id: row.id,
293                    name: row.name,
294                    namespace: row.namespace,
295                    memory_type: row.memory_type,
296                    description: row.description,
297                    snippet,
298                    distance: dist,
299                    score: RecallItem::score_from_distance(dist),
300                    source: "fts_fallback".to_string(),
301                    graph_depth: None,
302                });
303            }
304            (items, Vec::new())
305        };
306
307    let mut graph_matches = Vec::with_capacity(8);
308    if let Some(emb) = (!args.no_graph).then_some(()).and(embedding.as_ref()) {
309        let entity_knn = entities::knn_search(&conn, emb, &namespace_for_graph, 5)?;
310        let entity_ids: Vec<i64> = entity_knn.iter().map(|(id, _)| *id).collect();
311
312        let all_seed_ids: Vec<i64> = memory_ids
313            .iter()
314            .chain(entity_ids.iter())
315            .copied()
316            .collect();
317
318        if !all_seed_ids.is_empty() {
319            let graph_memory_ids = traverse_from_memories_with_hops(
320                &conn,
321                &all_seed_ids,
322                &namespace_for_graph,
323                args.min_weight,
324                args.max_hops,
325            )?;
326
327            for (graph_mem_id, hop) in graph_memory_ids {
328                // v1.0.23: respect the optional cap on graph results so dense
329                // neighbourhoods do not flood the response unintentionally.
330                if let Some(cap) = args.max_graph_results {
331                    if graph_matches.len() >= cap {
332                        break;
333                    }
334                }
335                let row = {
336                    let mut stmt = conn.prepare_cached(
337                        "SELECT id, namespace, name, type, description, body, body_hash,
338                                session_id, source, metadata, created_at, updated_at
339                         FROM memories WHERE id=?1 AND deleted_at IS NULL",
340                    )?;
341                    stmt.query_row(rusqlite::params![graph_mem_id], |r| {
342                        Ok(memories::MemoryRow {
343                            id: r.get(0)?,
344                            namespace: r.get(1)?,
345                            name: r.get(2)?,
346                            memory_type: r.get(3)?,
347                            description: r.get(4)?,
348                            body: r.get(5)?,
349                            body_hash: r.get(6)?,
350                            session_id: r.get(7)?,
351                            source: r.get(8)?,
352                            metadata: r.get(9)?,
353                            created_at: r.get(10)?,
354                            updated_at: r.get(11)?,
355                            deleted_at: None,
356                        })
357                    })
358                    .ok()
359                };
360                if let Some(row) = row {
361                    let snippet: String = row.body.chars().take(300).collect();
362                    let graph_distance = 1.0 - 1.0 / (hop as f32 + 1.0);
363                    graph_matches.push(RecallItem {
364                        memory_id: row.id,
365                        name: row.name,
366                        namespace: row.namespace,
367                        memory_type: row.memory_type,
368                        description: row.description,
369                        snippet,
370                        distance: graph_distance,
371                        score: RecallItem::score_from_distance(graph_distance),
372                        source: "graph".to_string(),
373                        graph_depth: Some(hop),
374                    });
375                }
376            }
377        }
378    }
379
380    // Filtrar por max_distance se < 1.0 (ativado). Se nenhum hit dentro do threshold, exit 4.
381    if args.max_distance < 1.0 && !vec_degraded {
382        let has_relevant = direct_matches
383            .iter()
384            .any(|item| item.distance <= args.max_distance);
385        if !has_relevant {
386            return Err(AppError::NotFound(errors_msg::no_recall_results(
387                args.max_distance,
388                &query,
389                &namespace_for_graph,
390            )));
391        }
392    }
393
394    let results: Vec<RecallItem> = direct_matches
395        .iter()
396        .cloned()
397        .chain(graph_matches.iter().cloned())
398        .collect();
399
400    let warning = if vec_degraded {
401        Some(
402            "live query embedding unavailable; results are FTS5 BM25 only (semantic relevance reduced)"
403                .to_string(),
404        )
405    } else {
406        None
407    };
408
409    output::emit_json(&RecallResponse {
410        query,
411        k: args.k,
412        direct_matches,
413        graph_matches,
414        results,
415        elapsed_ms: start.elapsed().as_millis() as u64,
416        vec_degraded,
417        vec_error: vec_error.clone(),
418        warning,
419        backend_invoked,
420        vec_degraded_reason: if vec_degraded { vec_error } else { None },
421    })?;
422
423    Ok(())
424}
425
426#[cfg(test)]
427mod tests {
428    use crate::output::{RecallItem, RecallResponse};
429
430    fn make_item(name: &str, distance: f32, source: &str) -> RecallItem {
431        RecallItem {
432            memory_id: 1,
433            name: name.to_string(),
434            namespace: "global".to_string(),
435            memory_type: "fact".to_string(),
436            description: "desc".to_string(),
437            snippet: "snippet".to_string(),
438            distance,
439            score: RecallItem::score_from_distance(distance),
440            source: source.to_string(),
441            graph_depth: if source == "graph" { Some(0) } else { None },
442        }
443    }
444
445    // Bug M-A5: every RecallItem carries a non-null cosine similarity score.
446    #[test]
447    fn recall_item_score_is_present_and_finite_for_direct_match() {
448        let item = make_item("mem", 0.25, "direct");
449        let json = serde_json::to_value(&item).expect("serialization failed");
450        let score = json["score"].as_f64().expect("score must be a number");
451        assert!(
452            (0.0..=1.0).contains(&score),
453            "score must be in [0, 1], got {score}"
454        );
455        assert!(
456            (score - 0.75).abs() < 1e-6,
457            "score must equal 1 - distance for canonical case"
458        );
459    }
460
461    #[test]
462    fn recall_item_score_clamps_distance_outside_unit_range() {
463        // Pathological distances must not yield score outside [0, 1] or NaN.
464        assert_eq!(RecallItem::score_from_distance(2.0), 0.0);
465        assert_eq!(RecallItem::score_from_distance(-0.5), 1.0);
466        assert_eq!(RecallItem::score_from_distance(f32::NAN), 0.0);
467    }
468
469    #[test]
470    fn recall_response_serializes_required_fields() {
471        let resp = RecallResponse {
472            query: "rust memory".to_string(),
473            k: 5,
474            direct_matches: vec![make_item("mem-a", 0.12, "direct")],
475            graph_matches: vec![],
476            results: vec![make_item("mem-a", 0.12, "direct")],
477            elapsed_ms: 42,
478            vec_degraded: false,
479            vec_error: None,
480            warning: None,
481            backend_invoked: None,
482            vec_degraded_reason: None,
483        };
484
485        let json = serde_json::to_value(&resp).expect("serialization failed");
486        assert_eq!(json["query"], "rust memory");
487        assert_eq!(json["k"], 5);
488        assert_eq!(json["elapsed_ms"], 42u64);
489        assert!(json["direct_matches"].is_array());
490        assert!(json["graph_matches"].is_array());
491        assert!(json["results"].is_array());
492    }
493
494    #[test]
495    fn recall_item_serializes_renamed_type() {
496        let item = make_item("mem-test", 0.25, "direct");
497        let json = serde_json::to_value(&item).expect("serialization failed");
498
499        // The memory_type field is renamed to "type" in JSON
500        assert_eq!(json["type"], "fact");
501        assert_eq!(json["distance"], 0.25f32);
502        assert_eq!(json["source"], "direct");
503    }
504
505    #[test]
506    fn recall_response_results_contains_direct_and_graph() {
507        let direct = make_item("d-mem", 0.10, "direct");
508        let graph = make_item("g-mem", 0.0, "graph");
509
510        let resp = RecallResponse {
511            query: "query".to_string(),
512            k: 10,
513            direct_matches: vec![direct.clone()],
514            graph_matches: vec![graph.clone()],
515            results: vec![direct, graph],
516            elapsed_ms: 10,
517            vec_degraded: false,
518            vec_error: None,
519            warning: None,
520            backend_invoked: None,
521            vec_degraded_reason: None,
522        };
523
524        let json = serde_json::to_value(&resp).expect("serialization failed");
525        assert_eq!(json["direct_matches"].as_array().unwrap().len(), 1);
526        assert_eq!(json["graph_matches"].as_array().unwrap().len(), 1);
527        assert_eq!(json["results"].as_array().unwrap().len(), 2);
528        assert_eq!(json["results"][0]["source"], "direct");
529        assert_eq!(json["results"][1]["source"], "graph");
530    }
531
532    #[test]
533    fn recall_response_empty_serializes_empty_arrays() {
534        let resp = RecallResponse {
535            query: "nothing".to_string(),
536            k: 3,
537            direct_matches: vec![],
538            graph_matches: vec![],
539            results: vec![],
540            elapsed_ms: 1,
541            vec_degraded: false,
542            vec_error: None,
543            warning: None,
544            backend_invoked: None,
545            vec_degraded_reason: None,
546        };
547
548        let json = serde_json::to_value(&resp).expect("serialization failed");
549        assert_eq!(json["direct_matches"].as_array().unwrap().len(), 0);
550        assert_eq!(json["results"].as_array().unwrap().len(), 0);
551    }
552
553    #[test]
554    fn graph_matches_distance_uses_hop_count_proxy() {
555        // Verify the hop-count proxy formula: 1.0 - 1.0 / (hop + 1.0)
556        // hop=0 → 0.0 (seed-level entity, identity distance)
557        // hop=1 → 0.5
558        // hop=2 → ≈ 0.667
559        // hop=3 → 0.75
560        let cases: &[(u32, f32)] = &[(0, 0.0), (1, 0.5), (2, 0.6667), (3, 0.75)];
561        for &(hop, expected) in cases {
562            let d = 1.0_f32 - 1.0 / (hop as f32 + 1.0);
563            assert!(
564                (d - expected).abs() < 0.001,
565                "hop={hop} expected={expected} got={d}"
566            );
567        }
568    }
569}