Open an interactive transaction; returns a handle to use with transactionQuery/transactionExecute/commitTransaction/rollbackTransaction.
timeout_msinteger· uint64min 0
transactionobject*required
JSON wire envelope returned by `beginTransaction`.
expires_atstring· date-time*required
Commit and finalize an interactive transaction.
transaction_idstring*required
committedboolean*required
database::execute
functionRun a write statement (INSERT/UPDATE/DELETE/DDL).
affected_rowsinteger· uint64*requiredmin 0
returned_rowsobject[]*required
database::listDatabases
functionList all configured databases with connection details (driver, credential-redacted URL, pool settings, TLS mode). Config only — no health checks or live pool statistics.
countinteger· uint*requiredmin 0
databasesobject[]*required
driverstring*required
"postgres" | "mysql" | "sqlite".
namestring*required
Logical key (e.g. "primary").
poolobject*required
Pool settings echoed back from config (no live stats).
acquire_timeout_msinteger· uint64*requiredmin 0
idle_timeout_msinteger· uint64*requiredmin 0
maxinteger· uint32*requiredmin 0
tlsobject*required
TLS settings. `ca_cert` is reported as a presence boolean only — never the path, which would leak filesystem layout.
ca_cert_presentboolean*required
modeone of*required
… expand 3 nestedcollapse
one of (3)
variant 1
valuestringenum: disable
variant 2
valuestringenum: require
variant 3
valuestringenum: verify-full
trust_nativeboolean*required
urlstring*required
Connection URL with credentials redacted.
Internal: reload connection pools from the authoritative configuration when it changes.
idstring
Configuration id that changed (advisory; the handler re-fetches the value). Schema-only: kept to publish a typed request schema; the handler ignores it.
Prepare a parameterized statement once.
ttl_secondsinteger· uint64min 0
handleobject*required
expires_atstring· date-time*required
Run a read-only SQL query and return the result rows.
timeout_msinteger· uint64min 0
row_countinteger· uint*requiredmin 0
Rollback and finalize an interactive transaction.
transaction_idstring*required
rolled_backboolean*required
database::runStatement
functionRun a previously-prepared handle.
row_countinteger· uint*requiredmin 0
database::transaction
functionRun a sequence of statements atomically.
statementsobject[]*required
committedboolean*required
failed_indexinteger· uintmin 0
resultsobject[]
affected_rowsinteger· uint64*requiredmin 0
Run a write statement inside an interactive transaction. BEGIN/COMMIT/ROLLBACK are rejected; use commit/rollbackTransaction.
transaction_idstring*required
affected_rowsinteger· uint64*requiredmin 0
returned_rowsobject[]*required
Run a read-only SQL query inside an interactive transaction.
transaction_idstring*required
row_countinteger· uint*requiredmin 0