DEV Community: DbVisualizer

How to Use SQL INSERT INTO SELECT to Copy Data Between Tables

DbVisualizer — Mon, 07 Sep 2026 07:00:00 +0000

Copying rows between tables is a common SQL task. Rather than inserting values one row at a time, INSERT INTO ... SELECT lets you move data using the output of another query.

What Does INSERT INTO SELECT Do?

This statement inserts the results of a SELECT query into an existing table. It works well for migrations, backups, reporting tables, and filtered datasets.

Some useful characteristics include:

Supports filtered inserts.
Can use joins.
Allows value transformations.
Works across popular SQL databases.

Basic Syntax

The statement combines an insert operation with a select query.

INSERT INTO target_table (column1, column2, column3)
SELECT column1, column2, column3
FROM source_table
WHERE condition;

Example Query

Here's a simple example that stores only IT employees in another table.

INSERT INTO it_staff_backup (original_id, full_name, salary)
SELECT id,
       first_name || ' ' || last_name,
       salary
FROM employees
WHERE department = 'IT';

This query:

Filters employees by department.
Builds a full name.
Copies salary information.
Inserts the results into an existing backup table.

FAQ

Which SQL statement copies table data?

Use INSERT INTO ... SELECT whenever data should be copied into an existing table.

Is INSERT INTO table from SELECT another command?

No. It's another name for the same SQL statement.

Does Oracle support this syntax?

Yes. Oracle implements the same general approach for inserting data selected from another table or query.

How is CREATE TABLE ... SELECT different?

CREATE TABLE ... SELECT creates a new table first. INSERT INTO ... SELECT writes into a table that already exists.

Why work with a visual database client?

Graphical SQL tools make it easier to browse schemas, execute queries, inspect results, and manage databases from one interface.

Conclusion

INSERT INTO ... SELECT is a practical SQL feature for copying and transforming data in one step. Understanding this statement can simplify many everyday database tasks.

Read the full original article here INSERT INTO … SELECT Statement: What You Need to Know.

SQL SUBSTRING_INDEX: How to Extract Text Using Delimiters

DbVisualizer — Mon, 31 Aug 2026 07:00:00 +0000

Many SQL queries involve extracting part of a value instead of returning an entire string. Whether you're working with URLs, email addresses, or IP addresses, SUBSTRING_INDEX provides a simple way to retrieve the section you need using a delimiter.

This article covers the basics of the function, common use cases, and a few things to keep in mind when using it in larger datasets.

How SUBSTRING_INDEX Works

SUBSTRING_INDEX returns a portion of a string based on a delimiter and the number of delimiter occurrences.

The basic syntax is:

SUBSTRING_INDEX(string, delimiter, count);

The function accepts:

A string or column
A delimiter to search for
A count value that determines where the string is split

For example:

SELECT SUBSTRING_INDEX('https://dbvis.com', '.', 2);

Negative values count delimiters from the end of the string:

SELECT SUBSTRING_INDEX('www.dbvis.com', '.', -2);

If one of the arguments is NULL, the function returns NULL.

Everyday Use Cases

Instead of hardcoded values, you'll usually apply SUBSTRING_INDEX to table columns.

Some common scenarios include:

Extracting email domains
Breaking IP addresses into individual parts
Parsing URLs
Preparing data for reports and analytics

For example, extracting email domains:

SELECT SUBSTRING_INDEX(email, '@', -1)
FROM users;

This approach is useful when grouping or filtering users based on their email provider.

Performance Considerations

String functions can become expensive on large tables, so it's worth planning queries carefully.

A few practical recommendations are:

Test queries on production-sized datasets.
Use indexes where they support the overall query.
Combine extraction with aggregation only when needed.
Export processed data if it will be reused elsewhere.

Here's a simple reporting query:

SELECT
SUBSTRING_INDEX(email, '@', -1) AS domain,
COUNT(*) AS users
FROM users
GROUP BY domain;

Related Functions

Not every database includes SUBSTRING_INDEX, but similar functionality exists across SQL platforms.

