---
title: "List databases"
method: GET
path: "/workspace/sql/databases"
tags: ["SQL"]
---

# List databases

`GET /workspace/sql/databases`

List all databases owned by your account.

## Query parameters

- `active` boolean
- `created_at__gte` string, date-time
- `created_at__lte` string, date-time
- `fields` string
- `id` integer
- `last_editor` string
- `name` string
- `ordering` string
- `page` integer
- `page_size` integer
- `search` string
- `status` string
- `updated_at__gte` string, date-time
- `updated_at__lte` string, date-time

## Response `200`

List of databases retrieved successfully.

- PaginatedDatabaseDetailList
  - `count` integer — Total number of items
  - `total_pages` integer — Total number of pages
  - `page` integer — Current page number
  - `page_size` integer — Number of items per page
  - `next` string, uri, nullable — URL to the next page of results
  - `previous` string, uri, nullable — URL to the previous page of results
  - `results` DatabaseDetail[]
    - `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)