Insert Rows
baatjie_insertInsert rows into tanOS or sigsche tables with audit logging. Specify project, table, and rows to write data while the actor is recorded in the audit trail.
Instructions
Insert one or more rows into any table in tanOS or sigscheCore. Every insert is recorded in tanOS audit_log with the actor you supply.
Args:
project ('tanos' | 'sigsche'): Which system
table (string): Target table
rows (object[]): Rows to insert, 1-100. Omit columns with database defaults.
actor (string): Who is writing, for the audit trail (default: 'mcp')
response_format ('markdown' | 'json'): Output format
Returns: { "ok": true, "table": string, "action": "insert", "affected": number, "rows": object[], "audit_logged": boolean, "note"?: string }
Examples:
Log a signed agency -> table='locare_accounts', rows=[{"agency_name":"Cape Letting","brm_id":"...","tier":"Growth","status":"active"}]
Record a payment -> table='payments', rows=[{"lease_id":"...","amount":3400,"payment_date":"2026-08-08","method":"payroll"}]
Note: writes to occupant-facing tables (tenants, leases, notices, payments) are flagged in the response, because a row there corresponds to a real person's tenancy or money. A 'notices' row in particular represents a notice served on an occupant — South African arrears and eviction notices carry statutory requirements, so route the wording through your legal-exposure-check skill before sending rather than after.
Error Handling:
Foreign key failures name the missing parent record
CHECK constraint failures point at columns with restricted values
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | Rows to insert | |
| actor | No | Who is performing this write, recorded in tanOS audit_log (e.g. 'baatjie', 'marius-ai', 'deon-ai') | mcp |
| table | Yes | Target table | |
| project | Yes | Which system: 'tanos' (property OS, pipeline, sequencing) or 'sigsche' (signal scheduler) | |
| response_format | No | Output format: 'markdown' for human-readable, 'json' for machine-readable | markdown |