Note1: Auto opening the connection dialog when creating a worksheet seems to be an improvement but it also limits the ability to select the existing connection. e.g. In a worksheet, you create a connection then go to the "Select connection" dropdown and create a new one for the current worksheet. So now when you create another worksheet, you can select "unbind" connection in the dropdown.

Note2: If a connection is deleted, the worksheet is kept for an intentional purpose. The queries written in the worksheet can be later saved or downloaded.

Duong, I don't think so we can unbind or bind the existing connection to another work sheet.
1. Why because when we open new WORKSHEET and create a connection, then if we close the WORKSHEET then automatically connection also getting closed from the "Select connection" dropdown.
2. If a connection is already assigned to one WORKSHEET then you can't unbind and bind to another WORKSHEET.

That's why I asked for auto popup connection creation for empty WORKSHEET, it does not matter if it is a new or old WORKSHEET but it should be an empty Work Sheet. When ever we click on the empty WorkSheet then we need a auto popup for creating a new connection.

Okay. To sum up, if a worksheet is deleted, the connection bound to it is deleted. This is already implemented.
When adding a new worksheet, if there is no available connection, it will show the dialog, otherwise, the workflow is like what it is right now. Would it be something you expect it to be?

No Duong,
>> Okay. To sum up, if a worksheet is deleted, the connection bound to it is deleted. This is already implemented.
– This is fine.

1. If I don't remove Work sheet and if I directly disconnect the connection from the work sheet then the work sheet becomes empty, so again if user wants a new connection then instead of going to Select Connection list then directly show create connection or dialogue box in the empty Work Sheet. UI seems littlie tricky what I mean is it not user friendly.

We are expecting like below but it should be Popup dialogue window.

Okay, I understand your point, the user disconnects the connection via the dropdown, then you have a blank worksheet. Having a popup immediately right after disconnecting seems useful for those who want to expect that behavior, but that would be annoying if the user doesn't actually want that, right? Overall, after disconnecting the connection from the worksheet, you only have to do two actions to open the dialog. Click the dropdown, then click "New connection".

In another scenario, the user intends to create multiple connections for a worksheet. Then they can use the dropdown to switch between connections. Once they are done with a connection, they disconnect, then they select another connection from the dropdown. Having a popup right after deleting is not what they want in this case.

Duong, Either way is fine but at least whenever the user open new Work Sheet then immediate dialogue box is enough for creating a new connection. But can we implement that user can store the connections permanently, instead of creating a new connection every time is time taking process.

Yes. That is on our roadmap https://jira.mariadb.org/browse/MXS-3839

Okay Duong, thanks for the quick update. But can we expect auto dialogue window[create connection] for new WorkSheet?

Yes, that will be implemented.

Thanks Duong. Can we expect this feature in the next release, as its a major UI improvement.