database
Managed database SKUs.
Primary key: vendor_id, database_id. See the version history of this table on dbdocs.io.
Columns
| Column | Type | Constraints | References | Description |
|---|---|---|---|---|
vendor_id | VARCHAR(255) | PK | vendor.vendor_id | Reference to the Vendor. |
database_id | VARCHAR(255) | PK | Unique identifier, as called at the Vendor. | |
name | VARCHAR(255) | NOT NULL | Human-friendly name. | |
api_reference | VARCHAR(255) | NOT NULL | How this resource is referenced in the vendor API calls. This is usually either the id or name of the resource, depending on the vendor and actual API endpoint. | |
api_reference_object | JSON | How this resource is referenced in the vendor API calls, including the parameter name(s). | ||
display_name | VARCHAR(255) | NOT NULL | Human-friendly reference (usually the id or name) of the resource. | |
description | VARCHAR(255) | Short description. | ||
family | VARCHAR(255) | Hardware family or class classification. | ||
server_id | VARCHAR(255) | Reference to the underlying cloud server''s identifier. | ||
vcpus | INTEGER | Number of virtual CPU cores allocated to the database server instance. | ||
memory_amount | INTEGER | Amount of RAM (MiB) provisioned for the instance. | ||
engine | ENUM | Managed database engine running on the instance. See DatabaseEngine for the possible values. | ||
wire_protocol | ENUM | Network protocol used for client connections. See DatabaseWireProtocol for the possible values. | ||
engine_versions | JSON | NOT NULL | Major database engine versions supported. | |
auto_upgrade_versions | BOOL | Auto-upgrade between minor database engine versions. | ||
ha | JSON | NOT NULL | Ordered HA levels supported, highest tier first. | |
ha_strategy | JSON | NOT NULL | Ordered HA strategies supported, highest tier first. | |
max_read_replicas | INTEGER | Maximum number of read-only replica nodes supported to scale read workloads. | ||
custom_config | BOOL | Whether database engine parameters/flags can be customized. | ||
custom_extensions | BOOL | Support for custom database engine extensions/plugins. | ||
storage_size | INTEGER | Bundled storage capacity included in the database (GB). | ||
storage_extra_min | INTEGER | Minimum custom storage size (in GB) that can be attached to the instance. | ||
storage_extra_max | INTEGER | Maximum storage limit (in GB) supported by the instance or storage tier. | ||
storage_extra_autosize | BOOL | Whether storage capacity can automatically expand as disk usage grows. | ||
disk_encryption | BOOL | Indicates whether underlying storage drives are encrypted at rest. | ||
scheduled_backups | BOOL | Support for automated snapshot schedules and backup retention management. | ||
continuous_backups | INTEGER | Maximum point-in-time recovery (PITR) log retention window expressed in days (0 if unsupported). | ||
connection_pool | BOOL | Managed connection proxy support. | ||
system_monitoring | BOOL | Availability of host-level CPU, RAM, and disk metrics dashboards. | ||
database_monitoring | BOOL | Database engine performance insights (slow queries, locks, execution plans). | ||
autotuning_advice | BOOL | Analyzes workload and generates actionable performance tuning advice. | ||
autotuning_apply | BOOL | System automatically executes performance fixes (e.g., index creation, parameter tuning) without operator intervention. | ||
sla | FLOAT | Service level agreement as a percentage, e.g. 99.95. | ||
security_features | JSON | NOT NULL | Security capabilities supported by DBaaS providers. | |
status | ENUM | NOT NULL | Status of the resource (active or inactive). See Status for the possible values. | |
observed_at | DATETIME | NOT NULL | Timestamp of the last observation. |
Foreign keys
vendor_id→vendor(vendor_id)
Enums
DatabaseEngine
Managed database engine.
| Value | Description |
|---|---|
POSTGRESQL | PostgreSQL. |
DatabaseWireProtocol
Wire protocol for a managed database type.
| Value | Description |
|---|---|
POSTGRESQL | PostgreSQL. |
Status
Last known status of a resource, e.g. active or inactive.
| Value | Description |
|---|---|
ACTIVE | Active and available resource. |
INACTIVE | Unavailable. For Server/Database: temporary or unknown cause. |
PLANNED_FOR_RETIREMENT | Planned for retirement; only valid for Server and Database. |
RETIRED | Not orderable anymore, but prices may still exist (e.g. active multi-year contracts). Only valid for Server and Database. |