r/DatabaseAdministators • • Sep 17 '26

AI Agent for DBA Automation — Has Anyone Built Something Similar?

0 Upvotes

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:

  1. Gather system and database information.

  2. Decide which tools/commands/SQL queries are required.

  3. Execute approved diagnostic tools.

  4. Analyze the results using the local LLM.

  5. Explain the findings and suggested remediation.

  6. Ask for human approval where required.

  7. Execute the approved remediation.

  8. 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:

  1. Has anyone built something similar for DBA/Database Operations?

  2. Are there existing open-source projects, research papers, or commercial tools doing this?

  3. Which local LLMs would you recommend for reliable tool calling and technical reasoning?

  4. What would be a good architecture for an AI DBA agent that can safely execute commands and SQL?

  5. 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!


r/DatabaseAdministators • • Oct 02 '26

I am a 50-year-old veteran building an AgTech Startup from a laptop in Slovenia. My son runs cross-border tests from Germany. Rate our 66-table database architecture for the EU Honey Directive.

0 Upvotes

Hi everyone,

I am Serhii, a 50-year-old veteran currently living on the Slovenian coast (Piran). I don’t speak perfect English, and I write my posts using a translator, but I’ve spent months bootstrapping AgroNode & The Bee Temple Project (The Biosphere’s Digital Twin Operating System).

Recently, I hit a heavy solo sprint. Primorski tehnološki park rejected me due to the language barrier, but I am not stopping. With the support of my colleague Edi, I officially acquired our enterprise data domain: agronodedata🚀

But right now, I have hit a critical bottleneck: My solo free-tier accounts and service infrastructure limits are completely exhausted. I literally cannot deploy, host, or test the system further on my own without funding, upgraded tiers, or team resources.

Where the project stands right now:

- The Backend: 66 Supabase tables with strict Row-Level Security (RLS) and PostGIS. My son just ran a live cross-border test from Germany, and it worked flawlessly for EU Honey Directive 2024/1438 compliance.

- The UI: Hard-coded 5 new mobile framework screens and successfully configured Google Authentication live.

- Institutional Track: Applications submitted to Inkubator Sežana, LUI, and Technology Park Ljubljana. But while we wait for their months-long bureaucratic evaluations, the technical limits are blocking me today.

I cannot let this project freeze inside my laptop just because of exhausted service limits. I am actively looking for:

  1. A Technical Partner / Co-Founder who understands deep-tech, database scalability, and wants to share the deployment infrastructure.

  2. Backers and Advice on how to upgrade our tiers so I can keep the live terminal running.

Since Reddit filters block links for new accounts, all links to my professional LinkedIn profile and our BuyMeACoffee support page are placed in my Reddit profile bio. You can also ask me directly in the comments, and I will gladly share them!

Thank you for your time, your engineering feedback on our PostGIS structure, and any guidance you can provide!


r/DatabaseAdministators • • Aug 11 '26

My own DBA

0 Upvotes

I built a database IDE because I was tired of fighting my own databases

I've been working on Toketeo, a desktop database tool I've been building mostly because I wanted something that worked the way I thought it should.

It's currently built with Rust + Tauri + React, and the idea is to make working with databases less painful, especially when you're jumping between different database engines.

The project is still early, so I'm deliberately putting it in front of actual developers before I spend months polishing things nobody asked for.

I'd really like people to try it and tell me:

  • What's confusing?

  • What's missing?

  • What would make you switch from your current database tool?

  • What feature would make you say "okay, this is actually useful"?

  • And, preferably, what did I screw up?

I'm particularly interested in feedback from people who work with multiple databases or spend an unhealthy amount of time inside database clients.

GitHub: https://github.com/crdsyntax/toketeo

It's open source, so feel free to inspect the code, open issues, suggest features, submit PRs, or tell me why the architecture is terrible.

And yes, if someone ends up stealing the idea and building something better, I'll probably be slightly annoyed for approximately 15 minutes.