Depending on the database, you may use:

SUBSTRING
SUBSTR
RIGHT()
Pattern-based SUBSTRING in PostgreSQL

The available function depends on the SQL dialect you're working with.

Frequently Asked Questions

What is SUBSTRING_INDEX in SQL?

SUBSTRING_INDEX extracts part of a string based on a delimiter and the number of matching delimiter occurrences. It's commonly used to isolate values from structured text.

When should I use SUBSTRING_INDEX?

Use it whenever data contains predictable separators, such as periods, slashes, or the @ symbol in email addresses.

Which databases support SUBSTRING_INDEX?

MySQL provides native support for SUBSTRING_INDEX. Other database systems offer comparable functionality through functions such as SUBSTRING, SUBSTR, or RIGHT().

Conclusion

SUBSTRING_INDEX is a useful SQL function for extracting values from structured strings without complex expressions. Whether you're parsing URLs, email addresses, or IP addresses, it can simplify many everyday database tasks.

If you'd like to explore more examples and database compatibility details, read the original article Parsing Data with SUBSTRING_INDEX: A Complete Guide.

How to Use SQL DROP TABLE Safely: Syntax, Examples, and Tips

DbVisualizer — Mon, 24 Aug 2026 07:00:00 +0000

The SQL DROP TABLE statement is designed to remove an entire table from a database. Unlike commands that only delete records, this one also removes the table definition and related database objects. Knowing its behavior helps you make safer decisions when modifying a database.

What Does DROP TABLE Do?

Before deleting a table, it's useful to understand exactly what the statement affects.

Running DROP TABLE typically removes:

The table itself.
Every stored row.
Indexes associated with the table.
Constraints and triggers tied to it.
The storage allocated to the table.

Since this is generally a DDL operation, it is usually committed immediately and cannot be rolled back.

Basic SQL Syntax

The syntax is straightforward and works similarly across most relational database systems.

DROP TABLE table_name;

For example:

DROP TABLE students;

After execution, the students table no longer exists, and applications can no longer query it.

Some database platforms also allow multiple table names in the same statement.

Avoid Errors with IF EXISTS

Database scripts often need to run repeatedly. In those situations, trying to remove a table that has already been deleted can interrupt execution.

Using IF EXISTS avoids that problem.

DROP TABLE IF EXISTS users;

This version skips the operation when the table is missing instead of returning an error, making automation scripts more reliable.

When Should You Use DROP TABLE?

There are several practical situations where removing a table is appropriate.

You might use it when:

Cleaning up temporary tables.
Removing outdated database objects.
Resetting development environments.
Simplifying an evolving database schema.

Before executing the command, confirm that no applications or database objects still depend on the table.

A Safer Way to Remove Tables

Running destructive SQL commands directly from a query editor works, but graphical database tools can make the process easier to verify.

A visual client allows you to:

Browse database objects.
Inspect the schema first.
Preview the generated SQL.
Execute the command after confirmation.

This extra visibility can help prevent accidental changes, especially when working with shared databases.

Best Practices Before Running DROP TABLE

Removing a table takes only one statement, but preparation matters.

Consider these recommendations before executing it:

Back up valuable data.
Check foreign key relationships.
Review dependent views and procedures.
Use IF EXISTS where appropriate.
Keep schema changes under version control.

These habits help reduce the chance of removing something unexpectedly.

Frequently Asked Questions

What is the difference between DROP TABLE, TRUNCATE, and DELETE?

The three commands remove data differently.

DROP TABLE deletes the table completely. TRUNCATE clears all rows but keeps the table definition. DELETE removes rows while preserving both the structure and database object.

They also differ in logging, rollback capabilities, and trigger behavior.

How can you remove every table?

SQL does not provide a universal command for dropping all tables.

Instead, administrators usually generate DROP TABLE statements from the database catalog and execute them through a script.

The exact solution depends on the database system being used.

How do you remove a column?

Dropping a column requires ALTER TABLE rather than DROP TABLE.

ALTER TABLE table_name
DROP COLUMN column_name;

