Run a query against a database

POST

/proxy/{uuid}/query

The data plane: what a client library talks to, continuously. Same
described shapes as the control plane's query route — select,
insert, update, delete — but pooled, with a circuit breaker in
front of a failing engine, retries for transient failures only, and
every statement recorded.

Api keys only. A database is addressed by uuid, which is what a client
can be given without also learning how many exist.

Request

Authorization

API Key

Add parameter in header

x-api-key

Example:

x-api-key: ********************

Path Params

Body Params application/jsonRequired

Examples

Responses

🟢200

application/json

What the engine answered

Bodyapplication/json

🟠400

🟠401

🟠403

🟠429

🔴502

🔴503

🟠404NotFound

Request Example

Shell

JavaScript

Java

Swift

curl --location 'https://api.prod-orm.io/proxy//query' \
--header 'x-api-key: <api-key>' \
--header 'Content-Type: application/json' \
--data '{
    "select": {
        "from": "string",
        "attributes": [
            "string"
        ],
        "where": {},
        "order": [
            [
                "string"
            ]
        ],
        "limit": 0,
        "offset": 0
    },
    "insert": {
        "into": "string",
        "values": {}
    },
    "update": {
        "table": "string",
        "set": {},
        "where": {}
    },
    "delete": {
        "from": "string",
        "where": {}
    }
}'

Response Example

200 - Example 1

{
    "rows": [
        {}
    ],
    "meta": {},
    "statement": "string",
    "durationMs": 0,
    "attempts": 0
}

Modified at 2026-10-05 14:01:12

Close a pool

Several statements, in order, over one connection