---
title: "Get available PostgreSQL provisioning options"
method: GET
path: "/project/{project_id}/postgres/capabilities"
tags: ["Postgres Database"]
---

# Get available PostgreSQL provisioning options

`GET /project/{project_id}/postgres/capabilities`

Returns a tree of valid option combinations for creating PostgreSQL databases, along with metadata describing each option value. The tree encodes dependency chains (e.g. which VM families are available per location, which storage sizes are valid per VM size).

## Response `200`

PostgreSQL capabilities tree and metadata

- PostgresCapabilities — Tree of valid option combinations and metadata for each option value. The option_tree encodes parent-child dependencies: traverse from flavor -> location -> family -> size -> storage_size -> ha_type (with version branching from flavor). Only combinations present in the tree are valid for provisioning.
  - `option_tree` object, required — Nested object where each level maps option values to their valid children.
  - `metadata` object, required — Display info for option values referenced in the tree
    - `flavor` object, required
    - `location` object, required
    - `family` object, required
    - `size` object, required
    - `ha_type` object, required

## Other responses

- `default` — An error response

---

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