Then I'll steal their improvements.

Try it, break it, criticize it.

That's currently more valuable to me than another star on GitHub.


r/DatabaseAdministators • • May 11 '26

The problem isn’t that AI might break something. It’s that you didn’t have backups.

5 Upvotes

Recently there was yet another real-world case of an AI assistant generating a destructive command during a workflow.

The mistake itself wasn’t the scary part.

The problem isn’t that AI might break something. It’s that your backups weren’t usable when you needed them.

https://sqlbak.com/blog/the-problem-isnt-that-ai-might-break-something-its-that-you-didnt-have-backups/


r/DatabaseAdministators • • 15d ago

Which database is ideal??

4 Upvotes

I am working on a idea where i will click pics of agri land and store and my requirement is to store 10000 photos
Which database will be feasible and i am looking for free onces for now


r/DatabaseAdministators • • May 22 '26

I built a SQL workspace inside VS Code — saved queries, version history, data compare, session monitor

2 Upvotes

I got tired of switching between VS Code and a separate DB tool every few minutes, so I built SQLLab — a VS Code extension that puts a full SQL workspace inside the editor.

What it does:

  • Connect to SQL Server, PostgreSQL, MySQL, Oracle, SQLite, DuckDB

  • Saved query library with full-text search (search name, description, and the SQL itself)

  • Every save creates a version — diff any two versions side by side

  • Data Compare: run two queries against different DBs and see SAME/DIFFERENT per row and column

  • Session Monitor: see blocked/active sessions, kill them from right-click

  • Batch Run: run multiple saved queries in parallel, track status per script

  • Parameterised SQL with Jinja-style {{ variable }} substitution

  • Schema-aware autocomplete (tables, columns, PKs, indexes)

  • Paginated results — no freezing on large datasets

Still early, so feedback on what's missing or broken is very welcome.

main screen:


r/DatabaseAdministators • • Sep 14 '26

Found out one of my "backups" had no database in it at all — built a tool to catch this before it happens again

0 Upvotes

r/DatabaseAdministators • • Jan 19 '26

I built DataSpeak - Talk to your databases in plain English. Android app live, desktop (Windows/Linux/macOS) & iOS coming soon!

1 Upvotes

Hey everyone!

I've been working on DataSpeak, an AI-powered database client that lets you query your databases using natural language instead of writing SQL.

Download for Android: https://play.google.com/store/apps/details?id=com.dataspeak.client

What is DataSpeak?

Ask questions like "Show me all users who signed up last month" and DataSpeak converts it to SQL, runs it, and visualizes the results - no SQL knowledge required.

Key Features:

- Natural Language Queries - Ask questions in plain English, get SQL results

- Multi-Database Support - PostgreSQL, MySQL, MariaDB from one interface

- Smart Visualizations - Auto-generates charts (bar, line, pie, scatter, etc.) based on your data

- Geographic Data Support - Built-in PostGIS support with interactive maps

- Editable Data Grids - Edit, insert, delete rows directly with change tracking

- Privacy-First - Encrypted credential storage, your data never leaves your machine

- Schema Browser & ERD - Visual database exploration with auto-generated diagrams

- Import/Export - CSV and ZIP support for bulk data operations

Platforms:

- Android - Available now

- Windows - Coming soon

- Linux - Coming soon

- macOS - Coming soon

- iOS - Coming soon

I'm actively developing this and would love to hear from you. Feature requests, bug reports, or general feedback - drop a comment or DM me.

Thanks for checking it out!


r/DatabaseAdministators • • Feb 01 '26

🚀 Built a database tool that's faster than most alternatives

1 Upvotes

Frustrated with bloated DB clients eating 500MB+ RAM, I built tabularis with Rust + Tauri and React.

What makes it different:

🗺️ ER Diagrams that don't choke:

  • Rendered 150+ tables over SSH in under 2 seconds

  • Interactive graph with auto-layout

  • Batch queries

