Debug R2 SQL diagnostics | Runtype Documentation

{
  "success": true,
  "data": {
    "query": "SELECT * FROM logs WHERE level = 'debug' ORDER BY timestamp DESC LIMIT 10;",
    "executionTimeMs": 12,
    "rowsReturned": 10,
    "logs": [
      {
        "timestamp": "2024-06-15T10:23:45Z",
        "level": "debug",
        "message": "Connection pool initialized",
        "context": {
          "connectionId": "conn-1234",
          "durationMs": 5
        }
      },
      {
        "timestamp": "2024-06-15T10:23:46Z",
        "level": "debug",
        "message": "SQL query executed",
        "context": {
          "queryId": "qry-5678",
          "rowsAffected": 3
        }
      }
    ]
  }
}

R2 SQL diagnostic endpoint for troubleshooting log queries. Non-production only.

Authentication

AuthorizationBearer

API key or Clerk session token

Response

Diagnostics returned

successboolean

dataany

Errors

401

Unauthorized Error

404

Not Found Error

$	curl https://api.runtype.com/v1/logs/debug \
>	-H "Authorization: <apiKey>" \
>	-H "Content-Type: application/json"