Back to all posts

SQL and Schema Tools for macOS: Choosing a SQL Client for Mac

For developers on a Mac who query more than one database engine and share schema work with colleagues on Windows or Linux; Homebrew, JDBC drivers and ER diagrams are assumed knowledge.

On this page

DbSchema Pro lets you see your PostgreSQL database as a diagram and build queries by clicking it, in one Mac app. That makes it the paid PostgreSQL client to pick if you want ER diagrams and a visual query builder. It costs 294 USD once, or 29.40 USD a month. DbSchema reverse-engineers your PostgreSQL schema into an interactive diagram, and Pro adds a Query Builder that writes the SELECT while you click tables and joins. The same installer covers MySQL, MongoDB and 100+ other databases, on macOS, Windows and Linux.

This guide compares five SQL and schema tools that install on macOS. It then shows how to install DbSchema, connect it, and build your first query.

Five SQL clients for Mac, and the one that also builds queries visually

Five SQL clients for Mac install from Homebrew and cover querying. Four of them also draw the schema as a diagram. For a team that runs several engines on several operating systems, DbSchema is the one to install. One kit covers macOS, Windows and Linux, and every edition includes all databases. The free Community Edition has interactive diagrams and the SQL editor.

Here is what each tool is and what it is built for, so you can match them against the engines your team runs.

  • DbSchema 10.6.0: design, document and deploy databases, with a free Community Edition and paid Pro and Architect editions; install it with brew install --cask dbschema[1].
  • MySQL Workbench 8.0.47: a visual tool to design, develop and administer MySQL servers[2].
  • Sequel Ace 6.1.0: MySQL and MariaDB database management, requiring macOS 13 or later[3].
  • DBeaver Community 26.2.4: a universal database tool and SQL client, free and open source[4].
  • pgAdmin 4 9.19: an administration and development platform for PostgreSQL[5].

The version numbers are the ones the Homebrew cask pages served on 5 November 2026. Installing any of the five takes a minute. What separates them is scope: which engines a tool covers, whether it draws the schema, and whether you can hand the design to colleagues on other operating systems.

Four checks decide which SQL client fits your Mac

Four checks separate the SQL clients for Mac: the runtime, Homebrew, the macOS version, and engine scope.

The first check is the runtime. A self-contained package carries its runtime inside the application, so nothing has to be installed first. The install section below shows how DbSchema does this. The second check is Homebrew, and all five pass it: each has a cask with the install command and the current version.

The third check is the macOS requirement. The Sequel Ace cask requires macOS 13 or later[3], and Sequel Ace's own site lists macOS 13.5 or later. The other four casks list only macOS.

The fourth check is scope, and it decides the shortlist. MySQL Workbench works with MySQL, Sequel Ace with MySQL and MariaDB, and pgAdmin 4 with PostgreSQL and EDB Postgres Advanced Server. DbSchema and DBeaver Community cover many engines. One multi-engine tool replaces two installs, two connection setups and two sets of keyboard habits. It also keeps working when a second engine arrives.

DbSchema installs on macOS in three ways, with no Java to set up

DbSchema installs on macOS in three ways, and all three install the same kit.

  1. DMG Installer: download it from the download page, open it, and drag the application into the Applications folder.
  2. TGZ Installer: a compressed archive for when a script, not a person, sets up the machine.
  3. Homebrew: brew install --cask dbschema[1] downloads the cask and runs the installer for you.

The same kit serves Community, Pro and Architect, so the licence decides the edition, not the download. The download page offers one installer for all editions with a 15-day Architect trial. After the trial, the application keeps running as the free Community Edition. Architect adds logical and conceptual design on top of Pro.

Java is not a prerequisite. Each native package carries its own runtime, so there is nothing to install before the first start.

We checked the installed footprint on macOS 26 on Apple Silicon with version 10.5.2 on 11 October 2026. The install folder in /Applications was 614 MB. It held the app, a command-line client and an uninstaller. The bundled runtime was Java 25.0.4.1, and the app's Info.plist set macOS 10.15 as the minimum system version.

Windows and Linux use other packages from the same download page. The guide to installing on Windows, macOS and Linux covers them.

Engine coverage splits the shortlist

