> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vertracloud.app/llms.txt
> Use this file to discover all available pages before exploring further.

# List Schemas

> Lists the schemas of a PostgreSQL or MySQL database. System schemas are excluded.

<Note>
  Every `/data` endpoint needs the **Intermediary** plan or higher, on the **database owner's**
  account — not the caller's. Below that the answer is `PLAN_RESTRICTED_FEATURE` (403).
  It is also **dashboard-session only**: an API key gets `API_KEY_SCOPE_DENIED` (403) here, regardless of
  its scopes.
</Note>

PostgreSQL and MySQL only. On other engines the endpoint answers `ENGINE_UNSUPPORTED`.

<ParamField path="id" type="string" required>
  The ID of the database.
</ParamField>

<ParamField query="workspace" type="string">
  Workspace the database belongs to.
</ParamField>

### Response

<ResponseField name="response" type="object[]">
  <Expandable title="Toggle object">
    <ResponseField name="name" type="string">Schema name.</ResponseField>
    <ResponseField name="tables_count" type="number">Number of base tables in the schema.</ResponseField>
    <ResponseField name="size_bytes" type="number">Total size of the schema, in bytes.</ResponseField>
  </Expandable>
</ResponseField>

<ResponseExample>
  ```json 200 theme={null}
  { "response": [{ "name": "public", "tables_count": 8, "size_bytes": 4194304 }] }
  ```
</ResponseExample>