---
title: "GET /api/database/{id}/schemas"
method: GET
path: "/api/database/{id}/schemas"
tags: ["/api/database"]
---

# GET /api/database/{id}/schemas

`GET /api/database/{id}/schemas`

Returns a list of all the schemas with tables found for the database `id`. Excludes schemas with no tables.

  Optional filters:
  - `can-query=true` - filter to only schemas containing tables the user can query
  - `can-write-metadata=true` - filter to only schemas containing tables the user can edit metadata for

## Path parameters

- `id` integer, required

## Query parameters

- `include_editable_data_model` boolean, nullable, required
- `include_hidden` boolean, nullable, required
- `can-query` boolean, nullable
- `can-write-metadata` boolean, nullable

## Response `2XX`

Successful response

- string[]

## Other responses

- `4XX` — Client error response
- `5XX` — Server error response

## Changes

- **2026-05-22** `b1dc4ea67567` — 1 warning
  - deleted the `query` request parameter `include_workspace`
- **2026-03-09** `78297d193ca4` — 1 breaking, 1 info
  - added the new required `query` request parameter `include_workspace`
  - api operation id `get-api-database-id-schemas` was added
- **2026-01-20** `bd1deee7eae2` — 3 info
  - added the new optional `query` request parameter `can-query`
  - added the new optional `query` request parameter `can-write-metadata`
  - added the media type `application/json` for the response with the status `2XX`

[Change history](https://skmtc.dev/metabase/apis/metabase-api/changes/api/database/:id/schemas/get.md)

---

[API](https://skmtc.dev/metabase/apis/metabase-api.md) · [All operations](https://skmtc.dev/metabase/apis/metabase-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/metabase/metabase-api/revisions/b1dc4ea67567/schema)