Queries API

Execute SQL queries against your database. Only DML statements are allowed.

POST/organizations/:orgId/databases/:dbId/query

Execute a SQL query. Supports SELECT, INSERT, UPDATE, and DELETE.

SELECT query

Request

{
  "query": "SELECT * FROM users WHERE active = true"
}

Response

{
  "rows": [
    { "id": 1, "email": "alice@example.com", "name": "Alice", "active": true },
    { "id": 2, "email": "bob@example.com", "name": "Bob", "active": true }
  ]
}

INSERT query

Request

{
  "query": "INSERT INTO users (email, name) VALUES ('carol@example.com', 'Carol')"
}

Response

{
  "id": 3
}

DDL statements (CREATE TABLE, ALTER TABLE, DROP TABLE) are not allowed through the query endpoint. Use the Tables API instead.