Feature request: Database administration

[imajus]

🚀 Feature Request

I was wondering if the tool could allow to administrate the database instances.

My use case is that I have to manage multiple various database instances (PostgreSQL, MySQL, MongoDB, Redis), so I want to reduce the technical burden by relying on an AI assistant to execute my intents.

🌟 Description

I may suggest to implement it the way it would work the best in my head:

1. Introduce a new toggle in the connection "Settings" tab to activate "Database Administration".

   

2. When the setting is activated, enable database administration actions like databases/users management via the chat UI.

🔗 Relevant Links

Original discussion: #57

📌 Additional Context

I believe to implement that, you'll need to create appropriate tools for each database in the backend. The initial minimal set of such tools could be as follows:

1. UserCreate(username: string, password?: string)
2. UserDelete(username: string)
3. UserUpdateAccess(username: string, database: string, granted: boolean)
4. UserUpdatePassword(username: string, password: string)
5. DatabaseCreate(name: string)
6. DatabaseDelete(name: string)

[bhaskarblur]

Hi @imajus
Thanks for raising this feature request.
We will work on this, either me or some contributor can pick this soon.