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.
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.
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.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.