Postgres API Reference

Every operation of the Postgres API, under /rds/api. Sign requests with an access key (Authorization: EWS-ACCESS-KEY <id>:<secret>). A successful JSON response is { "success": true, "data": … }.

instances

Managed Postgres databases, single-node or Patroni clusters

backups

pgBackRest backups and point-in-time restores

query-insights

Sampled statement history (pg_stat_statements, every minute, 7 days), findings with suggested actions, running sessions and the slow query log

data

Reading what is inside the database: its tables, rows and one read-only query

extensions

Postgres extensions per database: the supported catalog, what is enabled, and the switches

server-types

The instance classes a database can be created with

ca-bundle

The platform CA that signs every database server certificate

tls

Whether a database refuses clients that do not use TLS, and which clients would break

replication

Whether a cluster commits synchronously (a failover loses nothing acknowledged) or asynchronously

replication-slots

Logical replication slots for CDC (Debezium, Airbyte) and subscriptions; declared ones survive a failover

branches

Copy-on-write branches of a database: masked, seconds to create, one per pull request

logins

Per-person Postgres logins: read-only or read-write roles whose passwords are filed in Secrets

Generated from the API description, the same one the API checks requests against and the CLI is built from.