Engine coverage is the column that splits the shortlist. DbSchema connects to 100+ SQL and NoSQL databases and downloads the JDBC driver it needs on its own. Its free Community Edition includes MongoDB. DBeaver's documentation lists its MongoDB driver in the Lite, Enterprise and Ultimate editions only.

ToolEngines coveredER diagram from a live databaseHomebrew install
DbSchema100+ SQL and NoSQL, MongoDB in CommunityYes, interactive diagrams (free)brew install --cask dbschema
MySQL WorkbenchMySQLYes, EER diagramsbrew install --cask mysqlworkbench
Sequel AceMySQL and MariaDBNone documentedbrew install --cask sequel-ace
DBeaver CommunityMany SQL engines; MongoDB in paid editionsYes, read-only by defaultbrew install --cask dbeaver-community
pgAdmin 4PostgreSQL and EDB Postgres Advanced ServerYes, the ERD Toolbrew install --cask pgadmin4

What to see: on one engine every row works, but on two or more engines the single-engine rows drop out.

For a deeper look, read the guides to DBeaver alternatives for visual database design and MySQL Workbench alternatives. For the PostgreSQL side, see pgAdmin ER diagrams compared and the best PostgreSQL database tools. For how each editor handles autocomplete and results, see SQL editors compared.

macOS asks two one-time questions on first use

macOS asks two one-time questions when you start using DbSchema. On the first launch, macOS may ask you to confirm opening an application downloaded from the internet. Once you confirm, the application starts and the question does not come back.

The second prompt comes with the first save into ~/Documents. On macOS 15, macOS asks for access to the Documents folder the first time an application writes there. Grant it so DbSchema can read and write .dbs files in that folder. Connecting, reverse-engineering and the SQL editor never touch ~/Documents, so they work either way.

Connect and reverse-engineer your first database in four steps

DbSchema Community Edition works against a live database from the first minute. When you connect, DbSchema downloads the JDBC driver it needs, so there is no driver to find first.

  1. Open the connection dialog and enter the host, database and credentials for one of your engines.
  2. Let the JDBC driver for that engine download.
  3. Reverse-engineer the schema: DbSchema reads tables, columns and foreign keys from the live database and lays them out as an interactive ER diagram.
  4. Open the SQL editor and run queries over the same connection.
A MySQL 8 schema reverse-engineered into an interactive ER diagram: nine tables and one view laid out automatically, every foreign key drawn, solid lines for mandatory and dashed lines for optional relationships
JDBC Drivers Updates dialog tracking one driver per engine, MongoDB, MySQL, PostgreSQL and SQLite, with local, server and backup versions and newer drivers offered from dbschema.com

Each driver lands in its own folder. On the test Mac, the drivers folder held one subfolder per engine connected so far: postgresql-42.7.13.jar for PostgreSQL, mysql-connector-j-26.7.0.jar for MySQL, sqlite-jdbc-3.53.4.0.jar for SQLite, and a MongoDB folder.

Count the objects first, so you know what the diagram should show. On the PostgreSQL 16.14 demo schema used for this article, a count over information_schema.table_constraints with constraint_type = 'FOREIGN KEY' returned 23. The schema also had 14 base tables and 2 views (run on 11 October 2026).

Connecting and reverse-engineering only read the live database. Editing a table in the diagram changes the design model, the copy of the schema DbSchema keeps next to the database. The database itself stays as it is until you compare the model with it and deploy.

Two boxes, the PostgreSQL database on the left and the design model with its diagram on the right. The upper arrow, from database to model, is reading: connect, reverse-engineer and run queries, all in the free Community Edition. Edits on the diagram change only the model. The lower arrow, highlighted, from model back to database, is deploying: compare the model with the database, read the generated script and run it; saving the model and synchronization are in Pro.
Reading the database is free in the Community Edition; saving the model and deploying it back are in DbSchema Pro.

Saving that model to a file, and opening a saved file again, needs Pro. The editions page says the Community edition cannot open saved project files. Everything that only reads the database stays free: connect, reverse-engineer, draw the diagram and run queries. The free SQL client in Community Edition page lists where the free boundary sits.

Build a PostgreSQL query by clicking the diagram

A visual query builder writes the SQL while you click. In DbSchema Pro it is the Query Builder, which the menus call the Query Editor. Right-click a PostgreSQL table on the diagram and choose Query Editor, or press Ctrl + B with the table selected.

