Run one bounded read-only Dev or Prod database query

Executes one SELECT through the project's least-privilege read-only role. Application row-level security policies apply and may filter rows; a complete SQL archive uses the separate authorized export workflow. Connection credentials are never returned.

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

Request

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

Path parameters

project_idstring required

Project identifier.

Headers

X-Request-Idstring

Optional caller-provided correlation identifier.

Request body

environment'dev' | 'prod' required
statementstring required

Response

At most 100 JSON rows from the selected project database.

environment'dev' | 'prod' required
rowsobject[] required
row_countinteger required
truncatedboolean required

Changes

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