Ubicloud

Ubicloud Postgres Database API

Postgres Database Operations

GitHub OpenAPI

Operations 30

GET /project/{project_id}/location/{location}/postgres List PostgreSQL databases in a location #
DELETE /project/{project_id}/location/{location}/postgres/{postgres_database_reference} Delete a PostgreSQL database #
GET /project/{project_id}/location/{location}/postgres/{postgres_database_reference} Get PostgreSQL database details #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference} Create a new PostgreSQL database #
PATCH /project/{project_id}/location/{location}/postgres/{postgres_database_reference} Update a PostgreSQL database #
GET /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/backup List backups for a specific PostgreSQL database #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/backup-credentials Create temporary, read-only credentials for downloading backups directly from… #
GET /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/ca-certificates Download CA certificates for a PostgreSQL database #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/cert/add-auth-user Add provided name to list of users with certificate authentication #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/cert/create-client-keypair Create and return client certificate keypair with requested common name #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/cert/remove-auth-user Remove provided name from list of users with certificate authentication #
GET /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/config Get PostgreSQL database configuration #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/config Replace PostgreSQL database configuration #
PATCH /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/config Update PostgreSQL database configuration #
GET /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/logs Get PostgreSQL database logs #
GET /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/metrics Get PostgreSQL database metrics #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/promote Promote a PostgreSQL read replica (deprecated, use promote-read-replica) #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/promote-read-replica Promote a PostgreSQL read replica #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/read-replica Create a read replica of the PostgreSQL database #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/recycle Request primary to be recycled #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/rename Rename a PostgreSQL database #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/reset-superuser-password Reset superuser password of the PostgreSQL database #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/restart Restart a PostgreSQL database #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/restore Restore a PostgreSQL database #
GET /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/servers List servers for a specific PostgreSQL database #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/set-maintenance-window Set maintenance window for the PostgreSQL database #
POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/upgrade Upgrade a PostgreSQL database to the next major version #
GET /project/{project_id}/location/{location}/postgres/{postgres_database_reference}/upgrade Get PostgreSQL database upgrade status #
GET /project/{project_id}/postgres List all PostgreSQL databases #
GET /project/{project_id}/postgres/capabilities Get available PostgreSQL provisioning options #

Documentation

📖
Documentation
https://www.ubicloud.com/docs/api-reference/overview

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/ubicloud/refs/heads/main/openapi/ubicloud-postgres-database-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/ubicloud/refs/heads/main/json-schema/ubicloud-postgres-capabilities-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/ubicloud/refs/heads/main/json-schema/ubicloud-firewall-rule-update-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/ubicloud/refs/heads/main/json-schema/ubicloud-postgres-config-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/ubicloud/refs/heads/main/json-schema/ubicloud-postgres-patch-config-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/ubicloud/refs/heads/main/json-schema/ubicloud-ssh-public-key-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/ubicloud/refs/heads/main/json-schema/ubicloud-ssh-public-key-update-schema.json

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/ubicloud:ubicloud-postgres-database-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

ubicloud-postgres-database-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Ubicloud Postgres Database API
  version: 0.1.0
  contact:
    url: https://www.ubicloud.com/
    email: support@ubicloud.com
  license:
    name: GNU Affero General Public License v3.0 (AGPL-3.0)
    url: https://www.gnu.org/licenses/agpl-3.0.en.html
  description: 'Operations tagged Postgres Database across 2 of this provider''s published API definitions: ubicloud-openapi.yml, ubicloud-openapi.yml. Each path carries the servers of the definition it was published in.'
servers:
- url: https://api.ubicloud.com
security:
- BearerAuth: []
tags:


# --- truncated at 32 KB (51 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/ubicloud/refs/heads/main/openapi/ubicloud-postgres-database-api-openapi.yml