🎨 Instant theme switching:

  • 10 presets (Dracula, Monokai, Nord...)

  • Zero page reload (pure CSS variables)

  • Monaco Editor matches UI theme

🤖 AI that actually knows your schema:

  • "users who signed up last week" → generates correct SQL

  • OpenAI/Anthropic/OpenRouter

  • Keys in system Keychain, not config files

🎮 Visual Query Builder:

  • Drag tables, connect columns = auto JOINs

  • Click edges to change JOIN types

  • Real-time SQL generation

Other stuff:

  • DataGrip-style batch editing (modify → rollback)

  • SSH tunneling, parameterized queries, CSV/JSON export

  • Cross-platform (Windows/macOS/Linux)

Status: BETA, open source (Apache 2.0), available on AUR

Links: github.com/debba/tabularis | tabularis.dev


r/DatabaseAdministators • • Oct 01 '26

DBA job market – when does hiring usually pick up?

0 Upvotes

Hi everyone,

For those working in the Oracle DBA space in India, I wanted to understand how the hiring market is looking currently.

Are there usually particular months when DBA hiring increases and more job openings/calls start coming in?

I’m especially interested in knowing whether hiring tends to pick up toward the end of the year or more during the beginning of the next year.

Also, for those who are currently getting calls/interviews, are you seeing more openings for Oracle DBA / Production DBA / Cloud DBA roles?

Any insights based on your recent experience would be really helpful. Thanks!


r/DatabaseAdministators • • Aug 11 '24

Survey for Cloud Database Migration Experts

0 Upvotes

Hi everyone,

We are a group of Information Technology students from Polytechnic University of the Philippines conducting a research project on cloud database migrations. To gain valuable insights, we are seeking your expertise as a database administrators.

Due to our limited experience in the field, we believe your knowledge and experience will be instrumental in our research. Your participation in this survey will help us understand the complexities and best practices of migrating databases to the cloud.

We assure you that all information provided will be treated with strict confidentiality in accordance with the Data Privacy Act of 2012 (Republic Act No. 10173). Your responses will solely be used for academic purposes.

To participate, please click on the following link:

https://forms.gle/ozoDgRyRFgSrkdm77

Thank you for your time and support.

Full link: https://docs.google.com/forms/d/e/1FAIpQLSdWrdrtmVjqVlPNqP7HDmuvz_WLuxD0sI__2G08ruOrg7SqrQ/viewform?usp=sf_link