Only the selected column is removed, while the rest of the table remains unchanged.

How are temporary tables dropped?

Temporary tables are generally removed with the same command.

Some database engines include additional keywords or naming conventions, but the overall process is very similar to dropping a regular table.

Can multiple tables be removed together?

Yes, many SQL databases support listing several tables in one statement.

DROP TABLE orders_archive, customers_archive;

Support varies between database platforms, so check your system's documentation before relying on this syntax.

Why use a visual database client?

Visual database clients simplify everyday administration by combining schema exploration, SQL editing, and object management in one interface.

They also make potentially destructive operations easier to review before execution, reducing the likelihood of accidental changes.

Conclusion

DROP TABLE is an essential SQL command for permanently removing database tables. Understanding its syntax, knowing when to use IF EXISTS, checking dependencies, and following good database practices can help you perform schema changes more safely.

To explore database-specific behavior, additional SQL examples, and a more detailed explanation, read the original article here SQL DROP TABLE Statement: Everything You Need To Know.

Upgrade MySQL in WHM: Quick Setup Guide

DbVisualizer — Mon, 17 Aug 2026 07:00:00 +0000

WHM provides a built-in way to upgrade MySQL and MariaDB without relying entirely on the command line. This overview covers the main steps, compatibility checks, and a few tools that can help with database management afterward.

Sign In to WHM

Start by accessing your WHM instance. You'll need to:

Open your server using port 2087.
Authenticate with your server account.
Confirm that WHM is available.

Upgrade Your Database Version

Once inside WHM, the upgrade process only takes a few steps. Open MySQL/MariaDB Upgrade, then:

Select a supported database version.
Review the transferred my.cnf settings.
Choose automatic or interactive mode.
Complete the upgrade.

Run the Upgrade Checker

After selecting the version, it's a good idea to verify the upgrade. The checker helps you:

Review compatibility.
Detect potential problems.
Confirm the upgrade is ready.

Database Management Beyond Upgrades

Keeping software updated is only part of maintaining a healthy database environment. Useful capabilities include:

Managing database connections.
Running SQL queries.
Controlling query permissions.
Creating ER diagrams.

Frequently Asked Questions

How can I upgrade MySQL in WHM?

Use the Upgrade Database Version feature in WHM, choose a supported release, review your configuration, and complete the guided upgrade.

Can I upgrade MySQL without WHM?

Yes. Manual upgrades involve backing up your data, installing updated MySQL packages, and restarting the service using your operating system's package manager.

Is the Upgrade Checker necessary?

It's recommended because it validates compatibility before the upgrade is finalized.

Does DbVisualizer upgrade MySQL?

No. DbVisualizer is intended for working with databases after they're running, not for upgrading the database server itself.

Conclusion

WHM simplifies MySQL and MariaDB upgrades by providing a guided interface and compatibility checks. If you'd like the complete walkthrough, read the original article here How to Upgrade MySQL in WHM? Step-By-Step Guide.

Getting Started with Multitenant Database Containers in Kubernetes

DbVisualizer — Mon, 10 Aug 2026 07:00:00 +0000

Running databases for multiple customers doesn't always require separate infrastructure. Multitenant database containers allow applications to serve multiple tenants while maintaining clear data boundaries and efficient resource usage.

Multitenancy in Simple Terms

A multitenant system serves multiple customers from a shared application or database environment.

While infrastructure is shared, each tenant's data remains separate and protected.

Why Kubernetes and Containers Matter

Containers provide portable and repeatable environments for databases. Kubernetes adds orchestration and automation on top. Some common advantages include:

Reduced infrastructure overhead
Easier scaling during traffic increases
Better operational consistency
Tenant isolation controls
Version-controlled infrastructure definitions

Components Required for Deployment

A Kubernetes database deployment usually includes three essential resources.

Storage Layer

Persistent Volumes hold database data independently from containers. Example:

apiVersion: v1
kind: PersistentVolume

Storage Requests

Persistent Volume Claims allocate storage to workloads.

apiVersion: v1
kind: PersistentVolumeClaim

