---
title: "List all PostgreSQL databases"
method: GET
path: "/project/{project_id}/postgres"
tags: ["Postgres Database"]
---

# List all PostgreSQL databases

`GET /project/{project_id}/postgres`

## Path parameters

- `project_id` string, required

## Query parameters

- `tags` string
- `start_after` string
- `page_size` integer
- `order_column` string

## Response `200`

A list of Postgres Databases

- object
  - `count` integer, required
  - `items` PostgresDatabase[], required
    - `flavor` string, required — Kind of Postgres database
    - `ha_type` string, required — High availability type
    - `target_server_count` integer, required — Target number of servers (primary + standbys)
    - `id` string, required — ID of the Postgres database
    - `location` string, required — Location of the Postgres database
    - `name` string, required — Name of the Postgres database
    - `state` string, required — State of the Postgres database
    - `storage_size_gib` integer, required — Storage size in GiB
    - `target_storage_size_gib` integer — Desired storage size in GiB
    - `version` '16' | '17' | '18', required — Current Postgres version
    - `target_version` '16' | '17' | '18', required — Target Postgres version
    - `vm_size` string, required — Size of the underlying VM
    - `target_vm_size` string — Desired VM size
    - `ca_certificates` string, nullable — CA certificates of the root CA used to issue postgres server certificates
    - `maintenance_window_start_at` integer, nullable, required — Maintenance window start time
    - `maintenance_window_days` MaintenanceWindowDay[] — Days of the week the maintenance window applies to (empty list means every day)
    - `read_replica` boolean, required — If the database is a read replica or not
    - `parent` string, nullable — Parent Postgres database
    - `fallback_active` boolean, required — Whether the primary server is running on a fallback instance type
    - `tags` PostgresTag[], required — Tags of the Postgres database
      - `key` string, required — Key of the Postgres tag
      - `value` string, required — Value of the Postgres tag
    - `created_at` string, date-time, required — Creation timestamp of the Postgres database

## Other responses

- `default` — An error response

## Changes

> 59 revisions in range; 8 could not be searched.

- **2026-07-14** `0d2405af1fd7` — 1 info
  - added the optional property `items/items/maintenance_window_days` to the response with the `200` status
- **2026-05-22** `576c50424941` — 1 info
  - added the required property `items/items/fallback_active` to the response with the `200` status
- **2026-04-09** `e483b6781a6d` — 1 info
  - added the required property `items/items/target_server_count` to the response with the `200` status
- **2026-03-30** `438e71431435` — 6 warning
  - added the new `16` enum value to the `items/items/target_version` response property for the response status `200`
  - added the new `16` enum value to the `items/items/version` response property for the response status `200`
  - added the new `17` enum value to the `items/items/target_version` response property for the response status `200`
  - added the new `17` enum value to the `items/items/version` response property for the response status `200`
  - …2 more
- **2026-01-08** `9f8883d5bee5` — 1 info
  - added the required property `items/items/created_at` to the response with the `200` status

[Full history](https://skmtc.dev/ubicloud/apis/clover-api/changes/project/:project_id/postgres/get.md)

---

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