r/DatabaseAdministators • u/Existing_Practice783 • Sep 17 '26
AI Agent for DBA Automation — Has Anyone Built Something Similar?
Title:
Hi everyone,
I’m currently working as a DBA trainee/fresher, and I’m working on a project to build an AI agent for Database Administration using local LLMs.
The idea is to have an agent that can help a DBA perform multiple daily tasks through a single natural-language prompt, while keeping a human in the loop for sensitive operations.
I’m currently running Ollama locally on our own hardware, completely offline, so database/server information does not need to be sent to an external cloud service.
The agent I’m planning should eventually be able to work with things like:
- Oracle 19c
- MySQL
- PostgreSQL
- MariaDB
- Linux/RHEL
- VAPT/security scanning
- OpenSCAP/SCAP
- SQL queries
- Database configuration and health checks
- System information gathering
- Security and compliance checks
- Remediation
- Installation/configuration
- Troubleshooting
For example, the DBA could give a prompt like:
«“Check this server and database for security and configuration issues, identify the problems, explain them, suggest remediation steps, and ask for my approval before making any changes.”»
The agent would then:
Gather system and database information.
Decide which tools/commands/SQL queries are required.
Execute approved diagnostic tools.
Analyze the results using the local LLM.
Explain the findings and suggested remediation.
Ask for human approval where required.
Execute the approved remediation.
Verify whether the remediation was successful.
I’m not planning to train an LLM from scratch. I’m more interested in combining a capable local model with DBA knowledge/documentation, tool calling, database-specific utilities, and a controlled execution layer.
My main questions are:
Has anyone built something similar for DBA/Database Operations?
Are there existing open-source projects, research papers, or commercial tools doing this?
Which local LLMs would you recommend for reliable tool calling and technical reasoning?
What would be a good architecture for an AI DBA agent that can safely execute commands and SQL?
How are people handling permissions, validation, rollback, auditing, and human approval for potentially destructive operations?
I’m especially interested in learning from people who have actually implemented AI agents around databases rather than just using an LLM as a chatbot.
If you've worked on something similar, I'd really appreciate any projects, papers, tools, architectures, or experiences you can share.
Thanks!




