Databases
Managed databases, replicas, endpoints and attachments.
Base https://api.nodion.com. Short paths need
X-Nodion-Project unless the path already has
/v2/projects/{id}.
Request bodies are in the interactive docs.
/v2/databases List databases in the current project
/v2/databases Create a database in the current project
/v2/projects/{id}/databases List databases
/v2/projects/{id}/databases Create a database
/v2/databases/{id} Get a database
Connection credentials are included only with the `db:credentials` scope (or a session / project key).
/v2/databases/{id} Upgrade the database package
/v2/databases/{id} Delete a database
/v2/databases/{id}/metrics Get database metrics
/v2/databases/{id}/engine_metrics Get database engine metrics
/v2/databases/{id}/backups List database backups and settings
/v2/databases/{id}/backups/settings Update database backup settings
/v2/databases/{id}/restore Restore a database to a new fork at a point in time
/v2/databases/{id}/browse/namespaces List schemas or databases for read-only browse
/v2/databases/{id}/browse/tables List tables and views in a namespace
/v2/databases/{id}/browse/rows Preview rows from a table (read-only)
`order` without `sort` is ignored. Invalid `sort` or `order` is 400.
/v2/databases/{id}/browse/keys SCAN keys on a Valkey database
Opaque Redis SCAN cursor in `next_cursor`. Last page has `next_cursor: null`.
/v2/databases/{id}/browse/value Preview a Valkey key value
/v2/databases/{id}/browse/query Run a SQL statement (Postgres, pgvector)
/v2/databases/{id}/insights Query stats, live sessions and unused indexes (Postgres, MySQL)
/v2/databases/{id}/containers List database containers
/v2/databases/{id}/logs/history Query historical database logs
/v2/databases/{id}/attachments Attach a database to an application
/v2/database_attachments/{id} Update a database attachment's bindings
/v2/database_attachments/{id} Detach a database from an application
/v2/databases/{id}/replicas Add a read replica
/v2/databases/{id}/ha High availability status
/v2/databases/{id}/ha Enable high availability (async standby)
/v2/databases/{id}/ha Update HA settings (auto-failover, async/sync mode)
/v2/databases/{id}/ha Disable high availability
/v2/databases/{id}/cluster ClickHouse cluster status
/v2/databases/{id}/cluster Enable a 3-node ClickHouse cluster
/v2/databases/{id}/cluster Disable the ClickHouse cluster
/v2/databases/{id}/failover Promote the HA standby (manual failover)
/v2/databases/{id}/endpoints Enable public endpoints
/v2/databases/{id}/endpoints Disable public endpoints
/v2/databases/{id}/allowed_cidrs Set the source-IP allowlist for public endpoints
/v2/databases/{id}/pooler Enable the connection pooler
/v2/databases/{id}/pooler Disable the connection pooler
/v2/databases/{id}/pooler/endpoint Enable public access to the connection pooler
/v2/databases/{id}/pooler/endpoint Disable public access to the connection pooler
/v2/databases/{id}/pooler/allowed_cidrs Set the source-IP allowlist for the public pooler
/v2/database_nodes/{id} Delete a database node (replica)
/v2/applications/{id}/attachments List an application's database attachments