Two level panels in dBeaver Editor to organize existing sql files / opened sql files

[pistata112]

I usually work with about ~6 databases. For each database, I have 2-5 prepared SQL files open in DBeaver. It's a bit difficult to find the correct file because:

The pane displays "database name + file name", but with so many open files, it's often shortened to "database name...".
If I exceed a certain limit, some files aren't shown at all; there's just an arrow at the end of the pane with a list of open files.

Is there any way to aggregate the files by database connection while still being able to view them in full screen? For example:

• Manage them in the left-side panel in a "Files navigator" similar to the "Database Navigator".
• Or have two-level panes: the upper one for database connections and the lower one for SQL files (SQL editors) open under that connection.

Ideally, it would be great to have features like these (if they aren't already available):

• Organize files in a tree structure.
• Prepare collections of available files.
• See which files are already open and which are not.
• Open a file by clicking on an element in the tree with the connection configured for that element, or open the pane if it's already open.
• Save the current setup.
• ...

Thanks for your response,
Maki

[TB-HunBoka]

About having many open tabs:
This feature is a long-time existing thing on the plate of Eclipse (DBeaver is built on Eclipse and inherit it's functionality).
This was opened back in 2004! And still an active issue on the bug report: https://bugs.eclipse.org/bugs/show_bug.cgi?id=58945

Previously I used the little arrow at the end of the tabs and started typing what I am looking for, but it is currently not searchable, but it will work in the 24.3.5 I think.
So, I am having 20+ tabs open all the time.

Until that:
I found a living code that provides a workaround to this issue. You need to install the https://marketplace.eclipse.org/content/vertical-tabs#details on your DBeaver and this will give you a new tab called Vertical Tabs. You can move this tab freely and even detach, group by project automatically, or manually by drag and drop.
Actually, it is pretty handy, and I might keep this tool for long time use.

About organize files, I was not searching for any tools for that, I manually create folders for my scripts.

[TB-HunBoka]

You can play with the Create script folders and Create script folder for each connection options:

If this is something you are looking for.