> ## Documentation Index > Fetch the complete documentation index at: https://docs.ohmyho.st/llms.txt > Use this file to discover all available pages before exploring further. > ## Agent Instructions > For account actions, read https://ohmyho.st/skills/ohmyhost-get-started/SKILL.md and use the authenticated ohmyho.st CLI or local product MCP. Mintlify search only reads documentation. Preserve the customer’s selected project, environment and authentication provider. # 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. ## OpenAPI ````yaml /openapi.json post /v1/projects/{project_id}/database/write openapi: 3.1.2 info: title: ohmyho.st API version: 0.0.0 description: >- Public REST API for ohmyho.st hosting, projects, domains, email, credits and exports. servers: - url: https://app.ohmyho.st description: Production control API - url: https://dev.app.ohmyho.st description: Development control API security: - BearerAuth: [] paths: /v1/projects/{project_id}/database/write: post: summary: Execute one bounded database write in Dev or Prod description: >- 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. operationId: writeProjectDatabase parameters: - $ref: '#/components/parameters/RequestId' - $ref: '#/components/parameters/ProjectId' - $ref: '#/components/parameters/IdempotencyKey' requestBody: required: true content: application/json: schema: $ref: '#/components/schemas/ProjectDatabaseWriteRequest' responses: '200': description: Terminal receipt; failed state is not a successful write. content: application/json: schema: $ref: '#/components/schemas/ProjectDatabaseWriteReceipt' '202': description: The same write is in progress. Poll the existing operation. content: application/json: schema: $ref: '#/components/schemas/ProjectDatabaseWriteReceipt' '400': $ref: '#/components/responses/Problem' '401': $ref: '#/components/responses/Problem' '402': $ref: '#/components/responses/Problem' '404': $ref: '#/components/responses/ResourceNotFound' '409': $ref: '#/components/responses/Problem' '429': $ref: '#/components/responses/Problem' '503': $ref: '#/components/responses/Problem' components: parameters: RequestId: name: X-Request-Id in: header description: Optional caller-provided correlation identifier. required: false schema: type: string minLength: 1 maxLength: 128 ProjectId: name: project_id in: path description: Project identifier. required: true schema: $ref: '#/components/schemas/Ulid' IdempotencyKey: name: Idempotency-Key in: header description: Identifies one mutation and its canonical request payload. required: true schema: type: string minLength: 1 maxLength: 128 schemas: ProjectDatabaseWriteRequest: type: object additionalProperties: false required: - environment - statement - parameters properties: environment: type: string enum: - dev - prod statement: type: string minLength: 1 maxLength: 65536 description: >- One direct INSERT, UPDATE or DELETE, max 64 KiB UTF-8; entire JSON request is limited to 65,600 bytes. parameters: type: array maxItems: 100 items: {} description: JSON values, at most 8 levels and 10000 nodes, max 64 KiB encoded. ProjectDatabaseWriteReceipt: type: object additionalProperties: false required: - operation_id - environment - state - command - affected_rows - error properties: operation_id: $ref: '#/components/schemas/Ulid' environment: type: string enum: - dev - prod state: type: string enum: - running - succeeded - failed command: type: - string - 'null' enum: - INSERT - UPDATE - DELETE - null affected_rows: type: - integer - 'null' minimum: 0 maximum: 1000 error: oneOf: - $ref: '#/components/schemas/OperationFailure' - type: 'null' Ulid: type: string pattern: ^[0-9A-HJKMNP-TV-Z]{26}$ OperationFailure: type: object additionalProperties: false required: - code - message - retryable - suggested_action properties: code: type: string enum: - operation_failed - recovery_dispatch_failed - recovery_job_failed - recovery_input_expired - recovery_database_unavailable - recovery_checksum_mismatch - recovery_scope_unavailable - recovery_archive_too_large - build_not_started - build_failed - database_write_rejected - database_write_unavailable - database_write_outcome_unknown - database_compute_failed - database_compute_plan_changed - database_compute_rejected - database_migration_failed - insufficient_organization_credits - paid_plan_required - runtime_candidate_failed - runtime_candidate_rejected - storage_jurisdiction_conflict - container_runtime_secrets_unsupported - provider_state_absent message: type: string minLength: 1 maxLength: 512 retryable: type: boolean const: false description: >- A terminal operation cannot be retried in place; follow suggested_action. suggested_action: type: string minLength: 1 maxLength: 500 ProblemDetails: type: object description: RFC 9457 Problem Details extended with stable ohmyhost recovery fields. additionalProperties: false required: - type - title - status - code - request_id - retryable - suggested_action properties: type: type: string format: uri-reference title: type: string minLength: 1 status: type: integer minimum: 400 maximum: 599 detail: type: string instance: type: string format: uri-reference code: type: string enum: - invalid_request - unauthenticated - forbidden - resource_not_found - idempotency_key_reused - project_handle_unavailable - project_identity_unavailable - deployment_plan_expired - deployment_plan_incompatible - confirmation_expired - confirmation_invalid - etag_mismatch - promotion_source_stale - promotion_target_stale - promotion_invalid_target - mail_domain_conflict - mail_domain_required - framework_conversion_required - migration_filename_noncanonical - environment_secret_mutation_blocked - container_runtime_required - payload_too_large - rate_limited - insufficient_organization_credits - paid_plan_required - project_budget_exceeded - compute_performance_paid_required - compute_performance_unavailable - database_write_pending - database_access_limit - compute_change_pending - compute_change_conflict - billing_purchase_conflict - billing_recharge_conflict - cloudflare_authorization_closed - project_notes_conflict - project_export_not_ready - interactive_login_required - api_key_creation_uncertain - api_key_permissions_unavailable - reconciliation_exhausted - service_unavailable request_id: type: string minLength: 1 maxLength: 128 retryable: type: boolean retry_after_seconds: type: integer minimum: 1 maximum: 86400 description: >- Optional machine-readable retry delay for a rate limit, matching Retry-After. suggested_action: type: string minLength: 1 responses: Problem: description: The request failed. headers: X-Request-Id: $ref: '#/components/headers/XRequestId' content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetails' ResourceNotFound: description: >- The resource does not exist or is not visible to the authenticated principal. headers: X-Request-Id: $ref: '#/components/headers/XRequestId' content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetails' examples: resourceNotFound: value: type: https://docs.ohmyho.st/errors/resource-not-found title: Resource not found status: 404 code: resource_not_found request_id: req_01J00000000000000000000000 retryable: false suggested_action: Check the resource identifier and your access scope. headers: XRequestId: description: Correlates the request with operations, events, logs, and audit records. required: true schema: type: string minLength: 1 maxLength: 128 securitySchemes: BearerAuth: type: http scheme: bearer description: >- WorkOS access JWT or a user-owned WorkOS API key. User keys are bound to one organization and restricted to their enabled product permissions. Session-only onboarding and session revocation require an interactive access JWT. No cookie session is assumed. ````