Appwrite

Appwrite PostgreSQL API

Managed PostgreSQL hosting with pgvector, Prisma support, backups, replicas and point-in-time recovery. 37 operations across 25 paths in the Appwrite 2.0.0 OpenAPI.

GitHub OpenAPI

Operations 37

GET /postgresql List databases #
POST /postgresql Create database #
GET /postgresql/specifications List specifications #
GET /postgresql/{databaseId} Get database #
PATCH /postgresql/{databaseId} Update database #
DELETE /postgresql/{databaseId} Delete database #
GET /postgresql/{databaseId}/backups List backups #
POST /postgresql/{databaseId}/backups Create backup #
GET /postgresql/{databaseId}/backups/policies List backup policies #
POST /postgresql/{databaseId}/backups/policies Create backup policy #
GET /postgresql/{databaseId}/backups/policies/{policyId} Get backup policy #
PATCH /postgresql/{databaseId}/backups/policies/{policyId} Update backup policy #
DELETE /postgresql/{databaseId}/backups/policies/{policyId} Delete backup policy #
PUT /postgresql/{databaseId}/backups/storage Update backup storage #
GET /postgresql/{databaseId}/backups/{backupId} Get backup #
DELETE /postgresql/{databaseId}/backups/{backupId} Delete backup #
GET /postgresql/{databaseId}/branches List branches #
POST /postgresql/{databaseId}/branches Create branch #
DELETE /postgresql/{databaseId}/branches/{branchId} Delete branch #
PATCH /postgresql/{databaseId}/credentials Update credentials #
POST /postgresql/{databaseId}/executions Create execution #
GET /postgresql/{databaseId}/extensions List extensions #
POST /postgresql/{databaseId}/extensions Create extension #
DELETE /postgresql/{databaseId}/extensions/{extensionName} Delete extension #
POST /postgresql/{databaseId}/failovers Create failover #
PATCH /postgresql/{databaseId}/maintenance Update maintenance #
POST /postgresql/{databaseId}/migrations Create migration #
GET /postgresql/{databaseId}/operations List operations #
GET /postgresql/{databaseId}/pitr Get PITR #
GET /postgresql/{databaseId}/pooler Get pooler #
PATCH /postgresql/{databaseId}/pooler Update pooler #
GET /postgresql/{databaseId}/replicas Get replicas #
GET /postgresql/{databaseId}/restorations List restorations #
POST /postgresql/{databaseId}/restorations Create restoration #
GET /postgresql/{databaseId}/restorations/{restorationId} Get restoration #
GET /postgresql/{databaseId}/status Get status #
POST /postgresql/{databaseId}/upgrades Create upgrade #

Documentation

📖
Documentation
https://appwrite.io/docs
📖
APIReference
https://appwrite.io/docs/references

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/appwrite/refs/heads/main/openapi/appwrite-postgresql-api-openapi.yml

SDKs

📦
GitHubRepository
https://github.com/appwrite/appwrite

Other Resources

🔗
Overlay
https://raw.githubusercontent.com/api-evangelist/appwrite/refs/heads/main/overlays/appwrite-postgresql-overlay.yaml

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/appwrite-postgresql-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

appwrite-postgresql-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  version: 2.0.0
  title: Appwrite Postgresql API
  description: Appwrite backend as a service cuts up to 70% of the time and costs required for building a modern application. We abstract and simplify common development tasks behind a REST APIs, to help you develop your app in a fast and secure way. For full API documentation and tutorials go to https://appwrite.io/docs
  termsOfService: https://appwrite.io/policy/terms
  contact:
    name: Appwrite Team
    url: https://appwrite.io/support
    email: team@appwrite.io
  license:
    name: BSD-3-Clause
    url: https://raw.githubusercontent.com/appwrite/appwrite/master/LICENSE
servers:
- url: https://cloud.appwrite.io/v1
  description: Appwrite Cloud endpoint.
- url: https://{region}.cloud.appwrite.io/v1
  description: Appwrite Cloud regional endpoint. Replace `{region}` with your project region.
  variables:
    region:
      default: fra
      description: Appwrite Cloud region.
tags:


# --- truncated at 32 KB (128 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/appwrite/refs/heads/main/openapi/appwrite-postgresql-api-openapi.yml