---
title: "Retrieve details from a database"
method: GET
path: "/workspace/sql/databases/{database_id}"
tags: ["SQL"]
---

# Retrieve details from a database

`GET /workspace/sql/databases/{database_id}`

Retrieve details from a specific database in your account.

## Path parameters

- `database_id` integer, required

## Query parameters

- `fields` string

## Response `200`

Database details retrieved successfully.

- DatabaseDetailResponse
  - `state` string
  - `data` DatabaseDetail, required — Detailed database representation with extended status information.
    - `id` integer, required — Unique identifier for the database
    - `name` string, required — Name of the database
    - `status` 'creating' | 'created' | 'deleting', required — Current status of the database * `creating` - creating * `created` - created * `deleting` - deleting
    - `active` boolean — Whether the database is active
    - `last_modified` string, date-time, required — Last modification timestamp
    - `last_editor` string, nullable, required — Last editor of the schema.
    - `product_version` string, required — Product version

## Other responses

- `400` — Validation Error
- `401` — Authentication Failed
- `403` — Permission Denied
- `404` — Not Found
- `405` — Method Not Allowed
- `406` — Not Acceptable
- `429` — Throttled
- `500` — Internal Server Error

---

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