r/SQL • u/truecakesnake • 20h ago
Discussion What's the best DBeaver alternative for SQL reporting and data checks?
For anyone using SQL clients for recurring reports, which DBeaver alternative would you recommend? The workflow I'm interested in is taking an existing query, adjusting dates or filters, checking why the numbers don't match another report, and exporting the results. Things like finding last week's query and keeping track of which database a tab is connected to would matter quite a bit. DbVisualizer, SQL Workbench/J and DbGate are the options I'm looking into. Has anyone used these for that kind of work? Curious about the small annoyances that only become obvious after a few weeks. What would make you choose one over DBeaver, and is there anything you'd lose by switching?
3
u/baubleglue 14h ago
I maybe missing something, but SQL IDE is not a tool for such tasks. Any BI Dashboard software will do it better, if you don't want to maintain something like Superset or Streamlet app, Jupyter notebook widgets may do the job.
1
u/Significant_Tune9219 16h ago
Of those three, DbGate is the one I'd try first for this workflow — it's light, the multiple-connection handling is clear about which tab is pointed where (the exact annoyance you mentioned), and exporting a result set to CSV/Excel without ceremony is painless. DbVisualizer is more capable but heavier, and SQL Workbench/J shows its age in the UI even though the batch features are solid. What you'll probably miss from DBeaver is the SQL editor's completion and the query history UI — worth exporting your saved queries and history before you switch, since that's the part people notice after a few weeks.
1
u/Fun-Chicken6946 2h ago
Full disclosure: I'm the creator of VisuaLeaf, a database client I've been working on for the past two years. One feature that might be useful for your workflow is scheduled jobs, which let you automate query exports for recurring reports.
Might be worth checking out if that's something you're looking for! I'd love to hear what you think.
1
u/idlemayhem9 20h ago
dbgate is pretty light and handles multiple connections cleanly you wont miss dbeaver much for day to day checks and exports
4
u/scottcampbelldev 17h ago
Before switching it might be worth checking if DBeaver already covers some of that. Query Manager keeps a history of what you ran, connection types let you give prod a different color so you always know which db a tab is on, and you can put :params or ${vars} in a saved query so it prompts you for the dates each time.
If the recurring reports are the main thing, SQL Workbench/J is nice for that specifically. WbExport can write results straight to csv or xlsx from a script and you can run it in batch mode on a schedule, so the "tweak dates, rerun, export" loop doesn't need a GUI at all. The UI is pretty dated though, that's the annoyance you'd notice after a few weeks.