Yes, connections are automatically released after a query. In fact, pool.query() is a shortcut for pool.getConnection() + connection.query() + connection.release() .

Regarding transactions, this issue may be relevant but you may want to ask their community about your specific case.