Database Deployment

The deployment resource controls the database container lifecycle.

apiVersion: apps/v1
kind: Deployment

Network Access

Services expose the database to applications running inside the cluster.

apiVersion: v1
kind: Service

Deploying the Resources

Once the configuration files are ready, deploy them:

kubectl apply -f mysql-pv.yaml
kubectl apply -f mysql-pvc.yaml
kubectl apply -f mysql-deployment.yaml
kubectl apply -f mysql-service.yaml

Verification commands:

kubectl get pv
kubectl get pvc
kubectl get svc

FAQ

What Are Multitenant Database Containers?

They are database deployments designed to support multiple tenants from shared infrastructure while maintaining logical separation between users and applications.

How Can They Be Configured in Kubernetes?

The process typically involves defining a Persistent Volume, a Deployment, and a Service using Kubernetes YAML manifests.

Why Use DbVisualizer?

DbVisualizer provides database management features such as query execution, data editing, export options, and support for numerous database platforms.

Conclusion

Multitenant database containers offer a straightforward way to manage multiple tenants within Kubernetes. By combining storage, deployments, and services, teams can build database environments that are easier to scale and maintain. For the original article, visit: Multitenant Database Containers for Modern-Day Applications.

Reliable MySQL Backups with MyDumper Checksum Validation

DbVisualizer — Mon, 03 Aug 2026 07:00:00 +0000

MyDumper is widely used for MySQL and MariaDB backups because it can process data using multiple threads. Combined with checksum validation, it can also help verify that restored backups remain accurate.

What Makes MyDumper Different?

Traditional backup tools may process data sequentially. MyDumper approaches the task differently by using parallel operations. Some advantages include:

Faster backup execution
Better handling of large tables
Flexible filtering options
Support for parallel workloads

This makes it useful for both small and large database environments.

Enabling Checksum Validation

Backup integrity can be checked by enabling checksum verification, example:

./mydumper --host localhost --user mysqluser --password BrV9u2MbT \
--outputdir /tmp/backups/ --M

When checksum validation is enabled:

Backup data is analyzed
Checksum values are stored
Restored data is compared
Mismatches can be detected

This process helps identify integrity issues before backups are relied upon.

Helpful Features Worth Knowing

MyDumper offers more than backup creation. Administrators can also:

Connect through SSL
Include specific databases
Exclude selected objects
Filter rows
Adjust thread usage

These controls allow backup jobs to be tailored to specific requirements.

How MyLoader Fits In

MyLoader is commonly used alongside MyDumper when restoring data. The pairing provides:

Fast backup generation
Efficient data restoration
Validation support

For larger databases, this workflow can improve operational efficiency.

Supporting Tools for Database Work

Backup validation is important, but so is ongoing database management. SQL clients can assist with:

Query tracking
Data exploration
Result exports
Query reuse

Together with backup tools, they form part of a broader database toolkit.

FAQ

What is MyDumper and how does it differ from mysqldump?

MyDumper performs logical backups using multiple threads, while mysqldump operates in a single-threaded manner.

Are MyLoader and MyDumper the same?

No. MyDumper creates backup files and MyLoader restores them. They are designed to work together.

How do you use MyDumper?

Execute MyDumper from the command line, provide database connection details, and optionally enable checksum validation.

Conclusion

MyDumper provides a practical solution for creating MySQL backups while supporting integrity verification through checksums. When combined with MyLoader, it can streamline backup and recovery workflows. For the complete article, visit: Using MyDumper Checksums for Reliable MySQL Backup Validation.

PostgreSQL Backup and Restore Workflow for Developers

DbVisualizer — Mon, 27 Jul 2026 07:00:00 +0000

PostgreSQL includes built-in tools that make backups and recovery straightforward when used correctly. This overview covers backup creation, restore procedures, and common issues that appear during recovery.

Preparing PostgreSQL for Backup Testing

A simple Docker-based setup makes it easy to practice backup operations.

Key preparation steps:

Create a PostgreSQL container
Configure database credentials
Create a sample database
Insert test data

