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

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

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

Returns a list of Tables for the given Database `id` and `schema`.

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

## Path parameters

- `id` integer, required
- `schema` string, required

## Query parameters

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

## Response `2XX`

Successful response

## Other responses

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

## Changes

- **2026-05-22** `b1dc4ea67567` — 1 info
  - added the new optional `query` request parameter `include_measures`
- **2026-03-09** `78297d193ca4` — 1 info
  - api operation id `get-api-database-id-schema-schema` was added
- **2026-01-20** `bd1deee7eae2` — 2 info
  - added the new optional `query` request parameter `can-query`
  - added the new optional `query` request parameter `can-write-metadata`

[Change history](https://skmtc.dev/metabase/apis/metabase-api/changes/api/database/:id/schema/:schema/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)