Skip to main content
Inspector

Get Database Schema

List tables, views, and columns in the actor's SQLite database.

The inspector API is subject to change without notice. Do not build production integrations on it.

GET https://rivet.example.com/gateway/{actor}/inspector/database/schema

Examples

Authentication

Inspector endpoints do not accept namespace tokens. Send the actor’s inspector token as a bearer token in the Authorization header.

Path Parameters

NameTypeRequiredDescription
actorstringYesActor ID, actor ID with an inline token ({actor_id}@{token}), or actor name combined with the rvt-* query parameters.

Headers

NameTypeRequiredDescription
AuthorizationstringNoBearer token for inspector authentication. Required in production, optional in development.

Responses

200

The actor database schema.

FieldTypeDescription
schemaobject
schema.tablesobject[]
schema.tables[].namestring
schema.tables[].type"table" | "view"
schema.tables[].columnsobject[]
schema.tables[].columns[].namestring
schema.tables[].columns[].typestring
schema.tables[].columns[].notnullboolean
schema.tables[].columns[].pkboolean
{
  "schema": {
    "tables": [
      {
        "name": "my-actor",
        "type": "table",
        "columns": [
          {
            "name": "my-actor",
            "type": "<type>",
            "notnull": false,
            "pk": false
          }
        ]
      }
    ]
  }
}

401

The inspector token is missing or invalid.