docker compose -f postgresql.yml up -d

This provides a safe environment for testing backup and restore procedures.

Creating a Backup with pg_dump

The first step in any recovery plan is creating a backup.

A custom-format backup is a common choice because it balances storage efficiency and recovery flexibility.

pg_dump -U dbadmin -F c -f backup.dump surveyplatform

This file can later be restored using pg_restore.

Handling a Failed Restore

Restore failures often reveal missing dependencies rather than damaged backups. A common example is a missing database role. When this happens:

Check restore errors carefully
Recreate missing roles
Remove incomplete restore attempts
Retry the restoration

CREATE ROLE demo;

Resolving ownership issues is frequently enough to complete recovery.

Choosing the Right Backup Format

PostgreSQL supports multiple backup formats. Options include:

SQL text backups
Custom backups
Directory backups
TAR backups

Each format targets a different operational need, from debugging to large-scale restoration.

Restoring and Verifying Data

Restoration should always be followed by validation. For SQL backups:

psql -f backup.sql

For custom backups:

pg_restore -d surveyplatform backup.dump

After restoring, run queries against important tables to confirm the expected data exists.

FAQ

Which PostgreSQL backup format should I use for daily backups?

Custom format is often the recommended starting point. It offers compression and flexible recovery options. The format also supports selective restores when needed.

For many workloads, it provides a practical balance between convenience and capability.

How often should I test my PostgreSQL backups?

Backup testing should happen regularly. A monthly restore test can identify problems before they affect production recovery.

Verification queries help confirm backup quality. Testing turns backups into a dependable recovery solution.

Why do I get "role does not exist" errors when restoring backups?

The backup references a database owner that is not available on the target system.

PostgreSQL cannot assign ownership without that role. Creating the missing role resolves the issue. The restore can then complete successfully.

Can I restore a PostgreSQL backup to a different database name?

Yes.

Create the destination database beforehand. Restore the backup into that database. Avoid using options that force the original database name to be recreated.

Conclusion

PostgreSQL's pg_dump and pg_restore tools provide a dependable foundation for backup and recovery. Knowing how to create backups, troubleshoot restores, and verify recovered data helps reduce risk when failures occur. For the complete tutorial, visit PostgreSQL Backup and Restore: Complete Tutorial with pg_dump and pg_restore.

Preparing for MySQL 8.0 End of Life: Key Things to Know

DbVisualizer — Mon, 20 Jul 2026 07:00:00 +0000

MySQL 8.0 reaches end of life in April 2026. Once support ends, organizations using the database version should be aware of the operational and security implications that follow.

Understanding the Impact

The end of official support means changes for database environments.

Key considerations include:

No future security fixes
Reduced support resources
Compliance concerns
Greater maintenance effort

For regulated industries, unsupported software may require additional controls and documentation.

Common Next Steps

Organizations generally choose one of three approaches.

Upgrade to a Supported Version

Many teams will move to MySQL 8.4 or newer releases. Advantages include:

Ongoing updates
Better security posture
Easier compliance management

Explore Alternative Platforms

Some organizations may decide to migrate elsewhere. Frequently considered options are:

MariaDB
Percona Server

These platforms offer compatibility with many existing MySQL workflows.

Continue Operating MySQL 8.0

Although possible, staying on MySQL 8.0 after EOL increases risk. Organizations should prepare for:

Independent troubleshooting
Additional security oversight
Potential audit concerns

Database Tools and Daily Operations

Database management tools can support administrators by improving visibility and productivity. Useful capabilities often include:

Schema navigation
Access control management
SQL assistance
Query-building tools

While they do not replace software updates, they can improve daily database administration.

FAQ

Has MySQL 8.0 Reached EOL?

MySQL 8.0 reaches end of life in April 2026. The support status depends on the current date and should be verified against official lifecycle information.

What If I Need to Stay on MySQL 8.0?

Upgrading remains the preferred solution. If business requirements delay migration, organizations should strengthen security practices and carefully monitor database environments. Unsupported software generally becomes harder to maintain over time.

