database

List databases

Returns a list of all available Managed Database services. Depending on their database type, Managed Databases services will have different details.

get/1.3/database

Request

  • Base URL: https://api.upcloud.com
  • URL: https://api.upcloud.com/1.3/database
  • Auth: HTTP bearer

Query parameters

limitinteger

Schema for a query parameter specifying the maximum number of entries to return (limit).

Example:10

Number of entries to receive at most.

offsetinteger

Schema for a query parameter specifying the offset for pagination.

Offset for retrieved results.

sort'created_at' | '-created_at' | 'name' | '-name' | 'operational_state' | '-operational_state' | 'zone' | '-zone'

Schema for a query parameter specifying the sort field and direction. Prefix with '-' for descending order.

Example:-created_at

Sort results by the specified field. Prefix with '-' for descending order. Supported fields: created_at, name (service hostname), operational_state (service status), zone (location).

Response

OK

uuidstring uuid

The unique identifier for the service.

zonestring

The zone where the service is hosted.

namestring

The name of the service.

titlestring

The title of the service.

typestring

The type of the service.

planstring

The plan of the service. For componentised (rdb.*) plans this is the effective plan name: the storage segment shows the total storage per node the service is configured with, and the same name is accepted back on create, modify and clone.

additional_disk_space_gibinteger

The additional disk space allocated to the service in GiB. Always 0 for componentised (rdb.*) plans, where storage is expressed only as the total in the plan name and in plan_components.

statestring

The current state of the service.

state_errorobject

A map of errors related to the service state.

poweredboolean

Indicates whether the service is powered on.

termination_protectionboolean

Indicates whether termination protection is enabled for the service.

node_countinteger

The number of nodes in the service.

create_timestring date-time

The time when the service was created.

update_timestring date-time

The time when the service was last updated.

service_uristring uri

The URI for accessing the service.

service_uri_paramsobject

A map of connection parameters for the service.

metadataobject

A map of metadata key-value pairs for the service.

propertiesobject

A map of additional properties for the service.

Example response

[
  {
    "uuid": "123e4567-e89b-12d3-a456-426614174000",
    "zone": "fi-hel1",
    "name": "my-db",
    "type": "pg"
  }
]

Changes

No recorded changes to this operation across all 1 revision of this API.