about
LLM as DBA (arxiv.org)
22 points by ngaut on Dec 2, 2023 | hide | past | pdf | 2 comments on HN

In plain words: D-Bot is an AI assistant that reads database manuals to learn maintenance know-how, then works through problems step by step with AI helpers to find why a database is slow or broken and suggest fixes. Early tests show it pinpoints causes quickly and accurately.

Abstract · LLM As DBA

Database administrators (DBAs) play a crucial role in managing, maintaining and optimizing a database system to ensure data availability, performance, and reliability. However, it is hard and tedious for DBAs to manage a large number of database instances (e.g., millions of instances on the cloud databases). Recently large language models (LLMs) have shown great potential to understand valuable documents and accordingly generate reasonable answers. Thus, we propose D-Bot, a LLM-based database administrator that can continuously acquire database maintenance experience from textual sources, and provide reasonable, well-founded, in-time diagnosis and optimization advice for target databases. This paper presents a revolutionary LLM-centric framework for database maintenance, including (i) database maintenance knowledge detection from documents and tools, (ii) tree of thought reasoning for root cause analysis, and (iii) collaborative diagnosis among multiple LLMs. Our preliminary experimental results that D-Bot can efficiently and effectively diagnose the root causes and our code is available at github.com/TsinghuaDatabaseGroup/DB-GPT.

Xuanhe Zhou, Guoliang Li, Zhiyuan Liu
arXiv:2308.05481 · cs.DB, cs.AI, cs.CL, cs.LG · submitted Aug 10, 2023 · updated Aug 11, 2023
abstract · pdf · html

add comment on HN

I mean, good luck! I am looking forward to the report on how did this go in production on a large self managed DB that has active dev cycles.
Same. I imagine it would be very entertaining. It could be useful to at least create a list of potential action items, but I definitely wouldn't be wanting to spend tons of time fighting some PM on why the LLM said this or that.

"Hmm, Bob isn't doing what the DB LLM recommends. I should definitely check with the HR LLM for what to do about this."