Run one read-only SQL statement and get CSV back: a header row, data rows, then a '# N rows' trailer that says whether the result was truncated. Time-limited and capped in rows and bytes. Select only the columns you need and keep limit small: results cost context.

Run one data or additive-schema statement and return the affected row count. Refuses DELETE, DROP, ALTER and triggers: those need destructive_query. An UPDATE that touches more rows than the configured cap is rolled back, so a forgotten WHERE clause cannot rewrite a whole table by accident. RETURNING clauses come back as CSV.

Run one destructive statement. A snapshot of the database file is written first (the newest few are kept next to the database), then the statement runs. Requires a short reason, which lands in the audit log. Never use this when write_query would do.

List tables and views as CSV: name, type, system (1 for the server's own memory and audit tables) and row count (tables only).

Columns (cid, name, type, notnull, default, pk), foreign keys and indexes of a table or view, as CSV sections.

The CREATE statements of every table, index, view and trigger, exactly as stored. View descriptions appear as '-- description:' comments. The server's own tables are hidden unless include_system is true.

Save a SELECT as a named view: a reusable query skill. Give it a description so future sessions know what it is for; it is stored inside the view and shown by get_schema. With replace=true an existing view is redefined and its previous definition is kept in query_log.

Append one entry to the memory log. The log is append-only and hash-chained by the server, so history cannot be rewritten through SQL. Use it for decisions, results, errors and observations worth remembering across sessions.

Recompute the memory_events hash chain and report whether it is intact, with the first event id where it breaks if it is not.

Write a summary of the current state to memory_checkpoints, anchored to the latest event. Do this at milestones and before context runs out; get_resume_context returns the latest one.

Call this first in a new session or after context compaction. Returns the latest checkpoint, the events appended since it (oldest first, most recent max_events), and the result of verifying the hash chain.

Regex search inside column values in one call: the WHERE filter narrows rows in SQL, then ripgrep matches the pattern over the selected columns. Returns CSV rows of key, column, snippet, one per matching value, plus a trailer with the totals.