Database operators

The Database family contains 2 operators. Read/write the tenant Postgres schema.

Operators in this family

• db.mutate
• db.query

db.mutate

Executes one or more INSERT/UPDATE/DELETE statements as a single transaction under tenant RLS. Each statement is allowlisted (no DDL) and parameterised. Writes an audit row to glyph.operator_audit on commit.

Version 1.0.0 · Semantics side_effect · Visibility advanced

Config

Field	Type	Required	Default	Description
audit_label	string	yes	—	Label recorded in the operator_audit row for traceability.
schema	”glyph” | “app”	no	—	Optional schema scope hint. Statements still use fully-qualified table names.
statements	object[]	yes	—

Input ports

Port	Type	Required	Description
input	any	no	Input

Output ports

Port	Type	Required	Description
output	object	no	Output

db.query

Executes a parameterized SQL query.

Version 1.0.0 · Semantics side_effect · Visibility advanced

Config

Field	Type	Required	Default	Description
params	array	no	—	Query parameters (positional).
query	string	yes	—	Parameterized SQL query (use $1, $2, …).

Input ports

Port	Type	Required	Description
input	any	no	Input

Output ports

Port	Type	Required	Description
row_count	integer	no	Row Count
rows	array	no	Rows

Source schemas

Every operator above is rendered from its JSON schema in /opt/glyph/schemas/operators/:

• schemas/operators/db.mutate.json
• schemas/operators/db.query.json