doctl-databases-pool

List connection pools

$ doctl databases pool list [cluster_id]

$ doctl databases pool create [cluster_id] [pool_name] --db [database] --user [user] --size [10]

$ doctl databases pool get [cluster_id] [pool_name]

$ doctl databases pool delete [cluster_id] [pool_name]

doctl databases pool command [options]

doctl databases pool manages connection pools for PostgreSQL managed databases on DigitalOcean. Connection pools provide connection multiplexing, significantly improving performance for applications with many concurrent clients.
Pools act as intermediaries between applications and the database, maintaining a set number of reusable database connections. This reduces overhead from repeatedly opening and closing connections. Pool modes determine connection behavior: transaction mode (fastest for stateless queries), session mode (preserves server-side session state), and statement mode (most compatible but least efficient).
Proper pool configuration balances performance with resource usage, especially important for applications with high connection counts or intermittent traffic patterns.

--db string

Database name.

Username.

Pool size (number of connections).

Pool mode (transaction, session, statement).

list

List connection pools.

Create a connection pool.

Get pool details.

Delete a connection pool.

doctl-databases(1), doctl-databases-user(1)