---
title: "Get database"
method: GET
path: "/database/show/{database_name}"
tags: ["Databases"]
---

# Get database

`GET /database/show/{database_name}`

Retrieves a specified database.

## Path parameters

- `database_name` Name, required — unresolved $ref

## Query parameters

- `require_permissions` string

## Response `200`

OK

- Database — Database
  - `count` integer, required — ???
  - `created_at` string, required — Datetime in custom format (`2020-12-31 11:22:33 -0500` or `2020-12-31 11:22:33 UTC` for UTC)
  - `delete_protected` boolean, required — wheter the database is delete protected
  - `datatank` boolean
  - `id` string
  - `name` string, required — database name
  - `organization` string, nullable, required — the organization
  - `permission` string, nullable, required — permissions
  - `database_permissions` object — permissions
    - `edit` boolean — edit permission for database
    - `delete` boolean — delete permission for database
    - `query` boolean — query permission for database
    - `import` boolean — import permission for database
    - `download` boolean — download permission for database
  - `updated_at` string, required — Datetime in custom format (`2020-12-31 11:22:33 -0500` or `2020-12-31 11:22:33 UTC` for UTC)

---

[API](https://skmtc.net/treasure/apis/treasure-data-api.md) · [All operations](https://skmtc.net/treasure/apis/treasure-data-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/treasure/treasure-data-api/revisions/a753ea35d9dd/schema)