{
    "action": "tool_call",
    "reasoning": "Profile nulls, ranges, spread, key uniqueness and categorical cardinality in a single pass over raw.Iris before answering.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT COUNT(*) AS n, COUNT(DISTINCT Id) AS distinct_ids, MIN(Id) AS min_id, MAX(Id) AS max_id, COUNT(SepalLengthCm) AS sl_nn, MIN(SepalLengthCm) AS sl_min, MAX(SepalLengthCm) AS sl_max, AVG(SepalLengthCm) AS sl_avg, STDDEV(SepalLengthCm) AS sl_sd, COUNT(SepalWidthCm) AS sw_nn, MIN(SepalWidthCm) AS sw_min, MAX(SepalWidthCm) AS sw_max, AVG(SepalWidthCm) AS sw_avg, STDDEV(SepalWidthCm) AS sw_sd, COUNT(PetalLengthCm) AS pl_nn, MIN(PetalLengthCm) AS pl_min, MAX(PetalLengthCm) AS pl_max, AVG(PetalLengthCm) AS pl_avg, STDDEV(PetalLengthCm) AS pl_sd, COUNT(PetalWidthCm) AS pw_nn, MIN(PetalWidthCm) AS pw_min, MAX(PetalWidthCm) AS pw_max, AVG(PetalWidthCm) AS pw_avg, STDDEV(PetalWidthCm) AS pw_sd, COUNT(Species) AS sp_nn, COUNT(DISTINCT Species) AS sp_distinct, COUNT(DISTINCT _source_file) AS files, COUNT(DISTINCT _batch_id) AS batches, COUNT(DISTINCT _source_system) AS systems FROM raw.Iris",
        "purpose": "Profile nulls, ranges, spread, key uniqueness and categorical cardinality in one pass",
        "source": "raw"
    }
}