Has Anyone Gotten WorkBuddy's Database Connection Working?
Community Discussion · General

Has Anyone Gotten WorkBuddy's Database Connection Working?

MingMing3d ago2026/11/16 113 views

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.

2 replies

?
Ctrl + Enter to reply
Susu
Susu2d ago

I totally get your "export three times a day, five or six minutes each time" line. My store's reconciliation is stuck on the same thing, and in the end I still have to export CSV via Navicat and feed it in.

Factor Miner

That detail you mentioned—"it asked me to provide the data file first"—basically means there's no direct connection entry point. Stop digging through the settings and save the time to run last week's order SQL first.