Most of the questions are googleable however, we are instructed to ask for industry experts. If ever the questions are too long, you can answer the last two (2) questions. (Challenges you've encountered, how did you overcome it and best practices on cloud database migrations). Our questions revolve on the following:

  1. Database migration to cloud platforms

  2. Cloud database services (AWS RDS, Azure SQL Database, GCP Cloud SQL)

  3. Cloud database performance and scalability

  4. Cloud database security

#CloudDatabase #DatabaseMigration #DatabaseAdministration #DatabaseAdministrator #AmazonWebServices #AWS #GoogleCloudPlatform #IBM #MicrosoftAzure #Survey #DataExpert #DBMigration #EmergingTrends #CloudComputing


r/DatabaseAdministators • • May 26 '22

Database help

0 Upvotes

Hi people, I am looking for a CRM that is either cheap or free and that I am able to add my clients name, connections, with which other clients are the clients mutuals with, documents storage, calendar, with a search bar on the home dashboard to be able to search in the docs and also clients. I am good with redesign, I just can’t find a provider that provides this.


r/DatabaseAdministators • • Aug 10 '26

I built ClavisDB - A modern SQL client with native FiveM & RedM support

0 Upvotes

Hey everyone!

For a long time I've been using tools like HeidiSQL to manage FiveM and RedM databases. They work, but I always felt there was room for something more modern, especially considering how much of our server data ends up buried inside JSON columns.

So I decided to build my own solution: ClavisDB.

ClavisDB is a desktop SQL client for MySQL, MariaDB, PostgreSQL and SQLite, but I've built it with special attention to FiveM and RedM development.

It has all the stuff you'd expect from a proper database client: a SQL editor with schema-aware autocomplete, table browsing and editing, filtering, query history, snippets, table structure editing, exports, user management, safe editing warnings, and so on.

But the part I'm personally most interested in is the FiveM / RedM integration.

ClavisDB can automatically detect QBCore, QBox, ESX, RSGCore and VORP databases and gives you a dedicated Player Inspector where you can search characters and inspect things like money, jobs, status, identifiers and framework data without digging through raw rows manually.

It also recognizes inventories and turns those horrible JSON blobs into an actual inventory viewer with slots, quantities, metadata, durability, serial numbers, ammo, etc.

You can even import a FiveM/RedM server.cfg and ClavisDB will extract the oxmysql connection string and configure the database connection for you.

Another thing I really wanted to get right was JSON editing. If ClavisDB detects JSON inside a cell — even inside TEXT/VARCHAR columns. You can open it in a proper tree/raw editor, format it, validate it, modify it and save it directly back to the database.

I've been building this because it's something I genuinely wanted for my own FiveM/RedM development workflow, and I'm planning to keep expanding the Cfx-specific tooling over time.

I'd really appreciate feedback from other developers/server owners. If there are things you constantly find annoying when managing your server database, tell me! Those are exactly the kind of problems I want ClavisDB to solve.

Download: https://clavisdb.ziomark.xyz/


r/DatabaseAdministators • • Jun 23 '26

I switched to Mac, couldn't find the database tool I wanted, so I built one

Post image
5 Upvotes

A few years ago I switched from Windows to Mac.

The thing I didn't expect to miss most was my database tool.

I grew up in the Microsoft ecosystem and spent a big part of my career working with SQL Server. If you've lived in that world, you probably know how hard it is to replace SQL Server Management Studio. Not because there aren't alternatives, but because after years of using a tool, it becomes part of how you think.

On Mac, I tried pretty much every database client I could find.

Some were great.
Some looked great.
None felt right.

Every time I needed to figure out why a query was slow, inspect a complex schema, or understand relationships inside a large database, I found myself missing the same capabilities over and over again.

So I stopped searching and started building.

I called it SPIRAL.

What started as a small side project quickly snowballed. The more I used it, the more ideas I had. Instead of trying to compete with every database tool on the market, I decided to focus on a handful of database engines that I personally use the most:

  • SQL Server

  • PostgreSQL

  • MySQL

  • SQLite

  • MongoDB

  • Redis

The funny part is that this is also the first project of my career where I didn't write most of the code myself.

I built it using a mix of:

  • GitHub Copilot

  • Claude Code

  • OpenAI Codex

  • Gemini CLI

The logo came from ChatGPT.
The initial design direction came from Google Stitch.
The website started in Claude Design and was refined afterward.

And honestly, that's probably the most interesting part of this whole project.

Five years ago, building something like this as a solo developer would have required a completely different level of time and effort.

In 2026, code has become incredibly cheap.

The bottleneck isn't typing anymore.
It's deciding what to build.

I originally planned to make this post about what it's actually like to build software this way—the good, the bad, the frustrating parts, what surprised me, what worked, what didn't.

But this post is already getting long, and I'd rather show the result first.

Today I released the first open-source version of SPIRAL.

It runs on Windows, macOS, and Linux.

I'd genuinely love feedback from other developers, especially people who spend a lot of time working with databases. Bug reports, feature requests, criticism, ideas—everything is welcome.

Links to the website and repository are in the comments.

(And yes, for anyone wondering: I wrote this post myself. At least for now 😉)

Website: http://spiral.susita.com

Github: https://github.com/developer82/Spiral/


r/DatabaseAdministators • • Oct 17 '26

Donnée, Base de données, SGBD, Serveur de base de données, Système de base de données, Serveur de données.

Post image
0 Upvotes

On croit parfois maîtriser une notion... jusqu'à ce qu'on essaie de l'expliquer.

En faisant ma veille technologique sur Feedly, je suis retombé sur des termes que j'utilise depuis des années : Donnée, Base de données, SGBD, Serveur de base de données, Système de base de données, Serveur de données.

Je pensais les distinguer clairement, mais c'est jusqu'à ce que j'ai tenté de les définir.

Et c'est là que les voiles de l'ignorance se sont levés. 😅

Et j'ai fini par me résoudre de faire des recherches et d'en apprivoiser le sens.

Voici le scénario qui m'a aidé à mieux comprendre.

Le directeur d'une école demande à M. Daph, DBA, de mettre en place un système pour gérer les informations des élèves.

  1. M. Daph installe PostgreSQL.

Au repos, ce dernier est un SGBD : un logiciel stocké sur le disque dur.

2) Lorsqu'il démarre PostgreSQL, celui-ci se met à écouter sur le port 5432 et traite les requêtes des applications.

