Sign in
Databases

Get database details

Changed on
get/projects/{id}/databases/{databaseName}

Request

  • Base URL: https://api.volcano.dev
  • URL: https://api.volcano.dev/projects/{id}/databases/{databaseName}
  • Auth: one of:
    • HTTP bearer
    • HTTP bearer

Path parameters

idstring uuid required

Project ID

databaseNamestring required

Database name (unique within project, lowercase letters, numbers, and underscores only)

Response

Successful response

idstring uuid required
project_idstring uuid required
namestring required

Database name

status'provisioning' | 'active' | 'failed' | 'restoring' | 'deleting' required

Database status. restoring means a restore is replacing the database's data: it does not accept connections, and the operations that would race the restore are rejected until it finishes. Its branches keep serving throughout.

provisioning_started_atstring date-time

Timestamp when the current provisioning phase started

connection_stringstring

Secure PostgreSQL connection URI for your database.

The database is identified by the globally-unique username (volcano_client_{database_id}) already in this URI; the application_name parameter only selects the access mode:

  • volcano_full_access — Full admin access (DDL, migrations)
  • volcano_user_access:{user_id} — User impersonation (RLS enforced)
  • volcano_user_access — Anonymous access (anon role, RLS enforced)
regionstring

Region where the database is hosted

pg_versionstring

PostgreSQL major version

database_type'volcano-db-xs' | 'volcano-db-s' | 'volcano-db-m' | 'volcano-db-l' | 'volcano-db-xl' | 'volcano-db-2xl'

Database size tier that determines available RAM and scaling limits.

storage_bytesinteger

Latest observed storage for this database, in bytes: its own on-disk size, plus what each branch has diverged from it, plus what its backups cost to hold. This is the figure the storage allowance is enforced against, and the stats endpoint breaks it down. A point-in-time gauge recorded by a background pass, so it may be absent until the database has been sampled, and it can trail the stats endpoint's current_storage_bytes, which measures on request. Summing the latest samples for every database in a project produces the project's "Database Storage (Bytes)" usage gauge. Populated on database list responses; single-database responses omit it.

last_invoked_atstring date-time

Most recent request timestamp for this database

created_atstring date-time required
updated_atstring date-time required

Example response

{
  "region": "us-east-1",
  "pg_version": "18",
  "database_type": "volcano-db-xs"
}

Changes

  • 23e7875e7c4cRevision changes
    • ○

      the endpoint scheme security ProjectAccessToken was added to the API

  • 3a6f365f3f35Revision changes
    • ▲

      added the new path request parameter databaseName

    • ▲

      added the new path request parameter id

    • ▲

      the response's body type changed from no type to object for status

    • ○

      added the optional property to the response with the status

    • ○

      added the optional property to the response with the status

    • ○

      added the optional property to the response with the status

    • ○

      added the optional property to the response with the status

    • ○

      added the optional property to the response with the status

    • ○

      added the optional property to the response with the status

    • ○

      added the optional property to the response with the status

    • ○

      added the required property to the response with the status

    • ○

      added the required property to the response with the status

    • ○

      added the required property to the response with the status

    • ○

      added the required property to the response with the status

    • ○

      added the required property to the response with the status

    • ○

      added the required property to the response with the status