DbSchema Query Builder on a PostgreSQL demo database: tasks joined to users through tasks_created_by_fkey, columns ticked per table, and the generated SQL shown next to the diagram

Click the icon next to a key column to list the tables linked to it, then pick one to join. DbSchema builds the join from the foreign key, so you never type the join condition. Untick the columns you don't need and press Run. The SQL updates with every click, and the result grid shows the rows.

Two table cards from the PostgreSQL 16.14 demo schema. tasks has a created_by column, highlighted in teal, with a foreign key named tasks_created_by_fkey that points to users.id. The Query Builder reads this constraint, so the join between tasks and users is written without typing the condition.
You pick users from tasks.created_by, and the Query Builder takes the join condition from tasks_created_by_fkey. The Query Builder is in DbSchema Pro.

Most Mac clients in the table stop at the SQL editor. pgAdmin 4 says its graphical query builder is not supported at the moment, and Oracle says it has no plans to add a visual query designer to MySQL Workbench. More builders are compared in visual query builders compared.

A .dbs model opens unchanged on Windows and Linux

You share a schema model across macOS, Windows and Linux as a .dbs file, which is plain indented XML. A file written on a Mac opens unchanged on Windows and Linux, with no conversion step. Because it is XML, it diffs line by line in Git.

So a schema change made on a Mac lands in a colleague's pull request as a readable diff, next to the application code. It gets reviewed before it reaches production data. Saving and opening the file both need Pro, so each colleague who works on the model needs a Pro licence or the trial.

The file holds the whole design: tables, relations, diagrams and layouts. A colleague who opens it in Pro sees the same diagrams instead of rebuilding them.

You can check the format yourself. A model saved from the MySQL demo database reports as XML 1.0 document text in the macOS file command. Its first lines are an XML declaration, then a project element named MySql, a schema element named taskapp, and one tab-indented column element per column (inspected on 11 October 2026).

With Pro, the model becomes the file your whole team versions. Pro also has a Git client of its own, so you clone, stage, commit and push the model without leaving DbSchema.

Git window in DbSchema Pro for a .dbs model inside a Git working copy: the repository and its remote read from the file location, the commit graph with author and date, and commit author fields taken from the repository's git config

For PostgreSQL on a Mac with diagrams and a query builder, pick DbSchema Pro

For PostgreSQL work on a Mac, DbSchema Pro gives you the diagram, the Query Builder and the SQL editor in one app. One installation also covers every other engine, with MongoDB included in the free edition. The JDBC drivers download on their own, and the design travels between operating systems as a .dbs file that diffs in Git.

The single-engine clients cover less. MySQL Workbench works with MySQL only, pgAdmin 4 with PostgreSQL and EDB Postgres Advanced Server. DBeaver's MongoDB driver is not part of its free Community edition.

Download the macOS DMG from https://dbschema.com/download.html, or run brew install --cask dbschema. Connect to your PostgreSQL database and reverse-engineer it into diagrams in the free Community Edition. The Query Builder and saving the model for your colleagues are in DbSchema Pro, and the 15-day trial covers both.

Frequently asked questions

What is the best free SQL client for Mac?

For more than one database engine, DbSchema Community Edition. It is free on macOS and covers all databases, connecting and reverse-engineering, interactive diagrams and the SQL editor. Sequel Ace covers MySQL and MariaDB only and requires macOS 13.5 or later.

Can I install DbSchema with Homebrew?

Yes. brew install --cask dbschema downloads the 10.6.0 DMG[1] and runs the DbSchema installer. The cask lists macOS as its only requirement. The DMG Installer and the TGZ archive on the download page install the same kit.

Does DbSchema need Java on macOS?

No. The macOS package carries its own runtime inside the application, so you install nothing separately. On the first launch macOS may ask you to confirm opening an application downloaded from the internet. Confirm it once.

Sources

  1. formulae.brew.sh
  2. formulae.brew.sh
  3. formulae.brew.sh
  4. formulae.brew.sh
  5. formulae.brew.sh

Install DbSchema on your Mac

One installation kit for macOS, Windows and Linux. Connect to your database, reverse-engineer it into interactive diagrams and run SQL in the free Community Edition; the download includes a 15-day Architect trial.