---
title: "List databases"
method: GET
path: "/spaces/{space_id}/databases"
---

# List databases

`GET /spaces/{space_id}/databases`

Lists all databases in a space.

## Path parameters

- `space_id` string, required

## Response `200`

List of databases

- DatabaseWithUsage[]
  - `id` string, required — Database ID.
  - `name` string, required — Database name. Unique within the space.
  - `type` 'standard' | 'dedicated', required — Database deployment model. - `standard` — shared-resource databases subject to the space's compute and storage limits. - `dedicated` — per-instance paid databases with guaranteed resources, exempt from space-level auto-pause.
  - `size` '1x' | '2x' | '4x' | '8x' — Compute size for dedicated databases. Each step up allocates proportionally more vCPU and RAM.
  - `status` 'queued' | 'configuring' | 'running' | 'pausing' | 'paused' | 'resuming' | 'deleting' | 'deleted' | 'upgrading' | 'unstable' | 'unknown', required — Current lifecycle status of the database.
  - `host` string, required — PostgreSQL hostname for connections.
  - `port` integer, required — PostgreSQL port for connections.
  - `password` string, nullable — PostgreSQL password for the default user. Returned on every GET for authorized callers.
  - `storage_mib` integer, nullable — Current disk usage in MiB. Null if not yet available.
  - `compute_minutes` integer, nullable — Compute minutes used by this database during the current billing cycle. Only populated for `standard` databases.

## Other responses

- `default` — Error response

## Changes

- **2026-08-11** `42816b90d8d6` — 1 warning
  - added the new `signups_disabled` enum value to the `code` response property for the response status `default`
- **2026-06-23** `d0e78bae6ce1` — 1 warning
  - added the new `compute_limit_exceeded` enum value to the `code` response property for the response status `default`
- **2026-06-22** `bdf92f48aec1` — 1 info
  - added the optional property `code` to the response with the `default` status
- **2026-05-04** `9a3d6f2f9f9f` — 7 breaking, 3 warning, 1 info
  - the `items/` response's property type/format changed from `object`/`` to ``/`` for status `200`
  - removed the required property `items/host` from the response with the `200` status
  - removed the required property `items/id` from the response with the `200` status
  - removed the required property `items/name` from the response with the `200` status
  - …7 more
- **2026-04-17** `a7becb6668ec` — 1 breaking, 1 warning, 10 info
  - the `items/` response's property type/format changed from ``/`` to `object`/`` for status `200`
  - removed the optional property `code` from the response with the `default` status
  - added the optional property `items/password` to the response with the `200` status
  - added the optional property `items/size` to the response with the `200` status
  - …8 more

[Change history](https://skmtc.dev/timescale/apis/ghost-api/changes/spaces/:space_id/databases/get.md)

---

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