List every table in the database with its row count and columns.

Read-only. Runs immediately, no confirmation needed.

Show the columns, types, constraints and foreign keys of one table.

Read-only. Runs immediately, no confirmation needed.

Args: table: Name of the table to describe.

Run one read-only SELECT and return the rows.

Only a single SELECT is accepted. Anything else - a write, DDL, PRAGMA, ATTACH, a stacked statement, a comment - is rejected before it reaches the database, and the connection used here is opened read-only anyway.

Args: sql: A single SELECT statement.

Preview a write without committing it, and get a change_id back.

The statement is validated, executed inside a transaction to compute a real preview, then rolled back. Nothing is written. Show the returned preview to the human and call confirm_change with the change_id to commit it. The id is single use and expires.

Accepts one INSERT, UPDATE or DELETE against an existing table. UPDATE and DELETE must have a WHERE clause.

Args: sql: A single INSERT, UPDATE or DELETE statement.

Commit a change that propose_change previewed.

The statement is re-validated and re-executed, then committed. The change_id must be one propose_change returned, still unused and not yet expired. There is no way to commit a write without one.

Args: change_id: The id returned by propose_change.

List the proposed changes that are still awaiting confirmation.

Read-only. Shows each pending change_id, its SQL and how long it has left before it expires.