What the AI Actually Sees

Select what you feed into the AI's Context Window when asking "What is our revenue?"

/* USER PROMPT: What is our revenue? */
/* CONTEXT SUPPLIED: DATABASE SCHEMA */
CREATE TABLE sales_data_v2_final (
tx_amt_d FLOAT,
status_c INT,
refund_f BOOLEAN
);
/* USER PROMPT: What is our revenue? */
/* CONTEXT SUPPLIED: SEMANTIC GRAPH */
{
"metric": "Revenue",
"calculation": "SUM(tx_amt_d)",
"table": "sales_data_v2_final"
}
/* USER PROMPT: What is our revenue? */
/* CONTEXT SUPPLIED: SCHEMA + BUSINESS DOCUMENTATION */
Table: sales_data_v2_final
Metric: Revenue
Business Rule: "Revenue is SUM(tx_amt_d) WHERE status_c = 1 (completed). Note: Always subtract refunds (refund_f = true) to get accurate net revenue."
🤖
"I see a column called 'tx_amt_d'. I'll guess that's revenue.
Result: Hallucination (Included Refunds & Failed Transactions)"