Where Can I Find Official MySQL EOL Notices?

Oracle provides lifecycle and support information through its official MySQL channels. Those notices offer the most reliable source for support timelines.

Conclusion

The MySQL 8.0 end-of-life transition is primarily about planning ahead. Understanding support timelines, evaluating upgrade paths, and maintaining secure database practices can help organizations manage the change effectively. You can read the original article here: MySQL 8.0 EOL: What Happens Next?

Top RBAC Tools for SQL Databases in 2026

DbVisualizer — Mon, 13 Jul 2026 07:00:00 +0000

Database permissions affect both security and day-to-day operations. RBAC helps ensure users only access the resources they need, making the choice of database tooling an important decision.

Several SQL tools include features that help manage permissions and access controls. Here are three commonly considered options.

DbVisualizer

DbVisualizer offers database administration and security-related functionality across many platforms. Key features:

Query execution controls
Master password support
Feature-rich SQL editor
Support for 60+ database technologies

Possible drawbacks:

Advanced functionality is paid
Interface updates may require adaptation

DBeaver

DBeaver combines database management features with role-based administration in its commercial offerings. Useful capabilities:

User and project access management
Built-in Command Palette
Quick generation of SELECT statements

Things to consider:

Performance may decrease with large datasets
Can require more system resources

Adminer

Adminer is designed for users who want a lightweight solution. Reasons people choose it:

Free availability
Multi-database support
Community-driven extensions

Limitations:

Simpler RBAC options
Less suitable for larger teams

FAQ

What Is the Best Tool for RBAC?

The answer depends on your requirements. If advanced database management and security features are priorities, DbVisualizer is often considered first. DBeaver provides a capable alternative, while Adminer is a practical choice for straightforward environments.

How Can You Secure Your Database?

Security starts with fundamentals. Maintain strong passwords, restrict access using roles, audit permissions regularly, and ensure users receive only the privileges they need.

Conclusion

RBAC plays an important role in protecting database systems. Whether you choose DbVisualizer, DBeaver, or Adminer, aligning the tool with your operational needs is the key consideration.

Read the full article here: Best Tools for Role-Based Access Control (RBAC) in SQL Databases in 2026.

How Git Helps Manage SQL Queries and Database Changes

DbVisualizer — Mon, 06 Jul 2026 07:00:00 +0000

Most developers use Git daily, but version control can also play an important role in database projects. Managing SQL files through Git makes it easier to track changes, coordinate work, and maintain consistency across environments.

Bringing Version Control to Databases

Database development often involves ongoing updates to tables, relationships, and queries. Git provides a structured way to manage those changes. Benefits include:

Clear change history
Team collaboration
Easier rollbacks
Better visibility

Examples of Git in Database Projects

Versioning SQL files creates a record of database evolution.

Tracking Schema Modifications

As databases grow, schema updates become common. Git helps document those changes over time.

Supporting Deployments

Database-related SQL files can be shared across teams and environments, making deployments more predictable. Common advantages:

Faster releases
Consistent execution
Easier review processes

Managing Multiple Features

Branches help separate database work into manageable units. Examples include:

New schema features
Query updates
Table restructuring
Migration development

Tools That Complement Git

Version control records changes, but SQL clients help interpret them.

Database Exploration

Database tools can assist with:

Schema navigation
Relationship analysis
Constraint review
Index inspection

ERD Generation

Entity-Relationship Diagrams provide a visual overview of table connections and data flow.

SQL Development Features

Many database clients include:

Smart suggestions
Auto-completion
Query editing tools
Formatting assistance

FAQ

What Relevance Does Git Have for Database Operations?

Git helps organize database-related code and schema changes. It creates a shared process for managing updates while preserving historical records.

How Best to Track Changes in a Database?

Version-controlled SQL files are a good starting point. Combining Git with backups and migration management creates a more complete change-tracking strategy.

Backups remain important because they protect actual database content.

Besides Tracking Changes, Is There Something Else To Take Care Of?

