saya-cli 0.3.1

Database-aware AI agent for the terminal: full-screen TUI, schema discovery, and bounded read-only SQL over PostgreSQL, MySQL, SQLite, DuckDB, and Snowflake.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78

//! Builds and records tool observations from a SQL statement and its result.
//!
//! Kept separate from the collector so the recording concern (extracting names
//! and outcome metadata) is testable without the executor. An observation never
//! copies SQL or result values — only the fields `ToolObservation` carries.

use saya_connectors::sql_references;
use saya_types::{ProfileIdentity, SqlDialect};
use serde_json::Value;

use super::observations::{ObservationLog, ObservationOutcome, ToolObservation};

impl ObservationLog {
    /// Records a query-tool observation. `profile_id` is the resolved
    /// connection's identity (None when the connection has no identity, e.g. a
    /// test connector). `sql` is the statement as the model wrote it. `result`
    /// is the tool's serialized result on success; on failure it is `None`.
    pub(crate) fn record_query(
        &self,
        tool: &str,
        sql: &str,
        dialect: SqlDialect,
        profile_id: Option<&str>,
        result: Option<&Value>,
    ) {
        let refs = sql_references(sql, dialect).unwrap_or_default();
        let (objects, columns, references_partial) = (refs.objects, refs.columns, refs.partial);
        let (outcome, row_count, truncated) = match result {
            Some(value) => (
                ObservationOutcome::Succeeded,
                value
                    .get("row_count")
                    .and_then(Value::as_u64)
                    .map(|n| n as usize),
                value.get("truncated").and_then(Value::as_bool),
            ),
            // A failure records the objects the SQL named (if it parsed) and
            // nothing else — no error string, no row count, no truncation.
            None => (ObservationOutcome::Failed, None, None),
        };
        self.record(ToolObservation {
            tool: tool.into(),
            outcome,
            profile: profile_id.and_then(parse_identity),
            objects,
            columns,
            row_count,
            truncated,
            references_partial,
        });
    }

    /// Records a schema-discovery observation. It touches no specific table, so
    /// it carries no objects or columns.
    pub(crate) fn record_schema(&self, tool: &str, profile_id: Option<&str>, succeeded: bool) {
        self.record(ToolObservation {
            tool: tool.into(),
            outcome: if succeeded {
                ObservationOutcome::Succeeded
            } else {
                ObservationOutcome::Failed
            },
            profile: profile_id.and_then(parse_identity),
            objects: Vec::new(),
            columns: Vec::new(),
            row_count: None,
            truncated: None,
            references_partial: false,
        });
    }
}

fn parse_identity(value: &str) -> Option<ProfileIdentity> {
    // The registry stores the validated `p-<64 hex>` identity as a string; a
    // malformed value means no profile to attribute, so degrade to None rather
    // than fail the tool over an observation.
    ProfileIdentity::parse(value).ok()
}