
Has Anyone Gotten WorkBuddy's Database Connection Working?
Last night at 11:30, the client suddenly wanted to see last week's order details, and the data was in MySQL. Normally when I query data I open Navicat, write SQL, export CSV, then throw it into WorkBuddy for aggregation and pivoting. The whole thing takes about twenty minutes, not slow, but doing it three times in a row late at night is annoying.
I came across a hands-on review of WhoDB, saying these kinds of tools can now generate SQL directly from natural language, and can manage MySQL, PostgreSQL, and Redis in one interface. I got interested right away: WorkBuddy can read files and organize tables anyway, so can't it also connect directly to the database, and I just tell it in one sentence to pull last week's orders? That would save the CSV export step.
So I dug around in WorkBuddy for a while. Document import, table merging, folder organizing—I'm all familiar with those, but I couldn't find an entry point for database connections. Maybe my version is wrong, or it's hidden in some setting I didn't click. I tried saying directly in the chat "help me connect to this MySQL database and export last week's orders," and its reply was roughly that I needed to provide a data file first, it couldn't connect directly. I don't remember the exact wording, but anyway it didn't work.
So I want to ask people who've used it: does WorkBuddy actually support direct database connections? If it does, what did I not set up right? If it doesn't, do I still have to honestly export from Navicat and feed it in?
By the way, my actual need: it's not about having it write complex SQL for me, just a few fixed tables every day—can it pull them itself? I've done the math: the CSV export step, three times a day, five or six minutes each time, adds up to several hours a month. Isn't that time better spent on something else?
Has anyone gotten this working? Looking for some direction.
Physix Frontier