Yes. Database knowledge extends beyond version control. Learning about database architecture, performance, and administration can improve long-term results.

Conclusion

Git is not a database management tool, but it can support database workflows effectively. Versioning SQL queries, migrations, and schema updates helps teams maintain better visibility and control over database changes.

Please read the original article Versioning Your Queries: Git Workflows for Analysts and Engineers.

4 MySQL Workbench Alternatives Every Mac Developer Should Know

DbVisualizer — Mon, 29 Jun 2026 07:00:00 +0000

If MySQL Workbench feels limiting on macOS, there are several alternatives that offer a different balance of usability, database support, and productivity features. Here are four tools worth a closer look.

Workbench still has a large user base, but some developers look elsewhere because of:

Performance concerns
Interface complexity
MySQL-only focus
Limited optimization for macOS workflows

As database environments become more diverse, broader tool support becomes increasingly important.

DbVisualizer

DbVisualizer is designed for managing multiple database platforms from one place. What it provides:

50+ supported databases
Visual schema management
ER diagram generation
Flexible import and export options

It works well for organizations that manage both traditional and cloud databases.

TablePlus

TablePlus keeps things simple without removing essential functionality. Developers often choose it for:

Native Mac responsiveness
Clean design
Query assistance
Easy data management

It balances speed and usability effectively.

DBeaver

DBeaver is a feature-rich open-source database client. Included capabilities:

Broad database compatibility
SQL productivity features
Visual query tools
Database diagrams

It may require more resources, but it remains a strong free option.

Beekeeper Studio

Beekeeper Studio takes a minimalist approach. Key features include:

Straightforward interface
Fast navigation
AI-powered database assistance
Multi-database connectivity

Some advanced tools are reserved for paid editions.

Which One Should You Choose?

The answer depends on your priorities, for example:

Need broad database coverage? DbVisualizer.
Want a Mac-native experience? TablePlus.
Prefer open source? DBeaver.
Like modern AI-assisted workflows? Beekeeper Studio.

Each tool targets a slightly different workflow.

Conclusion

There are several capable alternatives to MySQL Workbench for macOS users. Whether your focus is database compatibility, interface design, open-source tooling, or workflow simplicity, these tools offer practical options for modern development.

For additional details and the full comparison, read the original article The Best MySQL GUI for macOS: Top 4 Alternatives to Workbench.

DbVisualizer 26.2 with Better AI, Maps for Geodata, and Tab Groups

DbVisualizer — Thu, 25 Jun 2026 10:40:05 +0000

We've just released DbVisualizer 26.2, and this version includes a handful of features aimed at making day-to-day database work smoother.

AI Inside the SQL Editor

One of the biggest changes is that AI is now available directly in SQL Commander.

You can use it to:

Fix SQL syntax errors
Improve existing queries
Generate new SQL

And once the assistant suggests a query, you can run it directly from the AI panel without copying and pasting.

We also added support for models from Anthropic, Google, and OpenAI, so teams can choose the provider that works best for them.

And yes, AI remains completely optional.

Search Database Connections Faster

If your connection tree has become a jungle, this release helps.

You can now search directly in the Databases tab and in the SQL Commander connection selector, making it much easier to jump between databases in larger environments.

See Geospatial Data on a Map

Working with coordinates or spatial datasets?

DbVisualizer can now display query results containing geodata in a built-in map view, giving you a quick visual way to verify and explore location-based data.

Tab Groups Arrive in SQL Commander

For anyone who constantly has too many tabs open (you know who you are), SQL Commander now supports tab groups.

It's a simple addition, but it makes it much easier to organize scripts by project, task, or environment.

Other Nice Additions

A few more things that made it into 26.2:

Improved grid filtering and search
Client-side audit logging
Amazon Athena and InfluxDB support
Vim mode
Visual JSON editing
In-app notifications with the new @notify command
Security and driver updates

There are also plenty of smaller fixes and improvements throughout the application. Download DbVisualizer and try out the new features!

If you'd like to see everything that's included, check out the full release notes, the full list of whats new can be found here.

Happy querying!