site

Call site.database.execute

Change what a site's own database holds — 'add that product to my site's shop', 'update the price in the site's database', 'delete that stale record from the site'. Change this site's own database with one SQL statement — insert, update, delete, or a schema change the site's code expects. Calling it raises the approval card showing the exact statement — and, for an update or delete, how many rows it touches — which is the member's confirmation. Put every value in params as a ? placeholder, and read the schema with site.database.query before writing. NEVER run a delete or update without a where clause, and never describe anything as changed before the member has approved. Not for reading the database — that is site.database.query. Over the API it answers in two calls: without confirmation_id it proposes — says what would happen, returns a confirmation_id and changes, spends and sends nothing; the same arguments again with that confirmation_id, on a member's own API key, do it.

Every result names the workspace it ran in. Say which workspace the answer is about. When the account has more than one workspace and none is selected, this tool refuses with workspace_ambiguous and lists the choices — offer them, never pick one.

post/api/v1/tools/site.database.execute

Request

  • Base URL: https://app.goosybear.ai
  • URL: https://app.goosybear.ai/api/v1/tools/site.database.execute
  • Auth: HTTP bearer

Headers

x-request-idstring

Your own id for this request, echoed back and recorded on the audit trail. 1–128 characters from A–Z a–z 0–9 . _ : -, starting with a letter or digit; anything else is replaced by a generated id.

Request body

site_idstring uuid required

The site, as a UUID. Take it from page.list or from the conversation's context — never invent one.

sqlstring required

ONE SQL statement for this site's own SQLite (D1) database. Put every value in params as a ? placeholder — never paste a value into the SQL, not even one the operator typed. Use site.database.query with select name from sqlite_master where type='table' first if you do not know the schema.

paramsstring[]

The values for the ? placeholders, in order. Always strings — SQLite converts them.

confirmation_idstring uuid

Omit to propose: the first call says what would happen, returns a confirmation_id and changes nothing. To go ahead, send the same arguments again with that confirmation_id, on a member's own API key; a service account's key can propose but never confirm.

workspacestring

Which workspace to run in — its slug. Omit to use your default. With more than one reachable workspace and no default, the call is refused and the choices are listed.

Response

The call was admitted and dispatched. ok says whether the tool succeeded — a refusal the tool itself produced is still a 200, exactly as it is a successful JSON-RPC result over MCP.

OR

Changes

No recorded changes to this operation across all 4 revisions of this API.