REST API reference

All endpoints are versioned under /api/v1 and require a bearer token scoped to the target database.

Base URL

https://wamsqlite.rendovations.com/api/v1

Run statements

POST /databases/{database}/query

Executes one or more SQL statements in order against the database. Statements are pre-split by the client — each array entry is exactly one statement, with no trailing semicolon required.

Request body

{
  "statements": [
    "SELECT * FROM users WHERE id = 1",
    "UPDATE users SET last_seen_at = CURRENT_TIMESTAMP WHERE id = 1"
  ]
}

Response — all statements succeed (200)

{
  "database": "3f9a1b2c-4d5e-4f6a-8b9c-0d1e2f3a4b5c",
  "results": [
    {
      "sql": "SELECT * FROM users WHERE id = 1",
      "columns": ["id", "name", "email"],
      "rows": [{ "id": 1, "name": "Ada Lovelace", "email": "ada@example.com" }],
      "rows_affected": 1,
      "last_insert_id": null,
      "time_ms": 0.42
    },
    {
      "sql": "UPDATE users SET last_seen_at = CURRENT_TIMESTAMP WHERE id = 1",
      "columns": [],
      "rows": [],
      "rows_affected": 1,
      "last_insert_id": null,
      "time_ms": 0.31
    }
  ],
  "error": null
}

Response — a statement fails (400)

Execution stops at the first failing statement. results contains every statement that succeeded before it; the failing one and everything after it are not run.

{
  "database": "3f9a1b2c-4d5e-4f6a-8b9c-0d1e2f3a4b5c",
  "results": [],
  "error": {
    "statement_index": 0,
    "sql": "SELECT * FROM does_not_exist",
    "message": "no such table: does_not_exist"
  }
}

Inspect the schema

GET /databases/{database}/schema

Lists every table and view in the database, along with its row count.

{
  "database": "3f9a1b2c-4d5e-4f6a-8b9c-0d1e2f3a4b5c",
  "tables": [
    { "name": "users", "type": "table", "row_count": 128 }
  ]
}

Limits

Limit	Value
Requests per minute	120, per database
Statements per request	50
Databases per account	10