Skip to main content
POST
Execute single SQL statement

Body

application/json
query
string
required

Parameterised SQL statement

Example:

"SELECT * FROM trades WHERE symbol = ? LIMIT ?"

requestId
string<uuid>

Optional correlation ID for tracing

Example:

"9b1deb4d-3b7d-4bad-9bdd-2b0d7b3dcb6d"

params
any[]

Bound parameters for the prepared statement

Example:

Response

Query executed successfully

success
boolean
Example:

true

requestId
string<uuid>
Example:

"9b1deb4d-3b7d-4bad-9bdd-2b0d7b3dcb6d"

results
any[]

Rows returned by SELECT queries

lastRowId
integer | null

Row ID for INSERT/REPLACE

changes
integer | null

Rows changed for INSERT/UPDATE/DELETE

Last modified on June 17, 2026