La machine joue donc le rôle de serveur de base de données.

3) M. Daph crée une base contenant les informations des élèves.

Cette structure organisée devient la base de données.

4) Il connecte ensuite cette base à l'application de gestion scolaire.

L'ensemble application + SGBD + base de données constitue un système de base de données.

5) Le directeur souhaite aussi stocker : les photos des élèves, les bulletins PDF, les vidéos des fêtes scolaires.

Au lieu de surcharger la base de données avec ces fichiers lourds, M. Daph les stocke dans la machine mais dans des dossiers dédiés.

La machine devient un serveur de données, chargé de stocker et distribuer des fichiers.

Finalement, ces notions paraissent proches, mais elles désignent chacune une pièce différente d'un même métier.

Et vous, quelle notion informatique pensiez-vous parfaitement maîtriser avant de tenter de l'expliquer à quelqu'un d'autre ? 🤔

#Data #Database #PostgreSQL #DBA #DataEngineering #VeilleTechnologique #Apprentissage


r/DatabaseAdministators • • 26d ago

Why did the database administrator leave his wife?

Thumbnail reddit.com
1 Upvotes

r/DatabaseAdministators • • Nov 12 '25

Help! Understanding DB writing to AzureSQL

1 Upvotes

Would really appreciate your ideas on this one.

I’ve been tasked with understanding and documenting a Power BI setup that a previous consultant built for a client.

Here’s the situation:

  • There’s a Citrix server hosting a SQL database for their enterprise software.

  • That same server somehow writes data over to an Azure SQL database, which is then used for Power BI reporting.

The problem: I can’t figure out what’s actually doing the writing.
There’s no scheduled task, service, or standalone sync tool on the Citrix server that looks responsible for it.

What I’ve found so far:

  • The Azure SQL database is added as a linked server in SQL Server Management Studio on the Citrix host.

  • Audit logs on Azure SQL confirm the source of the writes is the Citrix server, and the application name shows up simply as “Microsoft SQL Server.” (See screenshot)

So it’s clearly SQL Server itself making the connection — but I can’t tell how or why.
Is there some feature or job in SQL Server that could silently be syncing or writing to that linked Azure database?


r/DatabaseAdministators • • Jul 17 '26

I added "table groups" to my schema designer — draw a box, drop tables in, drag the whole domain around. No more spaghetti canvas.

1 Upvotes

ey everyone 👋

I've been building Schematic (schematic.codemaster.club), a browser-based database schema designer, and I just shipped a feature I've wanted in every ER tool I've used: table groups.

If you've ever worked on a schema with 30+ tables, you know the pain — the canvas turns into spaghetti and you lose track of which tables belong to which part of the system. Groups fix that. Here's everything the feature does:

🗂️ Create groups three ways

  • Click the group button in the toolbar to drop an empty container anywhere

  • Right-click the canvas → "New group here"

  • Select multiple tables → "Group selected tables" — the group auto-sizes to fit them with clean padding. Single table selected? "Wrap in group" works too.

