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

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

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

Return a list of Tables for a Database whose `schema` is `nil` or an empty string.

  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

## 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

---

[API](https://skmtc.net/metabase/apis/metabase-api.md) · [All operations](https://skmtc.net/metabase/apis/metabase-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/metabase/metabase-api/versions/08b5a2bafb4f/schema)