doctl-databases

doctl databases command [arguments] [flags]

doctl databases manages DigitalOcean Managed Databases: PostgreSQL, MySQL, Valkey (formerly Redis), MongoDB, Kafka, and OpenSearch clusters.The command provides full lifecycle management for clusters, from creation and configuration through resizing, migration, and deletion. Managed databases handle backups, minor-version updates, failover, and standby nodes for you; the CLI exposes the same operations available in the control panel, which makes them scriptable and usable from CI.Additional subcommands manage the databases inside a cluster, users, connection pools, read replicas, firewall rules, and the maintenance window. Connection strings, credentials, and the CA certificate can all be retrieved for application integration.Cluster IDs are UUIDs, but most subcommands also accept the cluster name. Add -o json to any command for machine-readable output.

list

List your database clusters.

Create a cluster. Requires --engine (`pg`, `mysql`, `redis`, `valkey`, `mongodb`, `kafka`, `opensearch`), and accepts --region, --size, --num-nodes, --version, and --private-network-uuid.

Get details for a database cluster.

Delete a cluster. -f, --force skips the confirmation prompt.

Retrieve connection details (URI, host, port, user, password).

Print the CA certificate used to verify TLS connections to the cluster.

Resize a cluster with --size and --num-nodes.

Migrate a cluster to a new region.

Create a new cluster by forking an existing one, optionally at a point in time.

List the cluster's backups.

List cluster events.

Show the engines, versions, regions, and sizes available.

View or update engine-level cluster configuration.

Schedule the automatic maintenance window.

Manage automatic storage scaling for the cluster.

Get or set the SQL modes of a MySQL cluster.

Manage the individual databases inside a cluster.

Manage database users.

Manage connection pools (PostgreSQL).

Manage read-only replicas.

Manage which resources may connect to the cluster.

Manage indexes on OpenSearch clusters.

Manage topics on Kafka clusters.

delete destroys the cluster and all of its backups; there is no undo. Managed clusters accept TLS connections only, so clients usually need the certificate from get-ca. Resizing is one-way for storage (disks can grow but not shrink) and briefly interrupts connections while nodes are replaced. Not every subcommand applies to every engine: pool is PostgreSQL-only, sql-mode is MySQL-only, topics is Kafka-only, and indexes is OpenSearch-only.

doctl(1), doctl-databases-user(1), doctl-databases-replica(1), psql(1), mysql(1)

Source code · Documentation