Databases 5 min read

How to Install and Use SQLECTRON: A Lightweight Cross‑Platform SQL Client

SQLECTRON is a simple, lightweight cross‑platform SQL client supporting MySQL, PostgreSQL, SQL Server, SQLite and Cassandra; this guide walks through installing the v1.30.0 desktop app on macOS, configuring servers, executing queries, exporting results, and highlights its terminal variant and comparison with heavier tools.

macrozheng
macrozheng
macrozheng
How to Install and Use SQLECTRON: A Lightweight Cross‑Platform SQL Client

SQLECTRON

A simple lightweight SQL client for desktop/terminal with cross-database and cross-platform support.

It runs on Linux, macOS and Windows, allowing you to connect to various databases.

Installation and Usage

The version used in this article is

v1.30.0

. Download the installer, drag the app into the Applications folder, and the installation is complete.

Add a server by providing the required information. The supported database types are:

MySQL

PostgreSQL

Microsoft SQL Server

SQLite

Cassandra

Test the connection and click

Save

.

Select the server, click

Connect

, and run a SQL query.

After execution you can copy results as JSON or CSV, or export them to files.

Using SQLECTRON to explain a query gives a clean visual output.

Compared with heavier tools like DataGrip, SQLECTRON meets basic needs for users who do not rely heavily on advanced client features.

If you prefer a terminal interface, SQLECTRON also offers

SQLECTRON-TERM

. Install it with a single command (Node.js required):

<code>npm install -g sqlectron-term</code>

The project has few GitHub stars and is maintained by an owner who lost interest, making it a good opportunity for contributors to gain experience.

Conclusion

For everyday basic SQL execution, SQLECTRON fully satisfies the need without requiring a paid DataGrip or Navicat license, and it runs efficiently without heavy CPU load.

If you are interested in contributing, maintaining the project offers a valuable learning experience.

Cross‑Platformquery executioninstallationDatabase ToolsSQL clientSQLECTRON
macrozheng
Written by

macrozheng

Dedicated to Java tech sharing and dissecting top open-source projects. Topics include Spring Boot, Spring Cloud, Docker, Kubernetes and more. Author’s GitHub project “mall” has 50K+ stars.

0 followers
Reader feedback

How this landed with the community

login Sign in to like

Rate this article

Was this worth your time?

Sign in to rate
Discussion

0 Comments

Thoughtful readers leave field notes, pushback, and hard-won operational detail here.