Schema
CREATE TABLE customers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
email TEXT NOT NULL DEFAULT '',
plan TEXT NOT NULL DEFAULT 'free',
created_at TEXT NOT NULL
);
Semantics
- Read through
customers.list, written throughcustomers.createover MCP and through the UI. customers.createis an agent-callable write with no confirmation step. That is a known gap: an agent acting on a misread instruction can add a row. The mitigation today is the audit trail, not a gate.
Open
The table is deliberately thin. The conversation model (threads, messages) is richer than the CRM it talks about, which is the right order to build in — but it means most "show me the customers" answers are still one flat list.
Rendered from nx-master/data-model/customers.md · OKF bundle · regenerate with npm run render