Execute one bounded database write in Dev or Prod

Owner-authorized INSERT, UPDATE or DELETE through the restricted runtime role, including ordinary upsert. Environment is mandatory. One direct statement and transaction, five-second timeout and at most 1000 directly affected rows; customer triggers and cascades may affect more rows. Rows are not returned. The durable Idempotency-Key receipt persists until project deletion. Same-key retries observe the original execution attempt; unknown outcomes never automatically execute again. Inspect target data before deliberately choosing a new key. Schema changes use GitHub migrations. Database compute is metered normally and existing credit grace and Stop budgets apply. Application row-level security policies remain effective for writes.

post/v1/projects/{project_id}/database/write

Request

  • Base URL: https://app.ohmyho.st
  • URL: https://app.ohmyho.st/v1/projects/{project_id}/database/write
  • Auth: HTTP bearer

Path parameters

project_idstring required

Project identifier.

Headers

X-Request-Idstring

Optional caller-provided correlation identifier.

Idempotency-Keystring required

Identifies one mutation and its canonical request payload.

Request body

environment'dev' | 'prod' required
statementstring required

One direct INSERT, UPDATE or DELETE, max 64 KiB UTF-8; entire JSON request is limited to 65,600 bytes.

Response

Terminal receipt; failed state is not a successful write.

operation_idstring required
environment'dev' | 'prod' required
state'running' | 'succeeded' | 'failed' required
command'INSERT' | 'UPDATE' | 'DELETE' | 'null' nullable required
affected_rowsinteger nullable required

Changes

No recorded changes to this operation across all 1 revision of this API.