Sqlectron for MAC

Free, open-source SQL client for Mac: a simple, lightweight app for PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, Redshift and Cassandra.

Sqlectron Overview

Sqlectron is a free, open-source SQL client for Mac, described by its makers as simple and lightweight, with support across databases and platforms. It gives you one app for several database systems: PostgreSQL, Redshift, MySQL, MariaDB, Microsoft SQL Server and SQLite, plus Cassandra, which is a NoSQL database and comes with some exceptions noted by the project. The same app is available for Windows and Linux, so a team on mixed computers can use one tool.

You keep your list of servers in the app and work in its query box, which has auto-complete. Settings are stored in a configuration file in ~/Library/Preferences/Sqlectron on a Mac, but the project recommends changing them through the app. From there you can change the zoom factor, the row limit of the default select (100 by default) and the auto-complete options, and turn on logging, which is off by default. A separate terminal version exists as its own project for people who prefer the command line.

Sqlectron is made by the SQLECTRON team under the MIT licence. Version 1.39.0 adds an Apple Silicon build for Mac, ed25519 authentication for MariaDB, and fixes for a search crash and for resizing the server sidebar. The project does not publish a minimum macOS version beyond dropping 10.11 and 10.12 in this release. There are separate downloads for Apple Silicon and Intel Macs.

Key Features

Sqlectron keeps database work in one small app.

  • Many databases: PostgreSQL, MySQL, MariaDB, SQL Server, SQLite and Redshift.
  • Cassandra: NoSQL support, with exceptions noted by the project.
  • Saved servers: keep your list of connections in the app.
  • Query box: write and run SQL with auto-complete.
  • Row limit: set how many rows the default select returns.
  • Zoom: change the zoom factor to suit your screen.
  • Logging: optional logs, off by default, for tracking down problems.
  • Cross-platform: also available for Windows and Linux.

What’s New in Version 1.39.0

Sqlectron 1.39.0 adds an Apple Silicon build for Mac.

  • Apple Silicon (arm64) dmg for macOS
  • ed25519 authentication for MariaDB
  • App icon updated to the Big Sur style
  • Fixed a search crash
  • Fixed resizing of the server sidebar
  • macOS 10.11 and 10.12 are no longer supported

Sqlectron FAQ

Is Sqlectron free?

Yes. Sqlectron is free and open source under the MIT licence.

Which databases does Sqlectron support?

PostgreSQL, Redshift, MySQL, MariaDB, Microsoft SQL Server, SQLite and Cassandra. Cassandra is a NoSQL database, and the project notes some exceptions for it.

Does Sqlectron run on Apple Silicon?

Yes. Version 1.39.0 has a separate download for Apple Silicon Macs, and another for Intel Macs.

Which macOS version does Sqlectron need?

The project does not state a minimum version. It says only that macOS 10.11 and 10.12 are no longer supported.

Is Sqlectron available for other systems?

Yes. It is also available for Windows and Linux.

Does Sqlectron have auto-complete?

Yes. The query box has auto-complete and live auto-complete, and both can be turned off in the settings.

Where does Sqlectron keep its settings on a Mac?

In a configuration file in ~/Library/Preferences/Sqlectron. The project recommends changing settings through the app.

Is there a command-line version?

Yes. A terminal-based interface exists as a separate project, sqlectron-term. This post covers the desktop app.

Can I install Sqlectron with Homebrew?

Yes. The Homebrew cask is called sqlectron.

Where does the Sqlectron download on sqlectron.FULLMAC.app come from?

The download button leads to the official Sqlectron releases on GitHub at https://github.com/sqlectron/sqlectron-gui/releases/latest. sqlectron.FULLMAC.app does not change or repackage the app.

Similar Apps

FULLMAC.app does not host this app. Download buttons lead to the developer’s own pages.