---
title: "List SQLite tables"
method: GET
path: "/gateway/{actor}/inspector/database/schema"
---

# List SQLite tables

`GET /gateway/{actor}/inspector/database/schema`

## Request

- The document declares no server URL.
- Auth: none declared

## Path parameters

- `actor` string, required

## Headers

- `Authorization` string

## Response `200`

Tables and views in the actor's SQLite database

- object
  - `schema` object
    - `tables` object[]
      - `name` string
      - `type` 'table' | 'view'
      - `columns` object[]
        - `name` string
        - `type` string
        - `notnull` boolean
        - `pk` boolean

## Other responses

- `401`: Unauthorized

## Changes

- **2026-09-29** `0130d6e7eada`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/rivet-dev/apis/rivetkit-api/changes/gateway/:actor/inspector/database/schema/get.md)

---

[API](https://skmtc.dev/rivet-dev/apis/rivetkit-api.md) - [All operations](https://skmtc.dev/rivet-dev/apis/rivetkit-api/llms.txt) - [OpenAPI document](https://skmtc.dev/rivet-dev/apis/rivetkit-api/revisions/0130d6e7eada?raw)