Posts

DBeaver as a MySQL Workbench Replacement : Performance Queries

 "Hey, Dave! "Is there any way to get the old MySQL Workbench performance information from  DBeaver?"  An old acquaintance asked me this question this morning. The queries running without an index and the high-cost SQL statement information were what was wanted.  Yup. The good news is that all that information on the instance's performance is all SQL. And that SQL is pretty simple and runs on the MySQL server.  You can grab a copy below of  MySQLWorkbenchPerformanceQuries4DBeaver.sql or download from  https://github.com/davestokes/HandySQL For those not in the know, these are short scripts with varying levels of utility for reporting information about a MySQL instance. I put them into a single .sql file to help diagnose trouble tickets. And you can run all these queries at once in DBeaver with ATL + X . For those new to MySQL administration, save a copy somewhere safe because someday you may need to know about memory, I/O hotspots, or buffer stats....
Post a Comment
Read more

AI Chat With DBeaver Community Edition

Image
  AI Chat With DBeaver Community Edition July 29, 2026   DBeaver recently introduced interactive chat capabilities into the free, open-source Community Edition. What does that mean?  It means some of your database tasks can be accomplished significantly faster !  First , you can ask for information without coding SQL. I love Structured Query Language, but it is much faster to write this prompt: What are the top ten most popular rentals and how much revenue did they genera te? And faster than I look at the schema, the AI answers: -- This query finds the top 10 most rented films and their total revenue with film_rentals as ( select i . film_id , count ( r . rental_id ) as rental_count , sum ( p . amount ) as total_revenue from rental r join inventory i on r . inventory_id = i . inventory_id join payment p on r . rental_id = p . rental_id group by i . film_id ) select f . title , fr . rental_count ,...
Post a Comment
Read more

MySQL Workbench to DBeaver Transition

Image
 First, there were the MySQL Query Browser and the MySQL Administrator, collectively known as the MySQL GUI Tool Bundle. But they were given End-of-Life status in 2009. Next was MySQL Workbench, but that tool is now EOL as well. MySQL Workbench provides a warning if you try to use it with later versions of MySQL.  You could still run Workbench, but it will grumble if you try to use it with any version other than 5.6, 5.7, or 8.0. Heck, it warns you that 8.4 may be a bit sketchy. On, and you need an older version for MySQL 5.5 and earlier.   Many people swore by Workbench as the tool for checking on system status, wiring queries, and making backups. Others swore at it. Yes, it had quirks. But Workbench did a lot of this right.  There is a free, open-source database tool you should consider as a replacement. DBeaver Community Edition  is also a database tool, but it supports many databases, not just MySQL. It uses JDBC connectors. DBeaver is an IDE that offers sma...
Post a Comment
Read more

Github And DBeaver

Image
  Hopefully, you are regularly using both  DBeaver  and  GitHub . But did you know that you can link them together? If you are running DBeaver Community, you will have to install some software that is built into the Pro versions.  1. Install Git Extension (Community Edition)   Go to  Help  ->  Install New Software . In the "Work with" field, enter:  https://dbeaver.io/update/git/latest/ . Check the box for  DBeaver Git Support , click  Next , and follow the prompts to finish and restart DBeaver.   2. Configure GitHub Authentication   GitHub requires a  Personal Access Token (PAT)  rather than your standard account password for DBeaver's connection:   Generate Token:  On GitHub, go to  Settings  ->  Developer Settings  ->  Personal access tokens  ->  Tokens (classic) . Permissions:  Select all  repo  scopes and  read:org  under...
Post a Comment
Read more