🧲 Spatial membership (my favorite part)
There's no "add to group" dialog. A table belongs to a group simply because it sits inside it. Drag a table in — it's a member. Drag it out — it's not. Zero ceremony.

🖐️ Move a whole domain at once
Grab a group by its header and the group and every table inside it move together. Reorganizing your "billing" domain is one drag instead of twelve.

🎨 Color coding
8-color palette with tinted backgrounds and matching headers so domains are visually distinct at a glance. New groups auto-cycle through colors; you can change any group's color from its right-click menu.

✏️ Everything else you'd expect

  • Double-click the header to rename inline

  • Drag the corner handle to resize

  • Right-click for rename / recolor / delete

  • Groups render behind tables, so they never get in the way of your actual work

  • Layout persists — positions, sizes, colors all saved with your project

One deliberate decision: groups are purely visual. They don't touch your schema or the generated SQL — nnamespacing, no side effects. They exist only to keep a big canvas sane.

You can try it free here: schematic.codemaster.club

Would love feedback — especially from people who work with large schemas. What would make grouping more useful for you? Nested groups? Auto-grouping by foreign-key clusters? Collapse/expand?


r/DatabaseAdministators • • Feb 22 '26

I have an SQL based exam!!!!

0 Upvotes

I have an exam in about 4 hours from now. It is of SQL and I'm not sure what kind of questions to expect because my instructor wasnt really clear with the instructions. The only instruction he gave us and was focused on was that all sorts of AI will be allowed during my exam. We can use whatever we want. That is a very scary sentence because if someone is making an exam and is allowing using all sorts of generative AI, he has made sure that it can't solve those questions either. I need help


r/DatabaseAdministators • • Jun 12 '24

Is your SQL server slow and you don't know why?

0 Upvotes

Have you had performance issues with your sql server but you don't want to spend months on learning how to optimize it?

Check out https://www.sqlsensei.net/ a free cloud solution to give you performance insights on your SQL Server

  • Index monitoring

  • Bad query monitoring

  • Bottlenecks

  • Server level issues

  • Index/statistics maintenance

If you are intested you can message me so I can help you set it up :)


r/DatabaseAdministators • • Jun 11 '25

We turned our database migration hell into a DevOps pipeline: Here’s what we learned

0 Upvotes

At my current team, manual DB migrations were slowing down every release, causing errors, and becoming a bottleneck for the entire engineering team. We documented our experience and the lessons learned from transitioning to a Database DevOps approach.

We break down:

  • The inefficiencies of manual migrations

  • The importance of versioning your database

  • How automation and CI/CD unlock faster, safer DB changes

  • What tools and practices helped us scale

Would love to hear how others have tackled DB delivery at scale.👉 Read the blog


r/DatabaseAdministators • • Aug 23 '26

DBA in AI landscape

1 Upvotes

How Seniors and lead database administrators are dealing or coping with AI agentic uprising at work place.

What are some great AI certifications or path that will make DBAs remain competitive among plethora of AI movement


r/DatabaseAdministators • • Jul 11 '26

Overlaps between DBAs and Data Engineers?

1 Upvotes

I know this would depend a lot on company and domain, but what are the overlaps between these two roles? Do the both work on pipelines? Is it only SQL?


r/DatabaseAdministators • • Sep 13 '26

Thinking about getting into SQL/DBA contracting

1 Upvotes

Hey all, I’m a SQL/BI Developer based in the north west and I’ve been thinking about moving into contracting.

I’ve got around 9 years of SQL Server experience across DBA, SQL development, SSIS/ETL, migrations, Power BI, Azure/ADF etc. I’ve had a few recruiters contact me recently about contracts, but my 3-month notice period is making things difficult.

Just wondering what the market is actually like for SQL/DBA/data contracts at the moment, especially North West or remote?

Is it fairly easy to move from one contract to the next, or do you end up with big gaps? And are there still plenty of SQL Server/DBA/SSIS type contracts about?

Would be good to hear from anyone doing something similar.